1277: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE
1278: INDEX BY BINARY_INTEGER;
1279: l_last_txn_id_tbl t_txn_id_tbl;
1280: l_txn_category_tbl t_txn_category_tbl;
1281: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
1282:
1283: l_period_quantity NUMBER;
1284: l_period_balance NUMBER;
1285: l_cg_idx BINARY_INTEGER;
4044: END IF;
4045:
4046: -- insert into cppb for 1000 inventory items
4047: l_error_num := 0;
4048: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4049: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4050: ,i_cost_group_id => p_cost_group_id
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4068:
4069: IF l_error_num = 0 THEN
4070:
4071: -- Invoke PAC inventory cost processor
4072: CSTPPINV.cost_inv_txn( i_pac_period_id => p_period_id
4073: , i_legal_entity => p_legal_entity_id
4074: , i_cost_type_id => p_cost_type_id
4075: , i_cost_group_id => p_cost_group_id
4076: , i_cost_method => p_cost_method
4270: -- ======================================================
4271: l_error_num := 0;
4272:
4273:
4274: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4275: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4276: ,i_cost_group_id => p_cost_group_id
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4517:
4518: -- insert into cppb for 1000 inventory items
4519: l_error_num := 0;
4520:
4521: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4522: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4523: ,i_cost_group_id => p_cost_group_id
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4541:
4542: IF l_error_num = 0 THEN
4543:
4544: -- Invoke PAC inventory cost processor
4545: CSTPPINV.cost_inv_txn( i_pac_period_id => p_period_id
4546: , i_legal_entity => p_legal_entity_id
4547: , i_cost_type_id => p_cost_type_id
4548: , i_cost_group_id => p_cost_group_id
4549: , i_cost_method => p_cost_method
4735: -- Update CPPB
4736: -- ======================================================
4737: l_error_num := 0;
4738:
4739: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4740: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4741: ,i_cost_group_id => p_cost_group_id
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id