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 208: cst_pac_process_phases

204: SELECT
205: process_status
206: INTO x_status
207: FROM
208: cst_pac_process_phases
209: WHERE pac_period_id = p_pac_period_id
210: AND process_phase = p_phase
211: AND rownum = 1;
212: ELSE

Line 217: cst_pac_process_phases

213: SELECT
214: process_status
215: INTO x_status
216: FROM
217: cst_pac_process_phases
218: WHERE pac_period_id = p_pac_period_id
219: AND process_phase = p_phase
220: AND cost_group_id = p_cost_group_id;
221: END IF;

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

242: -- FUNCTION Find_Prev_Process_Upto_Date PRIVATE
243: -- PARAMETERS: p_pac_period_id IN NUMBER
244: -- RETURN x_process_upto_date OUT NOCOPY DATE
245: -- This function retrieves Process Upto Date used in first iteration
246: -- Note that process upto date is stored in CST_PAC_PROCESS_PHASES.
247: -- This function is invoked only during consecutive iterations
248: -- =========================================================================
249: FUNCTION Find_Prev_Process_Upto_Date
250: (p_pac_period_id IN NUMBER)

Line 263: cst_pac_process_phases

259: IS
260: SELECT
261: TO_CHAR(process_upto_date, 'YYYY/MM/DD HH24:MI:SS')
262: FROM
263: cst_pac_process_phases
264: WHERE pac_period_id = c_pac_period_id
265: AND process_phase = 7;
266:
267: -- variables for process upto date

Line 895: FROM cst_pac_process_phases

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

Line 907: FROM cst_pac_process_phases

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

Line 916: FROM cst_pac_process_phases

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

Line 926: FROM cst_pac_process_phases

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

Line 1251: UPDATE cst_pac_process_phases

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

Line 1361: FROM cst_pac_process_phases cppp

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

Line 1470: FROM cst_pac_process_phases

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

Line 3214: FROM cst_pac_process_phases cppp

3210: SELECT count(1)
3211: INTO l_count_rows
3212: FROM mtl_material_transactions mmt
3213: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
3214: FROM cst_pac_process_phases cppp
3215: WHERE
3216: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3217: AND cppp.process_upto_date IS NOT NULL)
3218: AND cppp.pac_period_id = p_pac_period_id

Line 3245: FROM cst_pac_process_phases cppp

3241: SELECT count(1)
3242: INTO l_count_rows
3243: FROM wip_transactions wt
3244: WHERE wt.creation_date > ( SELECT MIN(cppp.process_date)
3245: FROM cst_pac_process_phases cppp
3246: WHERE
3247: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3248: AND cppp.process_upto_date IS NOT NULL)
3249: AND cppp.pac_period_id = p_pac_period_id

Line 3276: FROM cst_pac_process_phases cppp

3272: SELECT count(1)
3273: INTO l_count_rows
3274: FROM rcv_transactions rt
3275: WHERE rt.creation_date > (SELECT MIN(cppp.process_date)
3276: FROM cst_pac_process_phases cppp
3277: WHERE
3278: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3279: AND cppp.process_upto_date IS NOT NULL)
3280: AND cppp.pac_period_id = p_pac_period_id

Line 3307: FROM cst_pac_process_phases cppp

3303: SELECT count(1)
3304: INTO l_count_rows
3305: FROM rcv_accounting_events rae
3306: WHERE rae.creation_date > ( SELECT MIN(cppp.process_date)
3307: FROM cst_pac_process_phases cppp
3308: WHERE
3309: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)
3310: AND cppp.process_upto_date IS NOT NULL)
3311: AND cppp.pac_period_id = p_pac_period_id