APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 36: Inserted Addl CVD into JAI_CMN_RG_23AC_II_TRXS and JAI_CMN_RG_23AC_I_TRXS

32: 2. insert_rg23_others
33:
34: Feb 18, 2010 Bug 9382720
35: Added Additional CVD as it is not getting consolidated in the Master Org
36: Inserted Addl CVD into JAI_CMN_RG_23AC_II_TRXS and JAI_CMN_RG_23AC_I_TRXS
37:
38: Apr 06, 2010 Bug 9550254
39: The opening balance for the RG23 Part I has been derived
40: from the previous financial year closing balance,

Line 250: From JAI_CMN_RG_23AC_I_TRXS a

246: v_ec_code Varchar2(50);
247:
248: Cursor rg23_part_i_cur(p_register_id IN Number) IS
249: Select *
250: From JAI_CMN_RG_23AC_I_TRXS a
251: Where a.register_id = p_register_id;
252: rg23_rec rg23_part_i_cur%ROWTYPE;
253:
254: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS

Line 256: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

252: rg23_rec rg23_part_i_cur%ROWTYPE;
253:
254: Cursor rg23_part_i_register_id_cur(p_ec_code IN Varchar2) IS
255: Select register_id
256: From JAI_CMN_RG_23AC_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
257: Where ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
258: And ( a.master_flag IS NULL OR a.master_flag = 'N') --rchandan for bug#4428980
259: And a.organization_id = b.organization_id
260: And a.location_id = b.location_id

Line 269: From JAI_CMN_RG_23AC_I_TRXS

265:
266: Cursor serial_no_cur(p_organization_id IN Number, p_location_id IN Number, p_inventory_item_id IN Number,
267: p_fin_year IN Number, p_register_type Char) IS
268: Select nvl(MAX(slno),0) , nvl(MAX(slno),0) + 1
269: From JAI_CMN_RG_23AC_I_TRXS
270: Where organization_id = p_organization_id
271: And location_id = nvl(p_location_id,0)
272: And inventory_item_id = p_inventory_item_id
273: And fin_year = p_fin_year

Line 283: From JAI_CMN_RG_23AC_I_TRXS

279:
280: Cursor opening_balance_qty_cur(p_previous_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
281: p_inventory_item_id IN Number,p_fin_year IN Number, p_register_type Char) IS
282: Select nvl(opening_balance_qty,0), nvl(closing_balance_qty,0)
283: From JAI_CMN_RG_23AC_I_TRXS
284: Where slno = p_previous_serial_no
285: And organization_id = p_organization_id
286: And location_id = nvl(p_location_id,0)
287: And register_type = p_register_type

Line 296: lv_remarks jai_cmn_rg_23ac_i_trxs.remarks%TYPE;

292: v_opening_balance_qty Number := 0;
293: v_transaction_quantity Number := 0;
294: v_closing_balance_qty Number := 0;
295: v_debug_flag VARCHAR2 (1); -- char(1) :='Y'; --Added by Nagaraj.s for Bug2708516 (For File.Sql.35 by Brathod)
296: lv_remarks jai_cmn_rg_23ac_i_trxs.remarks%TYPE;
297:
298:
299: Begin
300: /*------------------------------------------------------------------------------------------

Line 389: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

385: end if;
386: lv_remarks := substr(rg23_rec.remarks,1,100); /*Added by nprashar for bug # 13649626*/
387: lv_remarks := substr(lv_remarks||' - Master Org',1,120); /*Added by nprashar for bug # 13649626*/
388:
389: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
390: (register_id,
391: fin_year,
392: slno,
393: TRANSACTION_SOURCE_NUM,

Line 509: UPDATE JAI_CMN_RG_23AC_I_TRXS

505: rg23_rec.last_update_login,
506: rg23_rec.last_update_date,
507: rg23_rec.last_updated_by);
508:
509: UPDATE JAI_CMN_RG_23AC_I_TRXS
510: SET posted_flag = 'Y',
511: master_flag = 'N'
512: WHERE register_id = rg23_rec.register_id;
513: