DBA Data[Home] [Help]

APPS.CSTPPWAS dependencies on CSTPPWAC

Line 4088: CSTPPWAC.cost_processor

4084: END IF;
4085:
4086: l_stmt_num := 85;
4087:
4088: CSTPPWAC.cost_processor
4089: (i_legal_entity => p_legal_entity,
4090: i_pac_period_id => p_pac_period_id,
4091: i_org_id => p_org_id,
4092: i_cost_group_id => p_cost_group_id,

Line 4198: CSTPPWAC.cost_processor

4194: END IF;
4195:
4196: l_stmt_num := 105;
4197:
4198: CSTPPWAC.cost_processor
4199: (i_legal_entity => p_legal_entity,
4200: i_pac_period_id => p_pac_period_id,
4201: i_org_id => p_org_id,
4202: i_cost_group_id => p_cost_group_id,

Line 4634: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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,
4638: i_login_id => p_login_id,

Line 4721: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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 */
4724: i_user_id => p_user_id,
4725: i_login_id => p_login_id,

Line 4789: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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,
4793: i_login_id => p_login_id,

Line 4812: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

4808: END IF;
4809:
4810: IF (p_cost_method <> 4) THEN
4811: l_stmt_num := 100;
4812: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
4813: i_cost_group_id => p_cost_group_id,
4814: i_txn_category => 4, /* Non-rework Completions */
4815: i_low_level_code => p_low_level_code,
4816: i_user_id => p_user_id,

Line 5123: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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 */
5126: i_user_id => p_user_id,
5127: i_login_id => p_login_id,

Line 5181: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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 */
5184: i_user_id => p_user_id,
5185: i_login_id => p_login_id,

Line 5204: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

5200: END IF;
5201:
5202: IF (p_cost_method <> 4) THEN
5203: l_stmt_num := 35;
5204: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
5205: i_cost_group_id => p_cost_group_id,
5206: i_txn_category => 6, /* Rework Issues */
5207: i_low_level_code => p_low_level_code,
5208: i_user_id => p_user_id,

Line 5238: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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 */
5241: i_user_id => p_user_id,
5242: i_login_id => p_login_id,

Line 5325: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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,
5329: i_login_id => p_login_id,

Line 5398: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_pac_period_id,

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 */
5401: i_user_id => p_user_id,
5402: i_login_id => p_login_id,

Line 5423: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_pac_period_id,

5419: have is atleast one cost owned transaction for rework assemblies */
5420:
5421: IF (p_cost_method <> 4 AND l_co_txns_count > 0) THEN
5422: l_stmt_num := 65;
5423: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_pac_period_id,
5424: i_cost_group_id => p_cost_group_id,
5425: i_cost_type_id => p_cost_type_id,
5426: i_low_level_code => p_low_level_code,
5427: i_item_id => NULL, /* Used only by PACP */

Line 5447: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

5443: END IF;
5444:
5445: /* Update cppb */
5446: l_stmt_num := 70;
5447: CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
5448: i_cost_group_id => p_cost_group_id,
5449: i_txn_category => 7, /* Rework Completions */
5450: i_low_level_code => p_low_level_code,
5451: i_user_id => p_user_id,