APPS.JAI_CMN_RG_PLA_TRXS_PKG dependencies on JAI_CMN_RG_PLA_TRXS_S1

Line 19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring

15: Issue: Inventory Convergence Uptake for R12 Initiative
16:
17: 28/12/2005 4892111 Hjujjuru, File Version 120.2
18: Issue : In the insert into the JAI_CMN_RG_PLA_TRXS , register_id
19: was inserted as JAI_CMN_RG_PLA_TRXS_S1.nextval. This is errorring
20: out.
21:
22: Fix : Created a cursor to retrieve the register_id value from the
23: sequence and inserted the same into the JAI_CMN_RG_PLA_TRXS table

Line 102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;

98: lv_statement_id VARCHAR2(5);
99:
100: -- added, Harshita for 4892111
101: Cursor c_fetch_register_id IS
102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;
103:
104: ln_register_id jai_cmn_rg_pla_trxs.register_id%type ;
105: -- ended, Harshita for 4892111
106:

Line 277: ln_register_id, --JAI_CMN_RG_PLA_TRXS_S1.nextval, Harshita for 4892111 --P_REGISTER_ID,

273: other_tax_credit,
274: other_tax_debit,
275: rounding_id
276: ) VALUES (
277: ln_register_id, --JAI_CMN_RG_PLA_TRXS_S1.nextval, Harshita for 4892111 --P_REGISTER_ID,
278: ln_fin_year, --P_FIN_YEAR,
279: ln_slno, --P_SLNO,
280: P_TR6_CHALLAN_NO,
281: P_TR6_CHALLAN_DATE,