DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on CSTPPWAC

Line 573: CSTPPWAC.cost_processor( i_legal_entity, i_pac_period_id, i_txn_org_id,

569: mctcd.transaction_id = i_txn_id;
570: END IF;
571:
572: l_stmt_num := 160;
573: CSTPPWAC.cost_processor( i_legal_entity, i_pac_period_id, i_txn_org_id,
574: i_cost_group_id, l_txn_cost_group_id,
575: l_txfr_cost_group_id, i_cost_type_id, i_cost_method,
576: i_process_group, i_txn_id, l_quantity_layer_id,
577: l_cost_layer_id, i_pac_rates_id, i_item_id,

Line 3023: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,

3019:
3020: l_stmt_num := 20;
3021:
3022: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3023: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3024: i_cost_group_id => i_cost_group_id,
3025: i_txn_category => 3, /* Cost Owned Transactions */
3026: i_user_id => i_user_id,
3027: i_login_id => i_login_id,

Line 3107: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3103:
3104: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3105: /* more records left out in the PL/SQL tables, Move them to permanent tables
3106: and clear PL/SQL tables */
3107: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3108: ,i_cost_group_id => i_cost_group_id
3109: ,i_txn_category => 3 /* cost owned transactions */
3110: ,i_user_id => i_user_id
3111: ,i_login_id => i_login_id

Line 3134: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,

3130: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3131: /* l_count > 0 implies that there has been atleast one cost owned
3132: transaction processed upto this point in inter_trx cursor */
3133:
3134: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3135: i_cost_group_id => i_cost_group_id,
3136: i_txn_category => 3, /* Cost Owned Transactions */
3137: i_low_level_code => -2,
3138: i_user_id => i_user_id,

Line 3412: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,

3408:
3409: l_stmt_num := 20;
3410:
3411: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3412: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3413: i_cost_group_id => i_cost_group_id,
3414: i_txn_category => 9, /* Cost Derived Transactions */
3415: i_user_id => i_user_id,
3416: i_login_id => i_login_id,

Line 3494: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3490:
3491: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3492: /* more records left out in the PL/SQL tables, Move them to permanent tables
3493: and clear PL/SQL tables */
3494: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3495: ,i_cost_group_id => i_cost_group_id
3496: ,i_txn_category => 9 /* cost derived transactions */
3497: ,i_user_id => i_user_id
3498: ,i_login_id => i_login_id

Line 3521: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,

3517: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3518: /* l_count > 0 implies that there has been atleast one cost derived
3519: transaction processed upto this point in group2_interorg_trx cursor */
3520:
3521: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3522: i_cost_group_id => i_cost_group_id,
3523: i_txn_category => 9, /* Cost Derived Transactions */
3524: i_low_level_code => -1, /* No completions */
3525: i_user_id => i_user_id,

Line 3809: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,

3805: l_stmt_num := 30;
3806:
3807: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3808: l_stmt_num := 40;
3809: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3810: i_cost_group_id => i_cost_group_id,
3811: i_txn_category => 9, /* Cost Derived Transactions */
3812: i_user_id => i_user_id,
3813: i_login_id => i_login_id,

Line 3876: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,

3872: ELSE
3873: /* other than wip source */
3874: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3875: l_stmt_num := 60;
3876: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3877: i_cost_group_id => i_cost_group_id,
3878: i_txn_category => 9, /* Cost Derived Transactions */
3879: i_user_id => i_user_id,
3880: i_login_id => i_login_id,

Line 3960: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3956: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3957: /* more records left out in the PL/SQL tables, Move them to permanent tables
3958: and clear PL/SQL tables */
3959: l_stmt_num := 70;
3960: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3961: ,i_cost_group_id => i_cost_group_id
3962: ,i_txn_category => 9 /* cost derived transactions */
3963: ,i_user_id => i_user_id
3964: ,i_login_id => i_login_id

Line 3987: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,

3983: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3984: /* l_count > 0 implies that there has been atleast one cost derived
3985: transaction processed upto this point in group2_trx cursor */
3986: l_stmt_num := 80;
3987: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3988: i_cost_group_id => i_cost_group_id,
3989: i_txn_category => 9, /* Cost Derived Transactions */
3990: i_low_level_code => -1, /* No completions */
3991: i_user_id => i_user_id,