DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on CSTPPWAC

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

529: WHERE
530: mctcd.transaction_id = i_txn_id;
531: END IF;
532:
533: CSTPPWAC.cost_processor( i_legal_entity, i_pac_period_id, i_txn_org_id,
534: i_cost_group_id, l_txn_cost_group_id,
535: l_txfr_cost_group_id, i_cost_type_id, i_cost_method,
536: i_process_group, i_txn_id, l_quantity_layer_id,
537: l_cost_layer_id, i_pac_rates_id, i_item_id,

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

2969:
2970: l_stmt_num := 20;
2971:
2972: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
2973: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
2974: i_cost_group_id => i_cost_group_id,
2975: i_txn_category => 3, /* Cost Owned Transactions */
2976: i_user_id => i_user_id,
2977: i_login_id => i_login_id,

Line 3055: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3051:
3052: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3053: /* more records left out in the PL/SQL tables, Move them to permanent tables
3054: and clear PL/SQL tables */
3055: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3056: ,i_cost_group_id => i_cost_group_id
3057: ,i_txn_category => 3 /* cost owned transactions */
3058: ,i_user_id => i_user_id
3059: ,i_login_id => i_login_id

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

3078: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3079: /* l_count > 0 implies that there has been atleast one cost owned
3080: transaction processed upto this point in inter_trx cursor */
3081:
3082: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3083: i_cost_group_id => i_cost_group_id,
3084: i_txn_category => 3, /* Cost Owned Transactions */
3085: i_low_level_code => -2,
3086: i_user_id => i_user_id,

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

3356:
3357: l_stmt_num := 20;
3358:
3359: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3360: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3361: i_cost_group_id => i_cost_group_id,
3362: i_txn_category => 9, /* Cost Derived Transactions */
3363: i_user_id => i_user_id,
3364: i_login_id => i_login_id,

Line 3442: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3438:
3439: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3440: /* more records left out in the PL/SQL tables, Move them to permanent tables
3441: and clear PL/SQL tables */
3442: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3443: ,i_cost_group_id => i_cost_group_id
3444: ,i_txn_category => 9 /* cost derived transactions */
3445: ,i_user_id => i_user_id
3446: ,i_login_id => i_login_id

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

3465: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3466: /* l_count > 0 implies that there has been atleast one cost derived
3467: transaction processed upto this point in group2_interorg_trx cursor */
3468:
3469: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3470: i_cost_group_id => i_cost_group_id,
3471: i_txn_category => 9, /* Cost Derived Transactions */
3472: i_low_level_code => -1, /* No completions */
3473: i_user_id => i_user_id,

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

3757: l_stmt_num := 30;
3758:
3759: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3760: l_stmt_num := 40;
3761: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3762: i_cost_group_id => i_cost_group_id,
3763: i_txn_category => 9, /* Cost Derived Transactions */
3764: i_user_id => i_user_id,
3765: i_login_id => i_login_id,

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

3824: ELSE
3825: /* other than wip source */
3826: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000 AND i_cost_method <> 4) THEN
3827: l_stmt_num := 60;
3828: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id,
3829: i_cost_group_id => i_cost_group_id,
3830: i_txn_category => 9, /* Cost Derived Transactions */
3831: i_user_id => i_user_id,
3832: i_login_id => i_login_id,

Line 3912: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id

3908: IF (CSTPPINV.l_item_id_tbl.COUNT > 0 AND i_cost_method <> 4) THEN
3909: /* more records left out in the PL/SQL tables, Move them to permanent tables
3910: and clear PL/SQL tables */
3911: l_stmt_num := 70;
3912: CSTPPWAC.insert_into_cppb(i_pac_period_id => i_pac_period_id
3913: ,i_cost_group_id => i_cost_group_id
3914: ,i_txn_category => 9 /* cost derived transactions */
3915: ,i_user_id => i_user_id
3916: ,i_login_id => i_login_id

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

3935: IF (l_error_num = 0 AND i_cost_method <> 4 and l_count > 0) THEN
3936: /* l_count > 0 implies that there has been atleast one cost derived
3937: transaction processed upto this point in group2_trx cursor */
3938: l_stmt_num := 80;
3939: CSTPPWAC.update_cppb(i_pac_period_id => i_pac_period_id,
3940: i_cost_group_id => i_cost_group_id,
3941: i_txn_category => 9, /* Cost Derived Transactions */
3942: i_low_level_code => -1, /* No completions */
3943: i_user_id => i_user_id,