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.CSTPPWAS dependencies on CST_PAC_REQ_OPER_COST_DETAILS

Line 991: | Check any record exists in table CST_PAC_REQ_OPER_COST_DETAILS (cprocd) |

987: | The first cursor gets the operation sequence number for a given job. |
988: | |
989: | Second cursor gets all the components at that operations. |
990: | |
991: | Check any record exists in table CST_PAC_REQ_OPER_COST_DETAILS (cprocd) |
992: | |
993: | IF (no record exists in cprocd) THEN |
994: | FOR each cost elements LOOP |
995: | |

Line 1064: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1060: AND wro.wip_supply_type NOT IN (4,5,6);
1061:
1062: CURSOR c_cost_element(op_sequence_num NUMBER,component NUMBER) IS
1063: SELECT cost_element_id cst_ele_id
1064: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1065: WHERE cprocd.pac_period_id = p_pac_period_id
1066: AND cprocd.cost_group_id = p_cost_group_id
1067: AND cprocd.wip_entity_id = p_entity_id
1068: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)

Line 1188: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1184: -------------------------------------------------------
1185: l_stmt_num := 20;
1186: SELECT COUNT(*)
1187: INTO l_record_exists
1188: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1189: WHERE cprocd.pac_period_id = p_pac_period_id
1190: AND cprocd.cost_group_id = p_cost_group_id
1191: AND cprocd.wip_entity_id = p_entity_id
1192: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)

Line 1262: -- Insert a record into CST_PAC_REQ_OPER_COST_DETAILS

1258: 'l_job_balance :' || l_job_balance(i));
1259: END IF;
1260:
1261: ------------------------------------------------------
1262: -- Insert a record into CST_PAC_REQ_OPER_COST_DETAILS
1263: ------------------------------------------------------
1264: l_stmt_num := 60;
1265: INSERT INTO CST_PAC_REQ_OPER_COST_DETAILS
1266: (pac_period_id,

Line 1265: INSERT INTO CST_PAC_REQ_OPER_COST_DETAILS

1261: ------------------------------------------------------
1262: -- Insert a record into CST_PAC_REQ_OPER_COST_DETAILS
1263: ------------------------------------------------------
1264: l_stmt_num := 60;
1265: INSERT INTO CST_PAC_REQ_OPER_COST_DETAILS
1266: (pac_period_id,
1267: cost_group_id,
1268: wip_entity_id,
1269: line_id,

Line 1361: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1357: 0,1,
1358: nvl(relieved_quantity, 0))
1359: INTO l_avl_relieve_value,
1360: l_avl_relieve_qty
1361: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1362: WHERE cprocd.pac_period_id = p_prior_period_id
1363: AND cprocd.cost_group_id = p_cost_group_id
1364: AND cprocd.wip_entity_id = p_entity_id
1365: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)

Line 1439: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1435: 0,1,
1436: Relieved_quantity)
1437: INTO l_prior_relieved_value,
1438: l_prior_relieved_qty
1439: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1440: WHERE cprocd.wip_entity_id = p_entity_id
1441: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)
1442: AND cprocd.operation_seq_num = op_seq_rec.operation_seq_num
1443: AND cprocd.inventory_item_id = comp_rec.component

Line 1486: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1482: 0,1,
1483: nvl(relieved_quantity, 0))
1484: INTO l_avl_relieve_value,
1485: l_avl_relieve_qty
1486: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1487: WHERE cprocd.pac_period_id = p_prior_period_id
1488: AND cprocd.cost_group_id = p_cost_group_id
1489: AND cprocd.wip_entity_id = p_entity_id
1490: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)

Line 1553: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd

1549: INTO l_avl_relieve_value,
1550: l_applied_qty,
1551: l_avl_relieve_qty,
1552: l_relieved_qty
1553: FROM CST_PAC_REQ_OPER_COST_DETAILS cprocd
1554: WHERE cprocd.pac_period_id = p_pac_period_id
1555: AND cprocd.cost_group_id = p_cost_group_id
1556: AND cprocd.wip_entity_id = p_entity_id
1557: AND nvl(cprocd.line_id, -99) = nvl(p_line_id,-99)

Line 1792: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

1788: ------------------------------------------------------
1789: -- Update cprocd table with Calculated Relieved value
1790: ------------------------------------------------------
1791: l_stmt_num := 260;
1792: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
1793: SET cprocd.Relieved_value = nvl(cprocd.Relieved_Value,0) +
1794: decode(p_net_qty,
1795: 0,decode(p_final_completion_flag,
1796: 0, 0,

Line 1926: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

1922:
1923: IF (l_job_balance(1) < 0) THEN
1924:
1925: l_stmt_num := 280;
1926: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
1927: SET cprocd.Comp_variance = nvl(cprocd.Comp_variance,0) + nvl(cprocd.Temp_Relieved_value,0),
1928: cprocd.Relieved_value = nvl(cprocd.Relieved_value,0) - nvl(cprocd.Temp_Relieved_value,0),
1929: cprocd.last_update_date = SYSDATE,
1930: cprocd.last_updated_by = p_user_id,

Line 1978: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

1974:
1975: IF (l_job_balance(2) < 0) THEN
1976:
1977: l_stmt_num := 300;
1978: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
1979: SET cprocd.Comp_variance = nvl(cprocd.Comp_variance,0) + cprocd.Temp_Relieved_value,
1980: cprocd.Relieved_value = cprocd.Relieved_value - cprocd.Temp_Relieved_value,
1981: cprocd.last_update_date = SYSDATE,
1982: cprocd.last_updated_by = p_user_id,

Line 2028: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

2024:
2025: IF (l_job_balance(3) < 0) THEN
2026:
2027: l_stmt_num := 320;
2028: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
2029: SET cprocd.Comp_variance = nvl(cprocd.Comp_variance,0) + cprocd.Temp_Relieved_value,
2030: cprocd.Relieved_value = cprocd.Relieved_value - cprocd.Temp_Relieved_value,
2031: cprocd.last_update_date = SYSDATE,
2032: cprocd.last_updated_by = p_user_id,

Line 2078: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

2074:
2075: IF (l_job_balance(4) < 0) THEN
2076:
2077: l_stmt_num := 340;
2078: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
2079: SET cprocd.Comp_variance = nvl(cprocd.Comp_variance,0) + cprocd.Temp_Relieved_value,
2080: cprocd.Relieved_value = cprocd.Relieved_value - cprocd.Temp_Relieved_value,
2081: cprocd.last_update_date = SYSDATE,
2082: cprocd.last_updated_by = p_user_id,

Line 2128: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd

2124:
2125: IF (l_job_balance(5) < 0) THEN
2126:
2127: l_stmt_num := 360;
2128: UPDATE CST_PAC_REQ_OPER_COST_DETAILS cprocd
2129: SET cprocd.Comp_variance = nvl(cprocd.Comp_variance,0) + cprocd.Temp_Relieved_value,
2130: cprocd.Relieved_value = cprocd.Relieved_value - cprocd.Temp_Relieved_value,
2131: cprocd.last_update_date = SYSDATE,
2132: cprocd.last_updated_by = p_user_id,