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.

[Home] [Help]

APPS.JAI_CMN_RG_TRANSFER_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 130: From JAI_CMN_RG_PLA_TRXS

126: and register_type = p_register;
127:
128: CURSOR c_pla_fin_yr(p_org_id NUMBER, p_location_id NUMBER) IS
129: Select max(fin_year) fin_year
130: From JAI_CMN_RG_PLA_TRXS
131: Where organization_id = p_org_id
132: and location_id = p_location_id;
133:
134: CURSOR pla_serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS

Line 136: FROM JAI_CMN_RG_PLA_TRXS

132: and location_id = p_location_id;
133:
134: CURSOR pla_serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS
135: SELECT nvl(max(slno),0)
136: FROM JAI_CMN_RG_PLA_TRXS
137: WHERE organization_id = p_org_id
138: and location_id = p_location_id
139: and fin_year = p_fin_year;
140:

Line 143: FROM JAI_CMN_RG_PLA_TRXS

139: and fin_year = p_fin_year;
140:
141: CURSOR pla_balance_cur(p_previous_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS
142: SELECT nvl(closing_balance,0)
143: FROM JAI_CMN_RG_PLA_TRXS
144: WHERE organization_id = p_org_id
145: AND location_id = p_location_id
146: AND slno = p_previous_serial_no
147: AND fin_year = p_fin_year;

Line 273: from JAI_CMN_RG_PLA_TRXS a

269: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.insert_rg_others';
270:
271: CURSOR c_pla_cess_slno(c_tax_type VARCHAR2) IS
272: select max(slno) slno
273: from JAI_CMN_RG_PLA_TRXS a
274: where organization_id = p_organization_id
275: and location_id = p_location_id
276: and fin_year = p_fin_year
277: and register_id < 0

Line 287: JAI_CMN_RG_PLA_TRXS b

283:
284: CURSOR c_pla_cess_master_org(c_slno NUMBER, c_tax_type VARCHAR) IS
285: Select NVL(a.closing_balance,0) closing_balance
286: from JAI_CMN_RG_OTHERS a,
287: JAI_CMN_RG_PLA_TRXS b
288: Where a.source_type = 2 --2 is for PLA
289: AND b.register_id = a.source_register_id
290: AND b.organization_id = p_organization_id
291: and b.location_id = p_location_id

Line 302: FROM JAI_CMN_RG_PLA_TRXS b

298: from JAI_CMN_RG_OTHERS a
299: Where a.source_type = 2 --2 is for PLA
300: and a.tax_type = c_tax_type /*Bug 5141459 bduvarag*/
301: AND a.source_register_id = (SELECT b.register_id
302: FROM JAI_CMN_RG_PLA_TRXS b
303: WHERE b.slno =(
304: SELECT MAX(JIP.slno)
305: FROM JAI_CMN_RG_PLA_TRXS JIP
306: WHERE JIP.organization_id = p_organization_id

Line 305: FROM JAI_CMN_RG_PLA_TRXS JIP

301: AND a.source_register_id = (SELECT b.register_id
302: FROM JAI_CMN_RG_PLA_TRXS b
303: WHERE b.slno =(
304: SELECT MAX(JIP.slno)
305: FROM JAI_CMN_RG_PLA_TRXS JIP
306: WHERE JIP.organization_id = p_organization_id
307: AND JIP.location_id = p_location_id
308: AND JIP.fin_year = p_fin_year
309: AND JIP.register_id > 0

Line 390: WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS

386: c_source_register IN VARCHAR2,
387: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS
388: SELECT nvl(a.closing_balance,0) closing_balance
389: FROM JAI_CMN_RG_OTHERS a
390: WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
391: AND a.source_register = c_source_register
392: AND a.tax_type = c_tax_type
393: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
394: FROM JAI_CMN_RG_PLA_TRXS b,

Line 394: FROM JAI_CMN_RG_PLA_TRXS b,

390: WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
391: AND a.source_register = c_source_register
392: AND a.tax_type = c_tax_type
393: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
394: FROM JAI_CMN_RG_PLA_TRXS b,
395: JAI_CMN_RG_OTHERS c
396: WHERE b.register_id = c.source_register_id
397: AND b.organization_id = c_organization_id
398: AND b.location_id = c_location_id

Line 400: AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS

396: WHERE b.register_id = c.source_register_id
397: AND b.organization_id = c_organization_id
398: AND b.location_id = c_location_id
399: AND c.tax_type = c_tax_type
400: AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
401: AND c.source_register = c_source_register);
402:
403: CURSOR cess_balance_cur(c_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
404: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

Line 995: INSERT INTO JAI_CMN_RG_PLA_TRXS(

991: OPEN fin_year_cur(p_organization_id , p_location_id) ;
992: FETCH fin_year_cur INTO v_fin_year;
993: CLOSE fin_year_cur;
994:
995: INSERT INTO JAI_CMN_RG_PLA_TRXS(
996: REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
997: CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
998: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
999: ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,

Line 1006: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_fin_year, v_slno, null, null, null, null,

1002: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
1003: ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
1004: OTHER_TAX_DEBIT --Added by Sanjikum for cess for Bug #4136939
1005: ) VALUES (
1006: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_fin_year, v_slno, null, null, null, null,
1007: null, v_src_transaction_id, null, null, null, null,
1008: p_amount, null, null, p_organization_id, p_location_id, null,
1009: SYSDATE, null, null, null, null, null,
1010: null, null, v_remarks, trunc(SYSDATE), v_opening_balance, v_closing_balance,

Line 1293: INSERT INTO JAI_CMN_RG_PLA_TRXS(

1289: v_to_slno := v_to_previous_serial_no + 1;
1290: v_to_opening_balance := nvl(v_to_closing_balance, 0);
1291: v_to_closing_balance := v_to_opening_balance + p_amount;
1292:
1293: INSERT INTO JAI_CMN_RG_PLA_TRXS(
1294: REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
1295: CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
1296: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
1297: ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,

Line 1304: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_to_fin_year, v_to_slno, null, null, p_amount, null,

1300: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
1301: ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
1302: OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
1303: ) VALUES (
1304: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_to_fin_year, v_to_slno, null, null, p_amount, null,
1305: null, v_to_transaction_id, v_from_register_id, null, null, null,
1306: null, null, null, p_to_organization_id, p_to_location_id, null,
1307: SYSDATE, null, null, null, null, null,
1308: null, null, v_remarks, trunc(SYSDATE), v_to_opening_balance, v_to_closing_balance,

Line 1315: UPDATE JAI_CMN_RG_PLA_TRXS

1311: null, null, null, null,
1312: p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
1313: ) RETURNING register_id INTO v_to_register_id;
1314:
1315: UPDATE JAI_CMN_RG_PLA_TRXS
1316: SET ref_document_id = v_to_register_id
1317: WHERE register_id = v_from_register_id;
1318: /*Bug 4543171 bduvarag start*/
1319: IF p_register = 'PLA' THEN