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_PLA_TRXS

Line 138: From JAI_CMN_RG_PLA_TRXS

134: and register_type = p_register;
135:
136: CURSOR c_pla_fin_yr(p_org_id NUMBER, p_location_id NUMBER) IS
137: Select max(fin_year) fin_year
138: From JAI_CMN_RG_PLA_TRXS
139: Where organization_id = p_org_id
140: and location_id = p_location_id;
141:
142: CURSOR pla_serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS

Line 144: FROM JAI_CMN_RG_PLA_TRXS

140: and location_id = p_location_id;
141:
142: CURSOR pla_serial_no_cur(p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS
143: SELECT nvl(max(slno),0)
144: FROM JAI_CMN_RG_PLA_TRXS
145: WHERE organization_id = p_org_id
146: and location_id = p_location_id
147: and fin_year = p_fin_year;
148:

Line 151: FROM JAI_CMN_RG_PLA_TRXS

147: and fin_year = p_fin_year;
148:
149: CURSOR pla_balance_cur(p_previous_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER, p_fin_year NUMBER) IS
150: SELECT nvl(closing_balance,0)
151: FROM JAI_CMN_RG_PLA_TRXS
152: WHERE organization_id = p_org_id
153: AND location_id = p_location_id
154: AND slno = p_previous_serial_no
155: AND fin_year = p_fin_year;

Line 281: from JAI_CMN_RG_PLA_TRXS a

277: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.insert_rg_others';
278:
279: CURSOR c_pla_cess_slno(c_tax_type VARCHAR2) IS
280: select max(slno) slno
281: from JAI_CMN_RG_PLA_TRXS a
282: where organization_id = p_organization_id
283: and location_id = p_location_id
284: and fin_year = p_fin_year
285: and register_id < 0

Line 295: JAI_CMN_RG_PLA_TRXS b

291:
292: CURSOR c_pla_cess_master_org(c_slno NUMBER, c_tax_type VARCHAR) IS
293: Select NVL(a.closing_balance,0) closing_balance
294: from JAI_CMN_RG_OTHERS a,
295: JAI_CMN_RG_PLA_TRXS b
296: Where a.source_type = 2 --2 is for PLA
297: AND b.register_id = a.source_register_id
298: AND b.organization_id = p_organization_id
299: and b.location_id = p_location_id

Line 310: FROM JAI_CMN_RG_PLA_TRXS b

306: from JAI_CMN_RG_OTHERS a
307: Where a.source_type = 2 --2 is for PLA
308: and a.tax_type = c_tax_type /*Bug 5141459 bduvarag*/
309: AND a.source_register_id = (SELECT b.register_id
310: FROM JAI_CMN_RG_PLA_TRXS b
311: WHERE b.slno =(
312: SELECT MAX(JIP.slno)
313: FROM JAI_CMN_RG_PLA_TRXS JIP
314: WHERE JIP.organization_id = p_organization_id

Line 313: FROM JAI_CMN_RG_PLA_TRXS JIP

309: AND a.source_register_id = (SELECT b.register_id
310: FROM JAI_CMN_RG_PLA_TRXS b
311: WHERE b.slno =(
312: SELECT MAX(JIP.slno)
313: FROM JAI_CMN_RG_PLA_TRXS JIP
314: WHERE JIP.organization_id = p_organization_id
315: AND JIP.location_id = p_location_id
316: AND JIP.fin_year = p_fin_year
317: AND JIP.register_id > 0

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

394: c_source_register IN VARCHAR2,
395: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS
396: SELECT nvl(a.closing_balance,0) closing_balance
397: FROM JAI_CMN_RG_OTHERS a
398: WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
399: AND a.source_register = c_source_register
400: AND a.tax_type = c_tax_type
401: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
402: FROM JAI_CMN_RG_PLA_TRXS b,

Line 402: FROM JAI_CMN_RG_PLA_TRXS b,

398: WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
399: AND a.source_register = c_source_register
400: AND a.tax_type = c_tax_type
401: AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
402: FROM JAI_CMN_RG_PLA_TRXS b,
403: JAI_CMN_RG_OTHERS c
404: WHERE b.register_id = c.source_register_id
405: AND b.organization_id = c_organization_id
406: AND b.location_id = c_location_id

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

404: WHERE b.register_id = c.source_register_id
405: AND b.organization_id = c_organization_id
406: AND b.location_id = c_location_id
407: AND c.tax_type = c_tax_type
408: AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
409: AND c.source_register = c_source_register);
410:
411: CURSOR cess_balance_cur(c_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
412: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

Line 1110: INSERT INTO JAI_CMN_RG_PLA_TRXS(

1106: OPEN fin_year_cur(p_organization_id , p_location_id) ;
1107: FETCH fin_year_cur INTO v_fin_year;
1108: CLOSE fin_year_cur;
1109:
1110: INSERT INTO JAI_CMN_RG_PLA_TRXS(
1111: REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
1112: CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
1113: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
1114: ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,

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

1117: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
1118: ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
1119: OTHER_TAX_DEBIT --Added by Sanjikum for cess for Bug #4136939
1120: ) VALUES (
1121: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_fin_year, v_slno, null, null, null, null,
1122: --null, v_src_transaction_id, null, null, null, null,
1123: null, p_transfer_id, null, null, null, null, -- for bug 14259917 by anupgupt
1124: p_amount, null, null, p_organization_id, p_location_id, null,
1125: SYSDATE, null, null, null, null, null,

Line 1440: INSERT INTO JAI_CMN_RG_PLA_TRXS(

1436: v_to_slno := v_to_previous_serial_no + 1;
1437: v_to_opening_balance := nvl(v_to_closing_balance, 0);
1438: v_to_closing_balance := v_to_opening_balance + p_amount;
1439:
1440: INSERT INTO JAI_CMN_RG_PLA_TRXS(
1441: REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
1442: CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
1443: DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
1444: ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,

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

1447: LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
1448: ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
1449: OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
1450: ) VALUES (
1451: JAI_CMN_RG_PLA_TRXS_S1.nextval, v_to_fin_year, v_to_slno, null, null, p_amount, null,
1452: null, v_to_transaction_id, v_from_register_id, null, null, null,
1453: null, null, null, p_to_organization_id, p_to_location_id, null,
1454: SYSDATE, null, null, null, null, null,
1455: null, null, v_remarks, trunc(SYSDATE), v_to_opening_balance, v_to_closing_balance,

Line 1462: UPDATE JAI_CMN_RG_PLA_TRXS

1458: null, null, null, null,
1459: p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
1460: ) RETURNING register_id INTO v_to_register_id;
1461:
1462: UPDATE JAI_CMN_RG_PLA_TRXS
1463: SET ref_document_id = v_to_register_id
1464: WHERE register_id = v_from_register_id;
1465: /*Bug 4543171 bduvarag start*/
1466: IF p_register = 'PLA' THEN