Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (dt, STORE, PRODUCT) AS
SELECT DATE '2020-01-01', 'Store1', 'Product1' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store1', 'Product2' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store1', 'Product3' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store1', 'Product4' FROM DUAL UNION ALL
SELECT DATE '2020-02-01', 'Store1', 'Product5' FROM DUAL UNION ALL
SELECT DATE '2020-02-01', 'Store1', 'Product6' FROM DUAL UNION ALL
SELECT DATE '2020-02-01', 'Store1', 'Product7' FROM DUAL UNION ALL
SELECT DATE '2020-02-01', 'Store1', 'Product8' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store2', 'Product1' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store2', 'Product2' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store2', 'Product3' FROM DUAL UNION ALL
SELECT DATE '2020-01-01', 'Store2', 'Product4' FROM DUAL UNION ALL
SELECT DATE '2020-01-03', 'Store2', 'Product1' FROM DUAL UNION ALL
SELECT DATE '2020-03-01', 'Store2', 'Product2' FROM DUAL UNION ALL
SELECT DATE '2020-03-02', 'Store2', 'Product8' FROM DUAL UNION ALL
SELECT DATE '2020-03-03', 'Store2', 'Product10' FROM DUAL UNION ALL
SELECT DATE '2020-08-06', 'Store2', 'Product6' FROM DUAL UNION ALL
SELECT DATE '2020-11-08', 'Store2', 'Product7' FROM DUAL;
18 rows affected

SELECT dt,
       store,
       product,
       DENSE_RANK() OVER (ORDER BY store) || LPAD('e', mn - 1, 'e') AS tt
FROM   table_name
       MATCH_RECOGNIZE(
         PARTITION BY store
         ORDER BY dt, product
         MEASURES
           MATCH_NUMBER() AS mn
         ALL ROWS PER MATCH
         PATTERN (first_row within_20_day* )
         DEFINE
           within_20_day AS dt <= FIRST(dt) + INTERVAL '20' DAY
       )


DT
STORE
PRODUCT
TT


2020-01-01 00:00:00
Store1
Product1
1

2020-01-01 00:00:00
Store1
Product2
1

2020-01-01 00:00:00
Store1
Product3
1

2020-01-01 00:00:00
Store1
Product4
1

2020-02-01 00:00:00
Store1
Product5
1e

2020-02-01 00:00:00
Store1
Product6
1e

2020-02-01 00:00:00
Store1
Product7
1e

2020-02-01 00:00:00
Store1
Product8
1e

2020-01-01 00:00:00
Store2
Product1
2

2020-01-01 00:00:00
Store2
Product2
2

2020-01-01 00:00:00
Store2
Product3
2

2020-01-01 00:00:00
Store2
Product4
2

2020-01-03 00:00:00
Store2
Product1
2

2020-03-01 00:00:00
Store2
Product2
2e

2020-03-02 00:00:00
Store2
Product8
2e

2020-03-03 00:00:00
Store2
Product10
2e

2020-08-06 00:00:00
Store2
Product6
2ee

2020-11-08 00:00:00
Store2
Product7
2eee


SELECT Package_Name.Compute( p_RecordIn => package_name.t_RecordType('X') ).dummy from dual
ORA-00904: "PACKAGE_NAME"."COMPUTE": invalid identifier

DECLARE
  v_rec_i package_name.t_RecordType;
  v_rec_o package_name.t_RecordType;
BEGIN
  v_rec_i.dummy := 'X';
  v_rec_o := Package_Name.Compute( p_RecordIn => v_rec_i );
  DBMS_OUTPUT.PUT_LINE(v_rec_o.dummy);
END;
/
ORA-06550: line 2, column 11:
PLS-00201: identifier 'PACKAGE_NAME.T_RECORDTYPE' must be declared
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

CREATE TYPE t_ObjectType IS OBJECT(
  dummy VARCHAR2(10)
);
CREATE FUNCTION compute(
  p_ObjectIn IN t_ObjectType
) RETURN t_ObjectType
IS
BEGIN
  return p_ObjectIn;
END;
/
SELECT * FROM USER_ERRORS;
SELECT Compute( p_ObjectIn => t_ObjectType('X') ).dummy from dual


COMPUTE(P_OBJECTIN=>T_OBJECTTYPE('X')).DUMMY


X


SELECT Compute( t_ObjectType('X') ).dummy from dual


COMPUTE(T_OBJECTTYPE('X')).DUMMY


X

DT	STORE	PRODUCT	TT
2020-01-01 00:00:00	Store1	Product1	1
2020-01-01 00:00:00	Store1	Product2	1
2020-01-01 00:00:00	Store1	Product3	1
2020-01-01 00:00:00	Store1	Product4	1
2020-02-01 00:00:00	Store1	Product5	1e
2020-02-01 00:00:00	Store1	Product6	1e
2020-02-01 00:00:00	Store1	Product7	1e
2020-02-01 00:00:00	Store1	Product8	1e
2020-01-01 00:00:00	Store2	Product1	2
2020-01-01 00:00:00	Store2	Product2	2
2020-01-01 00:00:00	Store2	Product3	2
2020-01-01 00:00:00	Store2	Product4	2
2020-01-03 00:00:00	Store2	Product1	2
2020-03-01 00:00:00	Store2	Product2	2e
2020-03-02 00:00:00	Store2	Product8	2e
2020-03-03 00:00:00	Store2	Product10	2e
2020-08-06 00:00:00	Store2	Product6	2ee
2020-11-08 00:00:00	Store2	Product7	2eee