APPS.CSTPPWMX dependencies on WIP_PERIOD_BALANCES

Line 38: FROM wip_period_balances wpb

34: l_api_message VARCHAR2(8000);
35: /* Added for bug6709905 */
36: CURSOR wpb_rep_sch IS
37: SELECT wpb.pl_material_in
38: FROM wip_period_balances wpb
39: WHERE wpb.acct_period_id = i_period_id
40: AND wpb.organization_id = i_org_id
41: AND wpb.wip_entity_id = i_entity_id
42: AND wpb.repetitive_schedule_id in

Line 61: /* Update WIP_PERIOD_BALANCES */

57: /* Obtain round unit */
58:
59: CSTPUTIL.CSTPUGCI (i_org_id, l_round_unit, l_precision, l_ext_precision);
60:
61: /* Update WIP_PERIOD_BALANCES */
62:
63: IF i_entity_type <> 2 THEN
64: /* EAM Acct Enh Project */
65: CST_Utility_PUB.get_zeroCostIssue_flag (

Line 91: /* update wip_period_balances WHO columns */

87: end if;
88:
89: if (l_zero_cost_flag = 1) then
90:
91: /* update wip_period_balances WHO columns */
92: UPDATE wip_period_balances b
93: SET LAST_UPDATE_DATE = sysdate,
94: LAST_UPDATED_BY = i_user_id,
95: LAST_UPDATE_LOGIN = i_login_id,

Line 92: UPDATE wip_period_balances b

88:
89: if (l_zero_cost_flag = 1) then
90:
91: /* update wip_period_balances WHO columns */
92: UPDATE wip_period_balances b
93: SET LAST_UPDATE_DATE = sysdate,
94: LAST_UPDATED_BY = i_user_id,
95: LAST_UPDATE_LOGIN = i_login_id,
96: REQUEST_ID = DECODE(i_req_id, -1, NULL, i_req_id),

Line 105: UPDATE wip_period_balances b

101: AND organization_id = i_org_id
102: AND wip_entity_id = i_entity_id;
103: else
104:
105: UPDATE wip_period_balances b
106: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
107: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
108: pl_material_in,
109: pl_material_overhead_in,

Line 157: UPDATE wip_period_balances b

153: /* i_entity_type = 2 */
154: /* bug 6709905, introduced loop to cursor to prevent deadlock
155: scenario*/
156: FOR wpb_rec IN wpb_rep_sch LOOP
157: UPDATE wip_period_balances b
158: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
159: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
160: pl_material_in,
161: pl_material_overhead_in,

Line 288: FROM wip_period_balances wpb

284:
285: /* Added for bug6709905*/
286: CURSOR wpb_rep_sch IS
287: SELECT wpb.pl_material_out
288: FROM wip_period_balances wpb
289: WHERE wpb.acct_period_id = i_period_id
290: AND wpb.organization_id = i_org_id
291: AND wpb.wip_entity_id = i_entity_id
292: AND wpb.repetitive_schedule_id in

Line 310: /* Update TL, PL (OUT) costs to WIP_PERIOD_BALANCES for the assembly */

306: /* Obtain round unit */
307:
308: CSTPUTIL.CSTPUGCI (i_org_id, l_round_unit, l_precision, l_ext_precision);
309:
310: /* Update TL, PL (OUT) costs to WIP_PERIOD_BALANCES for the assembly */
311: /* Separte SQL statement for job and schedule for faster performance */
312: /* Complete into INV take positive quantity */
313:
314: IF i_entity_type <> 2 THEN /* discrete job */

Line 406: UPDATE wip_period_balances b

402:
403: END IF;
404:
405:
406: UPDATE wip_period_balances b
407: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
408: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
409: pl_material_out,
410: pl_material_overhead_out,

Line 487: UPDATE wip_period_balances b

483:
484: ELSE /* repetitive schedules */
485:
486: FOR wpb_rec IN wpb_rep_sch LOOP
487: UPDATE wip_period_balances b
488: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
489: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
490: pl_material_out,
491: pl_material_overhead_out,