APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_CMN_TRANSACTIONS_T

Line 99: ln_last_updated_by JAI_CMN_TRANSACTIONS_T.LAST_UPDATED_BY%TYPE;

95: v_hit_rg23_qty NUMBER; --Added by Nagaraj.s for Bug2649405
96: v_hit_rg1_qty NUMBER; --Added by Nagaraj.s for Bug2649405
97: v_other_npe_qty Number; -- Sriram -- Bug # 3258066
98:
99: ln_last_updated_by JAI_CMN_TRANSACTIONS_T.LAST_UPDATED_BY%TYPE;
100: ln_created_by JAI_CMN_TRANSACTIONS_T.CREATED_BY%TYPE;
101: ln_last_update_login JAI_CMN_TRANSACTIONS_T.LAST_UPDATE_LOGIN%TYPE;
102:
103: CURSOR loc_id_cur (p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)

Line 100: ln_created_by JAI_CMN_TRANSACTIONS_T.CREATED_BY%TYPE;

96: v_hit_rg1_qty NUMBER; --Added by Nagaraj.s for Bug2649405
97: v_other_npe_qty Number; -- Sriram -- Bug # 3258066
98:
99: ln_last_updated_by JAI_CMN_TRANSACTIONS_T.LAST_UPDATED_BY%TYPE;
100: ln_created_by JAI_CMN_TRANSACTIONS_T.CREATED_BY%TYPE;
101: ln_last_update_login JAI_CMN_TRANSACTIONS_T.LAST_UPDATE_LOGIN%TYPE;
102:
103: CURSOR loc_id_cur (p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
104: IS

Line 101: ln_last_update_login JAI_CMN_TRANSACTIONS_T.LAST_UPDATE_LOGIN%TYPE;

97: v_other_npe_qty Number; -- Sriram -- Bug # 3258066
98:
99: ln_last_updated_by JAI_CMN_TRANSACTIONS_T.LAST_UPDATED_BY%TYPE;
100: ln_created_by JAI_CMN_TRANSACTIONS_T.CREATED_BY%TYPE;
101: ln_last_update_login JAI_CMN_TRANSACTIONS_T.LAST_UPDATE_LOGIN%TYPE;
102:
103: CURSOR loc_id_cur (p_subinv_code IN VARCHAR2, p_organization_id IN NUMBER)
104: IS
105: SELECT location_id

Line 192: FROM JAI_CMN_TRANSACTIONS_T

188:
189: CURSOR count_temp_cur
190: IS
191: SELECT COUNT (*)
192: FROM JAI_CMN_TRANSACTIONS_T
193: WHERE transaction_set_id = pr_new.transaction_set_id;
194:
195: CURSOR retrieve_temp_cur
196: IS

Line 201: FROM JAI_CMN_TRANSACTIONS_T

197: SELECT subinventory_code, organization_id, inventory_item_id,
198: transaction_quantity, transaction_type_id, transaction_date,
199: transaction_uom, transaction_set_id,
200: transaction_id -- cbabu for Bug# 2480584
201: FROM JAI_CMN_TRANSACTIONS_T
202: WHERE transaction_set_id = pr_new.transaction_set_id;
203:
204:
205: /*

Line 381: Added the who columns in the insert into statment for the table JAI_CMN_TRANSACTIONS_T.

377:
378: 13. 13-Jun-2005 Ramananda for bug#4428980. File Version: 116.2
379: Removal of SQL LITERALs is done
380: 14. 28-Nov-2005 Aiyer for bug# 4764510. File Version: 120.1
381: Added the who columns in the insert into statment for the table JAI_CMN_TRANSACTIONS_T.
382: Dependencies due to this change:-
383: None
384:
385: 15. 13-Feb-2007 bgowrava for forward porting bug#5275865 (11i bug#5217272) Version# 120.3

Line 599: INSERT INTO JAI_CMN_TRANSACTIONS_T

595: IF v_count_temp = 0 THEN
596: /*
597: || Added the who columns in the insert statement
598: */
599: INSERT INTO JAI_CMN_TRANSACTIONS_T
600: ( transaction_set_id ,
601: inventory_item_id ,
602: organization_id ,
603: subinventory_code ,

Line 1281: DELETE FROM JAI_CMN_TRANSACTIONS_T WHERE transaction_set_id = pr_new.transaction_set_id;

1277:
1278: END IF; --ccc
1279:
1280: IF v_ins_from_temp_flag = 0 AND v_ins_from_curr_flag = 0 AND v_insert_flag = 0 THEN
1281: DELETE FROM JAI_CMN_TRANSACTIONS_T WHERE transaction_set_id = pr_new.transaction_set_id;
1282: EXIT; /* Uncommented by ssumaith - bug# 4130515*/
1283: END IF;
1284: END LOOP;
1285: END IF;