eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RG_TRANSFER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 108: FROM JAI_CMN_RG_23AC_II_TRXS

104:
105: CURSOR balance_cur(p_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER,
106: p_fin_year NUMBER, p_register_type VARCHAR2) IS
107: SELECT nvl(closing_balance,0)
108: FROM JAI_CMN_RG_23AC_II_TRXS
109: WHERE organization_id = p_org_id
110: AND location_id = p_location_id
111: AND slno = p_serial_no
112: AND register_type = p_register_type

Line 117: FROM JAI_CMN_RG_23AC_II_TRXS

113: AND fin_year = p_fin_year;
114:
115: CURSOR serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER, p_register_type VARCHAR2) IS
116: SELECT nvl(max(slno),0)
117: FROM JAI_CMN_RG_23AC_II_TRXS
118: WHERE organization_id = p_org_id
119: and location_id = p_location_id
120: and fin_year = p_fin_year
121: and register_type = p_register_type;

Line 131: From JAI_CMN_RG_23AC_II_TRXS

127: NVL(fin_active_flag,'N') = 'Y';
128:
129: CURSOR c_rg23_fin_yr(p_org_id NUMBER, p_location_id NUMBER, p_register VARCHAR2) IS
130: Select max(fin_year) fin_year
131: From JAI_CMN_RG_23AC_II_TRXS
132: Where organization_id = p_org_id
133: and location_id = p_location_id
134: and register_type = p_register;
135:

Line 200: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980

196: v_not_a_first_transaction BOOLEAN := true;
197: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
198: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
199: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
200: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
201: /*Bug 4543171 bduvarag start*/
202: CURSOR currency_cur IS
203: SELECT currency_code
204: FROM JAI_CMN_RG_BALANCES_v

Line 333: from JAI_CMN_RG_23AC_II_TRXS a

329:
330:
331: CURSOR c_rg23_cess_slno(c_tax_type VARCHAR2, c_register_type VARCHAR2, c_source_register VARCHAR2) IS
332: select max(slno) slno
333: from JAI_CMN_RG_23AC_II_TRXS a
334: where organization_id = p_organization_id
335: and location_id = p_location_id
336: and fin_year = p_fin_year
337: AND register_type = c_register_type

Line 350: JAI_CMN_RG_23AC_II_TRXS b

346: CURSOR c_rg23_cess_master_org(c_slno NUMBER, c_tax_type VARCHAR,
347: c_register_type VARCHAR2, c_source_register VARCHAR2) IS
348: Select NVL(a.closing_balance,0) closing_balance
349: from JAI_CMN_RG_OTHERS a,
350: JAI_CMN_RG_23AC_II_TRXS b
351: Where a.source_type = 1 --1 is for RG23
352: AND b.register_id = a.source_register_id
353: AND b.organization_id = p_organization_id
354: and b.location_id = p_location_id

Line 368: FROM JAI_CMN_RG_23AC_II_TRXS b

364: Where a.source_type = 1 --1 is for RG23
365: and a.tax_type = c_tax_type
366: and a.source_register = c_source_register/*Bug 5141459 bduvarag*/
367: AND a.source_register_id = (SELECT register_id
368: FROM JAI_CMN_RG_23AC_II_TRXS b
369: WHERE b.slno =(
370: SELECT MAX(JIRP.slno)
371: FROM JAI_CMN_RG_23AC_II_TRXS JIRP
372: WHERE JIRP.organization_id = p_organization_id

Line 371: FROM JAI_CMN_RG_23AC_II_TRXS JIRP

367: AND a.source_register_id = (SELECT register_id
368: FROM JAI_CMN_RG_23AC_II_TRXS b
369: WHERE b.slno =(
370: SELECT MAX(JIRP.slno)
371: FROM JAI_CMN_RG_23AC_II_TRXS JIRP
372: WHERE JIRP.organization_id = p_organization_id
373: AND JIRP.location_id = p_location_id
374: AND JIRP.fin_year = p_fin_year
375: AND JIRP.register_type = p_register_type

Line 418: WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS

414: c_source_register IN VARCHAR2,
415: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS
416: SELECT nvl(a.closing_balance,0) closing_balance
417: FROM JAI_CMN_RG_OTHERS a
418: WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
419: AND a.source_register = c_source_register
420: AND a.tax_type = c_tax_type
421: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
422: FROM JAI_CMN_RG_23AC_II_TRXS b,

Line 422: FROM JAI_CMN_RG_23AC_II_TRXS b,

418: WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
419: AND a.source_register = c_source_register
420: AND a.tax_type = c_tax_type
421: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
422: FROM JAI_CMN_RG_23AC_II_TRXS b,
423: JAI_CMN_RG_OTHERS c
424: WHERE b.register_id = c.source_register_id
425: AND b.organization_id = c_organization_id
426: AND b.location_id = c_location_id

Line 429: AND c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS

425: AND b.organization_id = c_organization_id
426: AND b.location_id = c_location_id
427: AND b.register_type = c_register_type
428: AND c.tax_type = c_tax_type
429: AND c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
430: AND c.source_register = c_source_register);*/
431:
432: v_cess_amount JAI_CMN_RG_OTHERS.debit%TYPE;
433: v_cess_opening_balance JAI_CMN_RG_OTHERS.opening_balance%TYPE;

Line 952: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

948: CLOSE fin_year_cur;
949: --lv_reference_num := v_remarks||'. Slno-'||v_slno;--rchandan for bug#4428980
950: lv_reference_num := to_char(p_transfer_id); -- for bug 14259917 by anupgupt
951:
952: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
953: REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
954: RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
955: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
956: REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,

Line 962: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_fin_year, v_slno, v_src_transaction_id, -1, p_organization_id,

958: REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
959: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
960: other_tax_debit --Added by Sanjikum for cess for Bug #4136939
961: ) VALUES (
962: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_fin_year, v_slno, v_src_transaction_id, -1, p_organization_id,
963: null, null, null, null, null, null, null,
964: p_amount, null, null, null, null,
965: v_register, v_remarks, null, null, null, null,
966: p_location_id, SYSDATE, v_opening_balance, v_closing_balance, null,

Line 971: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Data inserted into JAI_CMN_RG_23AC_II_TRXS');

967: null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null,lv_reference_num,--rchandan for bug#4428980
968: p_cess_amount+ nvl(p_sh_cess_amount,0) --Added by Sanjikum for cess for Bug #4136939 --Added + nvl(p_sh_cess_amount,0) by JMEENA for bug#7260552
969: ) RETURNING register_id INTO v_from_register_id;
970:
971: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Data inserted into JAI_CMN_RG_23AC_II_TRXS');
972:
973: /*Bug 4543171 bduvarag start*/
974: IF p_register = 'RG23A' THEN
975:

Line 1266: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

1262: v_to_slno := v_to_previous_serial_no + 1;
1263: v_to_opening_balance := nvl(v_to_closing_balance, 0);
1264: v_to_closing_balance := v_to_opening_balance + p_amount;
1265: lv_reference_num := v_remarks||'. Slno-'||v_slno;--rchandan for bug#4428980
1266: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
1267: REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
1268: RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
1269: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
1270: REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,

Line 1276: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_to_fin_year, v_to_slno, v_to_transaction_id, -1, p_to_organization_id,

1272: REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1273: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
1274: OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
1275: ) VALUES (
1276: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_to_fin_year, v_to_slno, v_to_transaction_id, -1, p_to_organization_id,
1277: v_from_register_id, null, null, null, p_amount, null, null,
1278: null, null, null, null, null,
1279: v_register, v_remarks, null, null, null, null,
1280: p_to_location_id, SYSDATE, v_to_opening_balance, v_to_closing_balance, null,

Line 1285: UPDATE JAI_CMN_RG_23AC_II_TRXS

1281: null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null, lv_reference_num,--rchandan for bug#4428980
1282: p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
1283: ) RETURNING register_id INTO v_to_register_id;
1284:
1285: UPDATE JAI_CMN_RG_23AC_II_TRXS
1286: SET RECEIPT_REF = v_to_register_id
1287: WHERE register_id = v_from_register_id;
1288: /*Bug 4543171 bduvarag start*/
1289: IF p_register = 'RG23A' THEN