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 356: Added the who columns in the insert into statment for the table JAI_CMN_TRANSACTIONS_T.

352:
353: 13. 13-Jun-2005 Ramananda for bug#4428980. File Version: 116.2
354: Removal of SQL LITERALs is done
355: 14. 28-Nov-2005 Aiyer for bug# 4764510. File Version: 120.1
356: Added the who columns in the insert into statment for the table JAI_CMN_TRANSACTIONS_T.
357: Dependencies due to this change:-
358: None
359:
360: 15. 13-Feb-2007 bgowrava for forward porting bug#5275865 (11i bug#5217272) Version# 120.3

Line 537: INSERT INTO JAI_CMN_TRANSACTIONS_T

533: IF v_count_temp = 0 THEN
534: /*
535: || Added the who columns in the insert statement
536: */
537: INSERT INTO JAI_CMN_TRANSACTIONS_T
538: ( transaction_set_id ,
539: inventory_item_id ,
540: organization_id ,
541: subinventory_code ,

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

1160:
1161: END IF; --ccc
1162:
1163: IF v_ins_from_temp_flag = 0 AND v_ins_from_curr_flag = 0 AND v_insert_flag = 0 THEN
1164: DELETE FROM JAI_CMN_TRANSACTIONS_T WHERE transaction_set_id = pr_new.transaction_set_id;
1165: EXIT; /* Uncommented by ssumaith - bug# 4130515*/
1166: END IF;
1167: END LOOP;
1168: END IF;