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 287: /* the cst_pac_process_phases table. However the row inserted into */

283: rollback;
284:
285: /* **************************************************************************** */
286: /* In case of an error, rollback will take care of the unwanted rows in */
287: /* the cst_pac_process_phases table. However the row inserted into */
288: /* cst_pac_periods have already been commited, hence need to be explicitly */
289: /* deleted. The section below does that... */
290: /* **************************************************************************** */
291: l_stmt_num := 20;

Line 528: /* cst_pac_process_phases */

524: /* START OPENING THE PERIOD. The steps are... */
525: /* 1. Insert into cst_pac_periods form gl_periods table */
526: /* 2. For each an every cost group defined in the legal entity */
527: /* Insert five rows for five process statuses into */
528: /* cst_pac_process_phases */
529: /* **************************************************************************** */
530:
531:
532:

Line 641: /* cst_pac_process_phases table */

637:
638:
639: /* **************************************************************************** */
640: /* Insert a row for each and every cost group and phases into */
641: /* cst_pac_process_phases table */
642: /* **************************************************************************** */
643:
644: l_stmt_num := 50;
645: INSERT INTO cst_pac_process_phases (

Line 645: INSERT INTO cst_pac_process_phases (

641: /* cst_pac_process_phases table */
642: /* **************************************************************************** */
643:
644: l_stmt_num := 50;
645: INSERT INTO cst_pac_process_phases (
646: pac_period_id,
647: cost_group_id,
648: process_phase,
649: process_status,

Line 701: delete from cst_pac_process_phases where pac_period_id = dummy_id;

697: /* Duplicate open period found */
698: duplicate_open_period := true;
699: commit_complete := false;
700: rollback to before_process_phases_table;
701: delete from cst_pac_process_phases where pac_period_id = dummy_id;
702: goto error_label;
703: else
704: /* No Duplicating rows found */
705: duplicate_open_period := false;

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

744: rollback;
745:
746: /* **************************************************************************** */
747: /* In case of an error, rollback will take care of the unwanted rows in */
748: /* the cst_pac_process_phases table. However the row inserted into */
749: /* cst_pac_periods have already been commited, hence need to be explicitly */
750: /* deleted. The section below does that... */
751: /* **************************************************************************** */
752:

Line 955: FROM cst_pac_process_phases cppp

951: l_cost_type_id NUMBER) IS
952: SELECT count(1)
953: FROM mtl_material_transactions mmt
954: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
955: FROM cst_pac_process_phases cppp
956: WHERE
957: (( cppp.process_phase <= 5
958: AND cppp.process_upto_date IS NOT NULL)
959: OR

Line 997: FROM cst_pac_process_phases cppp

993: l_cost_type_id NUMBER) IS
994: SELECT count(1)
995: FROM wip_transactions wt
996: WHERE wt.creation_date > ( SELECT MIN(cppp.process_date)
997: FROM cst_pac_process_phases cppp
998: WHERE
999: (( cppp.process_phase <= 5
1000: AND cppp.process_upto_date IS NOT NULL)
1001: OR

Line 1040: FROM cst_pac_process_phases cppp

1036: l_cost_type_id NUMBER) IS
1037: SELECT count(1)
1038: FROM rcv_transactions rt
1039: WHERE rt.creation_date > ( SELECT MIN(cppp.process_date)
1040: FROM cst_pac_process_phases cppp
1041: WHERE
1042: (( cppp.process_phase <= 5
1043: AND cppp.process_upto_date IS NOT NULL)
1044: OR

Line 1082: FROM cst_pac_process_phases cppp

1078: l_cost_type_id NUMBER) IS
1079: SELECT count(1)
1080: FROM rcv_accounting_events rae
1081: WHERE rae.creation_date > ( SELECT MIN(cppp.process_date)
1082: FROM cst_pac_process_phases cppp
1083: WHERE
1084: (( cppp.process_phase <= 5
1085: AND cppp.process_upto_date IS NOT NULL)
1086: OR

Line 1125: FROM cst_pac_process_phases cppp

1121: l_cost_type_id NUMBER) IS
1122: SELECT count(1)
1123: FROM cst_lc_adj_transactions clat
1124: WHERE clat.creation_date > ( SELECT MIN(cppp.process_date)
1125: FROM cst_pac_process_phases cppp
1126: WHERE
1127: (( cppp.process_phase <= 5
1128: AND cppp.process_upto_date IS NOT NULL)
1129: OR

Line 1419: FROM cst_pac_process_phases

1415: /* Bug 3591905. The following Select statement was checking for process_phase < 5 instead of process_phase <= 5 */
1416: l_stmt_num := 20;
1417: SELECT count(1)
1418: INTO count_rows
1419: FROM cst_pac_process_phases
1420: WHERE pac_period_id = closing_pac_period_id
1421: AND cost_group_id = current_cost_group_id
1422: AND (( process_status <> 4
1423: AND process_phase <= 5

Line 1444: FROM cst_pac_process_phases

1440: if ( count_rows <> 0) then
1441:
1442: SELECT distinct NVL(pac_period_id,0)
1443: INTO dummy_id
1444: FROM cst_pac_process_phases
1445: WHERE pac_period_id = closing_pac_period_id
1446: AND cost_group_id = current_cost_group_id
1447: AND (( process_status <> 4
1448: AND process_phase <= 5

Line 1479: FROM cst_pac_process_phases

1475: rerun_process_date := trunc(closing_end_date)+1;
1476:
1477: SELECT count(1)
1478: INTO count_rows
1479: FROM cst_pac_process_phases
1480: WHERE pac_period_id = closing_pac_period_id
1481: AND cost_group_id = current_cost_group_id
1482: AND (
1483: (( process_date < trunc(closing_end_date)+1