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 100: FROM JAI_CMN_RG_23AC_II_TRXS

96:
97: CURSOR balance_cur(p_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER,
98: p_fin_year NUMBER, p_register_type VARCHAR2) IS
99: SELECT nvl(closing_balance,0)
100: FROM JAI_CMN_RG_23AC_II_TRXS
101: WHERE organization_id = p_org_id
102: AND location_id = p_location_id
103: AND slno = p_serial_no
104: AND register_type = p_register_type

Line 109: FROM JAI_CMN_RG_23AC_II_TRXS

105: AND fin_year = p_fin_year;
106:
107: CURSOR serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER, p_register_type VARCHAR2) IS
108: SELECT nvl(max(slno),0)
109: FROM JAI_CMN_RG_23AC_II_TRXS
110: WHERE organization_id = p_org_id
111: and location_id = p_location_id
112: and fin_year = p_fin_year
113: and register_type = p_register_type;

Line 123: From JAI_CMN_RG_23AC_II_TRXS

119: NVL(fin_active_flag,'N') = 'Y';
120:
121: CURSOR c_rg23_fin_yr(p_org_id NUMBER, p_location_id NUMBER, p_register VARCHAR2) IS
122: Select max(fin_year) fin_year
123: From JAI_CMN_RG_23AC_II_TRXS
124: Where organization_id = p_org_id
125: and location_id = p_location_id
126: and register_type = p_register;
127:

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

188: v_not_a_first_transaction BOOLEAN := true;
189: v_remarks VARCHAR2(50); -- := 'RG Funds Transfer'; File.Sql.35 by Brathod
190: v_user_id NUMBER ; -- := nvl(to_number(FND_PROFILE.value('USER_ID')), -1) File.Sql.35 by Brathod
191: v_login_id NUMBER ;-- := nvl(to_number(FND_PROFILE.value('LOGIN_ID')), -1) File.Sql.35 by Brathod
192: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
193: /*Bug 4543171 bduvarag start*/
194: CURSOR currency_cur IS
195: SELECT currency_code
196: FROM JAI_CMN_RG_BALANCES_v

Line 325: from JAI_CMN_RG_23AC_II_TRXS a

321:
322:
323: CURSOR c_rg23_cess_slno(c_tax_type VARCHAR2, c_register_type VARCHAR2, c_source_register VARCHAR2) IS
324: select max(slno) slno
325: from JAI_CMN_RG_23AC_II_TRXS a
326: where organization_id = p_organization_id
327: and location_id = p_location_id
328: and fin_year = p_fin_year
329: AND register_type = c_register_type

Line 342: JAI_CMN_RG_23AC_II_TRXS b

338: CURSOR c_rg23_cess_master_org(c_slno NUMBER, c_tax_type VARCHAR,
339: c_register_type VARCHAR2, c_source_register VARCHAR2) IS
340: Select NVL(a.closing_balance,0) closing_balance
341: from JAI_CMN_RG_OTHERS a,
342: JAI_CMN_RG_23AC_II_TRXS b
343: Where a.source_type = 1 --1 is for RG23
344: AND b.register_id = a.source_register_id
345: AND b.organization_id = p_organization_id
346: and b.location_id = p_location_id

Line 360: FROM JAI_CMN_RG_23AC_II_TRXS b

356: Where a.source_type = 1 --1 is for RG23
357: and a.tax_type = c_tax_type
358: and a.source_register = c_source_register/*Bug 5141459 bduvarag*/
359: AND a.source_register_id = (SELECT register_id
360: FROM JAI_CMN_RG_23AC_II_TRXS b
361: WHERE b.slno =(
362: SELECT MAX(JIRP.slno)
363: FROM JAI_CMN_RG_23AC_II_TRXS JIRP
364: WHERE JIRP.organization_id = p_organization_id

Line 363: FROM JAI_CMN_RG_23AC_II_TRXS JIRP

359: AND a.source_register_id = (SELECT register_id
360: FROM JAI_CMN_RG_23AC_II_TRXS b
361: WHERE b.slno =(
362: SELECT MAX(JIRP.slno)
363: FROM JAI_CMN_RG_23AC_II_TRXS JIRP
364: WHERE JIRP.organization_id = p_organization_id
365: AND JIRP.location_id = p_location_id
366: AND JIRP.fin_year = p_fin_year
367: AND JIRP.register_type = p_register_type

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

406: c_source_register IN VARCHAR2,
407: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS
408: SELECT nvl(a.closing_balance,0) closing_balance
409: FROM JAI_CMN_RG_OTHERS a
410: WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
411: AND a.source_register = c_source_register
412: AND a.tax_type = c_tax_type
413: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
414: FROM JAI_CMN_RG_23AC_II_TRXS b,

Line 414: FROM JAI_CMN_RG_23AC_II_TRXS b,

410: WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
411: AND a.source_register = c_source_register
412: AND a.tax_type = c_tax_type
413: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
414: FROM JAI_CMN_RG_23AC_II_TRXS b,
415: JAI_CMN_RG_OTHERS c
416: WHERE b.register_id = c.source_register_id
417: AND b.organization_id = c_organization_id
418: AND b.location_id = c_location_id

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

417: AND b.organization_id = c_organization_id
418: AND b.location_id = c_location_id
419: AND b.register_type = c_register_type
420: AND c.tax_type = c_tax_type
421: AND c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
422: AND c.source_register = c_source_register);*/
423:
424: v_cess_amount JAI_CMN_RG_OTHERS.debit%TYPE;
425: v_cess_opening_balance JAI_CMN_RG_OTHERS.opening_balance%TYPE;

Line 853: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

849: FETCH fin_year_cur INTO v_fin_year;
850: CLOSE fin_year_cur;
851: lv_reference_num := v_remarks||'. Slno-'||v_slno;--rchandan for bug#4428980
852:
853: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
854: REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
855: RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
856: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
857: REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,

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

859: REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
860: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
861: other_tax_debit --Added by Sanjikum for cess for Bug #4136939
862: ) VALUES (
863: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_fin_year, v_slno, v_src_transaction_id, -1, p_organization_id,
864: null, null, null, null, null, null, null,
865: p_amount, null, null, null, null,
866: v_register, v_remarks, null, null, null, null,
867: p_location_id, SYSDATE, v_opening_balance, v_closing_balance, null,

Line 1135: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(

1131: v_to_slno := v_to_previous_serial_no + 1;
1132: v_to_opening_balance := nvl(v_to_closing_balance, 0);
1133: v_to_closing_balance := v_to_opening_balance + p_amount;
1134: lv_reference_num := v_remarks||'. Slno-'||v_slno;--rchandan for bug#4428980
1135: INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
1136: REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
1137: RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
1138: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
1139: REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,

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

1141: REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1142: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
1143: OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
1144: ) VALUES (
1145: JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_to_fin_year, v_to_slno, v_to_transaction_id, -1, p_to_organization_id,
1146: v_from_register_id, null, null, null, p_amount, null, null,
1147: null, null, null, null, null,
1148: v_register, v_remarks, null, null, null, null,
1149: p_to_location_id, SYSDATE, v_to_opening_balance, v_to_closing_balance, null,

Line 1154: UPDATE JAI_CMN_RG_23AC_II_TRXS

1150: null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null, lv_reference_num,--rchandan for bug#4428980
1151: p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
1152: ) RETURNING register_id INTO v_to_register_id;
1153:
1154: UPDATE JAI_CMN_RG_23AC_II_TRXS
1155: SET RECEIPT_REF = v_to_register_id
1156: WHERE register_id = v_from_register_id;
1157: /*Bug 4543171 bduvarag start*/
1158: IF p_register = 'RG23A' THEN