140: NVL(FND_PROFILE.VALUE('CST_RU_PHANTOM_MATERIAL')
141: ,1)
142: INTO P_PHANTOM_MAT
143: FROM
144: DUAL;
145: L_STMT_NUM := 30;
146: IF P_ROLLUP_ID IS NOT NULL THEN
147: L_RERUN_FLAG := 1;
148: L_STMT_NUM := 40;
181: SELECT
182: CST_LISTS_S.NEXTVAL
183: INTO P_ROLLUP_ID
184: FROM
185: DUAL;
186: L_STMT_NUM := 60;
187: IF (LP_REPORT_OPTION_TYPE <> -1) THEN
188: INSERT INTO CST_SC_ROLLUP_HISTORY
189: (ROLLUP_ID
310: TO_CHAR(SYSDATE
311: ,'YYYY/MM/DD HH24:MI:ss')
312: INTO LP_REVISION_DATE
313: FROM
314: DUAL;
315: END IF;
316: L_STMT_NUM := 100;
317: SELECT
318: CCT1.COST_TYPE,
761: SELECT
762: sysdate
763: INTO L_TIMESTAMP
764: FROM
765: DUAL;
766: /*SRW.MESSAGE(0
767: ,'Before CSTPSCEX.supply_chain_rollup ' || TO_CHAR(L_TIMESTAMP
768: ,'YYYY/MM/DD HH24:MI:SS'))*/NULL;
769: L_STMT_NUM := 230;
797: SELECT
798: sysdate
799: INTO L_TIMESTAMP
800: FROM
801: DUAL;
802: /*SRW.MESSAGE(0
803: ,'After CSTPSCEX.supply_chain_rollup ' || TO_CHAR(L_TIMESTAMP
804: ,'YYYY/MM/DD HH24:MI:SS'))*/NULL;
805: L_STMT_NUM := 250;