eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPPSC dependencies on CST_PAC_PROCESS_PHASES

Line 258: /* the cst_pac_process_phases table. However the row inserted into */

254: rollback;
255:
256: /* **************************************************************************** */
257: /* In case of an error, rollback will take care of the unwanted rows in */
258: /* the cst_pac_process_phases table. However the row inserted into */
259: /* cst_pac_periods have already been commited, hence need to be explicitly */
260: /* deleted. The section below does that... */
261: /* **************************************************************************** */
262: l_stmt_num := 20;

Line 499: /* cst_pac_process_phases */

495: /* START OPENING THE PERIOD. The steps are... */
496: /* 1. Insert into cst_pac_periods form gl_periods table */
497: /* 2. For each an every cost group defined in the legal entity */
498: /* Insert five rows for five process statuses into */
499: /* cst_pac_process_phases */
500: /* **************************************************************************** */
501:
502:
503:

Line 612: /* cst_pac_process_phases table */

608:
609:
610: /* **************************************************************************** */
611: /* Insert a row for each and every cost group and phases into */
612: /* cst_pac_process_phases table */
613: /* **************************************************************************** */
614:
615: l_stmt_num := 50;
616: INSERT INTO cst_pac_process_phases (

Line 616: INSERT INTO cst_pac_process_phases (

612: /* cst_pac_process_phases table */
613: /* **************************************************************************** */
614:
615: l_stmt_num := 50;
616: INSERT INTO cst_pac_process_phases (
617: pac_period_id,
618: cost_group_id,
619: process_phase,
620: process_status,

Line 672: delete from cst_pac_process_phases where pac_period_id = dummy_id;

668: /* Duplicate open period found */
669: duplicate_open_period := true;
670: commit_complete := false;
671: rollback to before_process_phases_table;
672: delete from cst_pac_process_phases where pac_period_id = dummy_id;
673: goto error_label;
674: else
675: /* No Duplicating rows found */
676: duplicate_open_period := false;

Line 719: /* the cst_pac_process_phases table. However the row inserted into */

715: rollback;
716:
717: /* **************************************************************************** */
718: /* In case of an error, rollback will take care of the unwanted rows in */
719: /* the cst_pac_process_phases table. However the row inserted into */
720: /* cst_pac_periods have already been commited, hence need to be explicitly */
721: /* deleted. The section below does that... */
722: /* **************************************************************************** */
723:

Line 896: FROM cst_pac_process_phases cppp

892: l_cost_type_id NUMBER) IS
893: SELECT count(1)
894: FROM mtl_material_transactions mmt
895: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
896: FROM cst_pac_process_phases cppp
897: WHERE
898: (( cppp.process_phase <= 5
899: AND cppp.process_upto_date IS NOT NULL)
900: OR

Line 938: FROM cst_pac_process_phases cppp

934: l_cost_type_id NUMBER) IS
935: SELECT count(1)
936: FROM wip_transactions wt
937: WHERE wt.creation_date > ( SELECT MIN(cppp.process_date)
938: FROM cst_pac_process_phases cppp
939: WHERE
940: (( cppp.process_phase <= 5
941: AND cppp.process_upto_date IS NOT NULL)
942: OR

Line 981: FROM cst_pac_process_phases cppp

977: l_cost_type_id NUMBER) IS
978: SELECT count(1)
979: FROM rcv_transactions rt
980: WHERE rt.creation_date > ( SELECT MIN(cppp.process_date)
981: FROM cst_pac_process_phases cppp
982: WHERE
983: (( cppp.process_phase <= 5
984: AND cppp.process_upto_date IS NOT NULL)
985: OR

Line 1023: FROM cst_pac_process_phases cppp

1019: l_cost_type_id NUMBER) IS
1020: SELECT count(1)
1021: FROM rcv_accounting_events rae
1022: WHERE rae.creation_date > ( SELECT MIN(cppp.process_date)
1023: FROM cst_pac_process_phases cppp
1024: WHERE
1025: (( cppp.process_phase <= 5
1026: AND cppp.process_upto_date IS NOT NULL)
1027: OR

Line 1066: FROM cst_pac_process_phases cppp

1062: l_cost_type_id NUMBER) IS
1063: SELECT count(1)
1064: FROM cst_lc_adj_transactions clat
1065: WHERE clat.creation_date > ( SELECT MIN(cppp.process_date)
1066: FROM cst_pac_process_phases cppp
1067: WHERE
1068: (( cppp.process_phase <= 5
1069: AND cppp.process_upto_date IS NOT NULL)
1070: OR

Line 1340: FROM cst_pac_process_phases

1336: /* Bug 3591905. The following Select statement was checking for process_phase < 5 instead of process_phase <= 5 */
1337: l_stmt_num := 20;
1338: SELECT count(1)
1339: INTO count_rows
1340: FROM cst_pac_process_phases
1341: WHERE pac_period_id = closing_pac_period_id
1342: AND cost_group_id = current_cost_group_id
1343: AND (( process_status <> 4
1344: AND process_phase <= 5

Line 1365: FROM cst_pac_process_phases

1361: if ( count_rows <> 0) then
1362:
1363: SELECT distinct NVL(pac_period_id,0)
1364: INTO dummy_id
1365: FROM cst_pac_process_phases
1366: WHERE pac_period_id = closing_pac_period_id
1367: AND cost_group_id = current_cost_group_id
1368: AND (( process_status <> 4
1369: AND process_phase <= 5

Line 1400: FROM cst_pac_process_phases

1396: rerun_process_date := trunc(closing_end_date)+1;
1397:
1398: SELECT count(1)
1399: INTO count_rows
1400: FROM cst_pac_process_phases
1401: WHERE pac_period_id = closing_pac_period_id
1402: AND cost_group_id = current_cost_group_id
1403: AND (
1404: (( process_date < trunc(closing_end_date)+1