APPS.CSTPPWRO dependencies on WIP_PAC_PERIOD_BALANCES

Line 120: UPDATE wip_pac_period_balances wppb

116: END IF;
117:
118: l_stmt_num := 15;
119:
120: UPDATE wip_pac_period_balances wppb
121: SET wppb.operation_completed_units
122: = NVL(wppb.operation_completed_units,0) + l_pri_qty,
123: wppb.last_update_date = SYSDATE,
124: wppb.request_id = p_request_id,

Line 196: INSERT INTO wip_pac_period_balances

192: ----------------------------------------------------------------------
193:
194: l_stmt_num := 5;
195:
196: INSERT INTO wip_pac_period_balances
197: (
198: pac_period_id,
199: cost_group_id,
200: cost_type_id,

Line 285: FROM wip_pac_period_balances wppb2

281: p_login_id
282: FROM DUAL
283: WHERE NOT EXISTS
284: ( SELECT 'X'
285: FROM wip_pac_period_balances wppb2
286: WHERE wppb2.pac_period_id = p_pac_period_id
287: AND wppb2.cost_group_id = p_cost_group_id
288: AND wppb2.wip_entity_id = p_entity_id
289: AND NVL(wppb2.line_id,-99) = decode(p_entity_type,4,-99,NVL(p_line_id,-99))

Line 1301: UPDATE wip_pac_period_balances wppb

1297: IF c_res_rec.wip_txn_type = 1 THEN --RES
1298:
1299: l_stmt_num := 40;
1300:
1301: UPDATE wip_pac_period_balances wppb
1302: SET tl_resource_in = NVL(tl_resource_in,0) +
1303: c_res_rec.applied_value,
1304: request_id = p_request_id,
1305: last_update_date = SYSDATE,

Line 1410: UPDATE wip_pac_period_balances wppb

1406:
1407:
1408: l_stmt_num := 50;
1409:
1410: UPDATE wip_pac_period_balances wppb
1411: SET tl_outside_processing_in =
1412: NVL(tl_outside_processing_in,0) +
1413: l_applied_value,
1414: request_id = p_request_id,

Line 1556: UPDATE wip_pac_period_balances wppb

1552:
1553: IF l_eam_cost_element = 1 THEN
1554:
1555: /* Update PL-material for materials */
1556: UPDATE wip_pac_period_balances wppb
1557: SET pl_material_in =
1558: NVL(pl_material_in,0) +
1559: l_applied_value,
1560: request_id = p_request_id,

Line 1574: UPDATE wip_pac_period_balances wppb

1570:
1571: ELSIF l_eam_cost_element = 3 THEN
1572:
1573: /* Update PL-resource for Resources */
1574: UPDATE wip_pac_period_balances wppb
1575: SET pl_resource_in = NVL(pl_resource_in,0)
1576: + l_applied_value,
1577: request_id = p_request_id,
1578: last_update_date = SYSDATE,

Line 1591: UPDATE wip_pac_period_balances wppb

1587:
1588: ELSE
1589:
1590: /* Update PL-OSP cols for OSP */
1591: UPDATE wip_pac_period_balances wppb
1592: SET pl_outside_processing_in =
1593: NVL (pl_outside_processing_in,0) +
1594: l_applied_value,
1595: request_id = p_request_id,

Line 1682: UPDATE wip_pac_period_balances wppb

1678: IF (c_rbo_rec.applied_value <> 0) THEN
1679:
1680: l_stmt_num := 70;
1681:
1682: UPDATE wip_pac_period_balances wppb
1683: SET tl_overhead_in = NVL(tl_overhead_in,0) +
1684: c_rbo_rec.applied_value,
1685: request_id = p_request_id,
1686: last_update_date = SYSDATE,

Line 1835: UPDATE wip_pac_period_balances wppb

1831:
1832: l_stmt_num := 90;
1833:
1834:
1835: UPDATE wip_pac_period_balances wppb
1836: SET tl_overhead_in = NVL(tl_overhead_in,0) +
1837: c_mbo_rec.applied_value,
1838: request_id = p_request_id,
1839: last_update_date = SYSDATE,