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.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_PROCESS_PHASES

Line 228: cst_pac_process_phases

224: SELECT
225: process_status
226: INTO x_status
227: FROM
228: cst_pac_process_phases
229: WHERE pac_period_id = p_pac_period_id
230: AND process_phase = p_phase
231: AND rownum = 1;
232: ELSE

Line 237: cst_pac_process_phases

233: SELECT
234: process_status
235: INTO x_status
236: FROM
237: cst_pac_process_phases
238: WHERE pac_period_id = p_pac_period_id
239: AND process_phase = p_phase
240: AND cost_group_id = p_cost_group_id;
241: END IF;

Line 266: -- Note that process upto date is stored in CST_PAC_PROCESS_PHASES.

262: -- FUNCTION Find_Prev_Process_Upto_Date PRIVATE
263: -- PARAMETERS: p_pac_period_id IN NUMBER
264: -- RETURN x_process_upto_date OUT NOCOPY DATE
265: -- This function retrieves Process Upto Date used in first iteration
266: -- Note that process upto date is stored in CST_PAC_PROCESS_PHASES.
267: -- This function is invoked only during consecutive iterations
268: -- =========================================================================
269: FUNCTION Find_Prev_Process_Upto_Date
270: (p_pac_period_id IN NUMBER)

Line 283: cst_pac_process_phases

279: IS
280: SELECT
281: TO_CHAR(process_upto_date, 'YYYY/MM/DD HH24:MI:SS')
282: FROM
283: cst_pac_process_phases
284: WHERE pac_period_id = c_pac_period_id
285: AND process_phase = 7;
286:
287: -- variables for process upto date

Line 897: FROM cst_pac_process_phases

893: ELSE
894: -- Run Options: 2 Resume from error
895: SELECT nvl(min(process_phase), 1)
896: INTO l_starting_phase
897: FROM cst_pac_process_phases
898: WHERE pac_period_id = p_period_id
899: AND cost_group_id = p_cost_group_id
900: AND process_status = 3
901: AND ( process_phase <= 5 OR process_phase = 7);

Line 909: FROM cst_pac_process_phases

905: IF l_starting_phase = 7 THEN
906:
907: SELECT nvl(min(process_phase), 7)
908: INTO l_starting_phase
909: FROM cst_pac_process_phases
910: WHERE pac_period_id = p_period_id
911: AND cost_group_id = p_cost_group_id
912: AND process_status = 3
913: AND process_phase IN (8);

Line 918: FROM cst_pac_process_phases

914:
915: SELECT
916: count(1)
917: INTO l_count
918: FROM cst_pac_process_phases
919: WHERE pac_period_id = p_period_id
920: AND cost_group_id = p_cost_group_id
921: AND process_phase = 5
922: AND process_upto_date <= p_end_date;

Line 928: FROM cst_pac_process_phases

924: ELSIF l_starting_phase <= 5 THEN
925: SELECT
926: count(1)
927: INTO l_count
928: FROM cst_pac_process_phases
929: WHERE pac_period_id = p_period_id
930: AND cost_group_id = p_cost_group_id
931: AND process_phase = l_starting_phase - 1
932: AND process_upto_date <= p_end_date;

Line 1253: UPDATE cst_pac_process_phases

1249: WHERE ccga.cost_group_id = p_cost_group_id;
1250:
1251: IF l_num_of_assignments = 0 THEN
1252:
1253: UPDATE cst_pac_process_phases
1254: SET process_status = 3,
1255: process_date = SYSDATE,
1256: last_update_date = SYSDATE,
1257: last_updated_by = p_user_id,

Line 1363: FROM cst_pac_process_phases cppp

1359: AND ccg.cost_group_id = p_cost_group_id
1360: AND trunc(nvl(ccg.disable_date, SYSDATE+1)) > trunc(SYSDATE)
1361: AND EXISTS (
1362: SELECT 'X'
1363: FROM cst_pac_process_phases cppp
1364: WHERE cppp.cost_group_id = ccg.cost_group_id
1365: AND cppp.pac_period_id = p_period_id);
1366:
1367: IF l_count = 0

Line 1472: FROM cst_pac_process_phases

1468: END IF;
1469:
1470: SELECT count(1)
1471: INTO l_count
1472: FROM cst_pac_process_phases
1473: WHERE cost_group_id = p_cost_group_id
1474: AND pac_period_id = p_period_id;
1475:
1476: IF l_count <> 8

Line 3159: FROM cst_pac_process_phases cppp

3155: SELECT count(1)
3156: INTO l_count_rows
3157: FROM mtl_material_transactions mmt
3158: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
3159: FROM cst_pac_process_phases cppp
3160: WHERE
3161: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3162: AND cppp.process_upto_date IS NOT NULL)
3163: AND cppp.pac_period_id = p_pac_period_id

Line 3190: FROM cst_pac_process_phases cppp

3186: SELECT count(1)
3187: INTO l_count_rows
3188: FROM wip_transactions wt
3189: WHERE wt.creation_date > ( SELECT MIN(cppp.process_date)
3190: FROM cst_pac_process_phases cppp
3191: WHERE
3192: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3193: AND cppp.process_upto_date IS NOT NULL)
3194: AND cppp.pac_period_id = p_pac_period_id

Line 3221: FROM cst_pac_process_phases cppp

3217: SELECT count(1)
3218: INTO l_count_rows
3219: FROM rcv_transactions rt
3220: WHERE rt.creation_date > (SELECT MIN(cppp.process_date)
3221: FROM cst_pac_process_phases cppp
3222: WHERE
3223: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3224: AND cppp.process_upto_date IS NOT NULL)
3225: AND cppp.pac_period_id = p_pac_period_id

Line 3252: FROM cst_pac_process_phases cppp

3248: SELECT count(1)
3249: INTO l_count_rows
3250: FROM rcv_accounting_events rae
3251: WHERE rae.creation_date > ( SELECT MIN(cppp.process_date)
3252: FROM cst_pac_process_phases cppp
3253: WHERE
3254: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3255: AND cppp.process_upto_date IS NOT NULL)
3256: AND cppp.pac_period_id = p_pac_period_id