APPS.CSTPPWAS dependencies on CSTPPINV

Line 3971: CSTPPINV.get_um_rate ( i_txn_org_id => l_org_id,

3967: WHERE we.wip_entity_id = p_entity_id;
3968:
3969: IF (l_item_id <> -1) THEN
3970: l_stmt_num := 65;
3971: CSTPPINV.get_um_rate ( i_txn_org_id => l_org_id,
3972: i_master_org_id => p_master_org_id,
3973: i_txn_cost_group_id => -1,
3974: i_txfr_cost_group_id => -2,
3975: i_txn_action_id => -3,

Line 4633: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN

4629: --------------------------------------------------------------------------
4630:
4631: FOR c_ent_rec IN c_non_rework_entity_scrap LOOP
4632: l_stmt_num := 60;
4633: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
4634: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
4635: i_cost_group_id => p_cost_group_id,
4636: i_txn_category => 4, /* Non-rework completions */
4637: i_user_id => p_user_id,

Line 4719: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN

4715: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
4716: AND (TRUNC(p_end_date) + 0.99999)
4717: AND ROWNUM < 2;
4718:
4719: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
4720: l_stmt_num := 80;
4721: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
4722: i_cost_group_id => p_cost_group_id,
4723: i_txn_category => 4, /* Non-rework completions */

Line 4788: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN

4784: END LOOP; --c_non_rework_entity_complete
4785:
4786: -- Flush the remaining records from PL/SQL tables.
4787: l_stmt_num := 90;
4788: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
4789: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
4790: i_cost_group_id => p_cost_group_id,
4791: i_txn_category => 4, /* Non-rework completions */
4792: i_user_id => p_user_id,

Line 5121: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN

5117:
5118: l_stmt_num := 15;
5119: FOR c_rework_rec IN c_rework_issue_txns LOOP
5120:
5121: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
5122: l_stmt_num := 20;
5123: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5124: i_cost_group_id => p_cost_group_id,
5125: i_txn_category => 6, /* Rework Issues */

Line 5179: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN

5175: END IF;
5176: END LOOP; --c_rework_issue_txns
5177:
5178: l_stmt_num := 30;
5179: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
5180:
5181: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5182: i_cost_group_id => p_cost_group_id,
5183: i_txn_category => 6, /* Rework Issues */

Line 5236: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN

5232: FOR c_ent_rec IN c_rework_entity_scrap LOOP
5233:
5234: l_co_txns_count := l_co_txns_count + 1;
5235:
5236: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
5237:
5238: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5239: i_cost_group_id => p_cost_group_id,
5240: i_txn_category => 7, /* Rework Completions */

Line 5324: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN

5320: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
5321: AND (TRUNC(p_end_date) + 0.99999)
5322: AND ROWNUM < 2;
5323:
5324: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
5325: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5326: i_cost_group_id => p_cost_group_id,
5327: i_txn_category => 7, /* Rework completions */
5328: i_user_id => p_user_id,

Line 5396: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN

5392: END LOOP; --c_rework_entity_complete
5393:
5394: /* Insert into cppb */
5395: l_stmt_num := 60;
5396: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
5397:
5398: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5399: i_cost_group_id => p_cost_group_id,
5400: i_txn_category => 7, /* Rework completions */