APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 242: From JAI_CMN_RG_23AC_I_TRXS a

238: v_ec_code Varchar2(50);
239:
240: Cursor rg23_part_i_cur(p_register_id IN Number) IS
241: Select *
242: From JAI_CMN_RG_23AC_I_TRXS a
243: Where a.register_id = p_register_id;
244: rg23_rec rg23_part_i_cur%ROWTYPE;
245:
246: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS

Line 248: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

244: rg23_rec rg23_part_i_cur%ROWTYPE;
245:
246: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS
247: Select register_id
248: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
249: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
250: And ( a.master_flag IS NULL OR a.master_flag = 'N') --rchandan for bug#4428980
251: And a.organization_id = b.organization_id
252: And a.location_id = b.location_id

Line 261: From JAI_CMN_RG_23AC_I_TRXS

257:
258: Cursor serial_no_cur(p_organization_id IN Number, p_location_id IN Number, p_inventory_item_id IN Number,
259: p_fin_year IN Number, p_register_type Char) IS
260: Select nvl(MAX(slno),0) , nvl(MAX(slno),0) + 1
261: From JAI_CMN_RG_23AC_I_TRXS
262: Where organization_id = p_organization_id
263: And location_id = nvl(p_location_id,0)
264: And inventory_item_id = p_inventory_item_id
265: And fin_year = p_fin_year

Line 275: From JAI_CMN_RG_23AC_I_TRXS

271:
272: Cursor opening_balance_qty_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
273: p_inventory_item_id IN Number,p_fin_year IN Number, p_register_type Char) IS
274: Select nvl(opening_balance_qty,0), nvl(closing_balance_qty,0)
275: From JAI_CMN_RG_23AC_I_TRXS
276: Where slno = p_previous_serial_no
277: And organization_id = p_organization_id
278: And location_id = nvl(p_location_id,0)
279: And register_type = p_register_type

Line 288: lv_remarks jai_cmn_rg_23ac_i_trxs.remarks%TYPE ;

284: v_opening_balance_qty Number := 0;
285: v_transaction_quantity Number := 0;
286: v_closing_balance_qty Number := 0;
287: v_debug_flag VARCHAR2 (1); -- char(1) :='Y'; --Added by Nagaraj.s for Bug2708516 (For File.Sql.35 by Brathod)
288: lv_remarks jai_cmn_rg_23ac_i_trxs.remarks%TYPE ;
289:
290:
291: Begin
292: /*------------------------------------------------------------------------------------------

Line 368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

364: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);
365: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);
366: end if;
367: lv_remarks := rg23_rec.remarks || ' Master Org';--rchandan for bug#4428980
368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
369: (register_id,
370: fin_year,
371: slno,
372: TRANSACTION_SOURCE_NUM,

Line 486: UPDATE JAI_CMN_RG_23AC_I_TRXS

482: rg23_rec.last_update_login,
483: rg23_rec.last_update_date,
484: rg23_rec.last_updated_by);
485:
486: UPDATE JAI_CMN_RG_23AC_I_TRXS
487: SET posted_flag = 'Y',
488: master_flag = 'N'
489: WHERE register_id = rg23_rec.register_id;
490: