APPS.CSTPPWAS dependencies on CSTPPINV

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

5035: WHERE we.wip_entity_id = p_entity_id;
5036:
5037: IF (l_item_id <> -1) THEN
5038: l_stmt_num := 65;
5039: CSTPPINV.get_um_rate ( i_txn_org_id => l_org_id,
5040: i_master_org_id => p_master_org_id,
5041: i_txn_cost_group_id => -1,
5042: i_txfr_cost_group_id => -2,
5043: i_txn_action_id => -3,

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

5622: --------------------------------------------------------------------------
5623:
5624: FOR c_ent_rec IN c_non_rework_entity_scrap LOOP
5625: l_stmt_num := 20;
5626: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
5627: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5628: i_cost_group_id => p_cost_group_id,
5629: i_txn_category => 4, /* Non-rework completions */
5630: i_user_id => p_user_id,

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

5710: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
5711: AND (TRUNC(p_end_date) + 0.99999)
5712: AND ROWNUM < 2;
5713:
5714: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
5715: l_stmt_num := 40;
5716: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5717: i_cost_group_id => p_cost_group_id,
5718: i_txn_category => 4, /* Non-rework completions */

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

5779: END LOOP; --c_non_rework_entity_complete
5780:
5781: -- Flush the remaining records from PL/SQL tables.
5782: l_stmt_num := 50;
5783: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
5784: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
5785: i_cost_group_id => p_cost_group_id,
5786: i_txn_category => 4, /* Non-rework completions */
5787: i_user_id => p_user_id,

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

6128:
6129: l_stmt_num := 15;
6130: FOR c_rework_rec IN c_rework_issue_txns LOOP
6131:
6132: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
6133: l_stmt_num := 20;
6134: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
6135: i_cost_group_id => p_cost_group_id,
6136: i_txn_category => 6, /* Rework Issues */

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

6186: END IF;
6187: END LOOP; --c_rework_issue_txns
6188:
6189: l_stmt_num := 30;
6190: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
6191:
6192: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
6193: i_cost_group_id => p_cost_group_id,
6194: i_txn_category => 6, /* Rework Issues */

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

6257: FOR c_ent_rec IN c_rework_entity_scrap LOOP
6258:
6259: l_co_txns_count := l_co_txns_count + 1;
6260:
6261: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
6262:
6263: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
6264: i_cost_group_id => p_cost_group_id,
6265: i_txn_category => 7, /* Rework Completions */

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

6347: AND mmt.transaction_date BETWEEN TRUNC(p_start_date)
6348: AND (TRUNC(p_end_date) + 0.99999)
6349: AND ROWNUM < 2;
6350:
6351: IF (CSTPPINV.l_item_id_tbl.COUNT >= G_MAX_RECORDS AND p_cost_method <> 4) THEN
6352: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
6353: i_cost_group_id => p_cost_group_id,
6354: i_txn_category => 7, /* Rework completions */
6355: i_user_id => p_user_id,

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

6419: END LOOP; --c_rework_entity_complete
6420:
6421: /* Insert into cppb */
6422: l_stmt_num := 60;
6423: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND p_cost_method <> 4) THEN
6424:
6425: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,
6426: i_cost_group_id => p_cost_group_id,
6427: i_txn_category => 7, /* Rework completions */