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 1302: UPDATE wip_pac_period_balances wppb

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

Line 1412: UPDATE wip_pac_period_balances wppb

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

Line 1558: UPDATE wip_pac_period_balances wppb

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

Line 1576: UPDATE wip_pac_period_balances wppb

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

Line 1593: UPDATE wip_pac_period_balances wppb

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

Line 1684: UPDATE wip_pac_period_balances wppb

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

Line 1837: UPDATE wip_pac_period_balances wppb

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

Line 2010: UPDATE WIP_PAC_PERIOD_BALANCES

2006:
2007: IF (c_scrap_rec.from_op_step <> 5 and c_scrap_rec.to_op_step = 5) then
2008:
2009: l_stmt_num := 20;
2010: UPDATE WIP_PAC_PERIOD_BALANCES
2011: SET unrelieved_scrap_quantity = nvl(unrelieved_scrap_quantity,0) + c_scrap_rec.pri_qty
2012: WHERE wip_entity_id = c_scrap_rec.wip_entity
2013: AND nvl(line_id,-99) = decode(wip_entity_type, 4, -99, nvl(c_scrap_rec.line,-99))
2014: AND operation_seq_num <= c_scrap_rec.to_op_seq

Line 2025: UPDATE WIP_PAC_PERIOD_BALANCES

2021: IF (c_scrap_rec.from_op_step = 5 and c_scrap_rec.to_op_step <> 5) then
2022:
2023: l_stmt_num := 30;
2024:
2025: UPDATE WIP_PAC_PERIOD_BALANCES
2026: SET unrelieved_scrap_quantity = nvl(unrelieved_scrap_quantity,0) - c_scrap_rec.pri_qty
2027: WHERE wip_entity_id = c_scrap_rec.wip_entity
2028: AND nvl(line_id,-99) = decode(wip_entity_type, 4, -99, nvl(c_scrap_rec.line,-99))
2029: AND operation_seq_num <= c_scrap_rec.from_op_seq

Line 2043: UPDATE WIP_PAC_PERIOD_BALANCES

2039:
2040: IF (c_scrap_rec.from_op_seq > c_scrap_rec.to_op_seq) THEN
2041:
2042: l_stmt_num := 50;
2043: UPDATE WIP_PAC_PERIOD_BALANCES
2044: SET unrelieved_scrap_quantity = nvl(unrelieved_scrap_quantity,0) - c_scrap_rec.pri_qty
2045: WHERE wip_entity_id = c_scrap_rec.wip_entity
2046: AND nvl(line_id,-99) = decode(wip_entity_type, 4, -99, nvl(c_scrap_rec.line,-99))
2047: AND operation_seq_num > c_scrap_rec.to_op_seq

Line 2057: UPDATE WIP_PAC_PERIOD_BALANCES

2053: ELSE
2054:
2055: l_stmt_num := 60;
2056:
2057: UPDATE WIP_PAC_PERIOD_BALANCES
2058: SET unrelieved_scrap_quantity = nvl(unrelieved_scrap_quantity,0) + c_scrap_rec.pri_qty
2059: WHERE wip_entity_id = c_scrap_rec.wip_entity
2060: AND nvl(line_id,-99) = decode(wip_entity_type, 4, -99, nvl(c_scrap_rec.line,-99))
2061: AND operation_seq_num > c_scrap_rec.from_op_seq