DBA Data[Home] [Help]

APPS.CSTPPWAS dependencies on CSTPPWAC

Line 5156: CSTPPWAC.cost_processor

5152: END IF;
5153:
5154: l_stmt_num := 85;
5155:
5156: CSTPPWAC.cost_processor
5157: (i_legal_entity => p_legal_entity,
5158: i_pac_period_id => p_pac_period_id,
5159: i_org_id => p_org_id,
5160: i_cost_group_id => p_cost_group_id,

Line 5274: CSTPPWAC.cost_processor

5270: END IF;
5271:
5272: l_stmt_num := 105;
5273:
5274: CSTPPWAC.cost_processor
5275: (i_legal_entity => p_legal_entity,
5276: i_pac_period_id => p_pac_period_id,
5277: i_org_id => p_org_id,
5278: i_cost_group_id => p_cost_group_id,

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

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

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

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

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

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

Line 5809: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,

5805: IF (p_cost_method <> 4) THEN
5806:
5807: l_stmt_num := 55;
5808: /* Bug 11834257: Use update_item_cppb instead of update_cppb */
5809: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,
5810: i_cost_group_id => p_cost_group_id,
5811: i_txn_category => 4, /* Non-rework Completions */
5812: i_item_id => p_item_id,
5813: i_user_id => p_user_id,

Line 5822: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

5818: o_err_num => l_err_num,
5819: o_err_code => l_err_code,
5820: o_err_msg => l_err_msg);
5821:
5822: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
5823: i_cost_group_id => p_cost_group_id,
5824: i_txn_category => 4, /* Non-rework Completions */
5825: /*i_low_level_code => p_low_level_code,
5826: i_user_id => p_user_id,

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

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

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

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

Line 6216: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,

6212:
6213: IF (p_cost_method <> 4) THEN
6214: l_stmt_num := 35;
6215: /* Bug 11834257: Use update_item_cppb instead of update_cppb */
6216: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,
6217: i_cost_group_id => p_cost_group_id,
6218: i_txn_category => 6, /* Rework Issues */
6219: i_item_id => p_item_id,
6220: i_user_id => p_user_id,

Line 6229: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

6225: o_err_num => l_err_num,
6226: o_err_code => l_err_code,
6227: o_err_msg => l_err_msg);
6228:
6229: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
6230: i_cost_group_id => p_cost_group_id,
6231: i_txn_category => 6, /* Rework Issues */
6232: /*i_low_level_code => p_low_level_code,
6233: i_user_id => p_user_id,

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

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

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

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

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

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

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

6446: have is atleast one cost owned transaction for rework assemblies */
6447:
6448: IF (p_cost_method <> 4 AND l_co_txns_count > 0) THEN
6449: l_stmt_num := 65;
6450: CSTPPWAC.calculate_periodic_cost(i_pac_period_id => p_pac_period_id,
6451: i_cost_group_id => p_cost_group_id,
6452: i_cost_type_id => p_cost_type_id,
6453: i_low_level_code => p_low_level_code,
6454: i_item_id => p_item_id, /* 11834257 */

Line 6476: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,

6472:
6473: /* Update cppb */
6474: l_stmt_num := 70;
6475: /* Bug 11834257: Use update_item_cppb instead of update_cppb */
6476: CSTPPWAC.update_item_cppb(i_pac_period_id => p_pac_period_id,
6477: i_cost_group_id => p_cost_group_id,
6478: i_txn_category => 7, /* Rework Completions */
6479: i_item_id => p_item_id,
6480: i_user_id => p_user_id,

Line 6489: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,

6485: o_err_num => l_err_num,
6486: o_err_code => l_err_code,
6487: o_err_msg => l_err_msg);
6488:
6489: /*CSTPPWAC.update_cppb(i_pac_period_id => p_pac_period_id,
6490: i_cost_group_id => p_cost_group_id,
6491: i_txn_category => 7, /* Rework Completions */
6492: /*i_low_level_code => p_low_level_code,
6493: i_user_id => p_user_id,