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_OTHERS

Line 51: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980

47: ) IS
48:
49: /* Added by Ramananda for bug#4407165 */
50: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
51: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
52: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
53:
54: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
55: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)

Line 52: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980

48:
49: /* Added by Ramananda for bug#4407165 */
50: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
51: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
52: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
53:
54: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
55: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)
56: from JAI_CMN_RG_BALANCES

Line 161: v_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;

157: v_excise_cess_bal NUMBER;
158: v_excise_cess_amount NUMBER;
159: v_cvd_cess_amount NUMBER;
160: v_oth_balances c_oth_balances%ROWTYPE;
161: v_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
162: --End Added by Sanjikum for cess for Bug #4136939
163: /*Bug 5989740 bduvarag start*/
164: v_sh_excise_cess_bal NUMBER;
165: v_sh_excise_cess_amount NUMBER;

Line 279: from JAI_CMN_RG_OTHERS

275: and location_id = p_location_id
276: and fin_year = p_fin_year
277: and register_id < 0
278: and exists (select '1'
279: from JAI_CMN_RG_OTHERS
280: where source_type = 2 --2 is for PLA
281: and source_register_id = a.register_id
282: and tax_type = c_tax_type);
283:

Line 286: from JAI_CMN_RG_OTHERS a,

282: and tax_type = c_tax_type);
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

Line 298: from JAI_CMN_RG_OTHERS a

294: and b.fin_year = p_fin_year;
295:
296: cursor c_pla_cess_non_master_org(c_tax_type VARCHAR2) is
297: Select nvl(a.closing_balance,0) closing_balance
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

Line 311: FROM JAI_CMN_RG_OTHERS

307: AND JIP.location_id = p_location_id
308: AND JIP.fin_year = p_fin_year
309: AND JIP.register_id > 0
310: AND EXISTS (SELECT '1'
311: FROM JAI_CMN_RG_OTHERS
312: WHERE source_type = 2
313: AND source_register_id = JIP.register_id
314: AND source_register = p_source_register
315: AND tax_type = c_tax_type)

Line 332: from JAI_CMN_RG_OTHERS

328: and fin_year = p_fin_year
329: AND register_type = c_register_type
330: and register_id < 0
331: and exists (select '1'
332: from JAI_CMN_RG_OTHERS
333: where source_type = 1 --1 is for RG23
334: and source_register_id = a.register_id
335: and source_register = c_source_register
336: and tax_type = c_tax_type);

Line 341: from JAI_CMN_RG_OTHERS a,

337:
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

Line 355: from JAI_CMN_RG_OTHERS a

351: AND a.source_register = c_source_register;
352:
353: cursor c_rg23_cess_non_master_org(c_tax_type VARCHAR2, c_register_type VARCHAR2, c_source_register VARCHAR2) IS
354: Select nvl(a.closing_balance,0) closing_balance
355: from JAI_CMN_RG_OTHERS a
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

Line 369: FROM JAI_CMN_RG_OTHERS

365: AND JIRP.location_id = p_location_id
366: AND JIRP.fin_year = p_fin_year
367: AND JIRP.register_type = p_register_type
368: AND EXISTS (SELECT '1'
369: FROM JAI_CMN_RG_OTHERS
370: WHERE source_type = 2
371: AND source_register_id = JIRP.register_id
372: AND source_register = p_source_register
373: AND tax_type = c_tax_type

Line 389: FROM JAI_CMN_RG_OTHERS a

385: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
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))

Line 395: JAI_CMN_RG_OTHERS c

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
399: AND c.tax_type = c_tax_type

Line 409: FROM JAI_CMN_RG_OTHERS a

405: c_register_type IN VARCHAR2,
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))

Line 415: JAI_CMN_RG_OTHERS c

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
419: AND b.register_type = c_register_type

Line 424: v_cess_amount JAI_CMN_RG_OTHERS.debit%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;
426: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
427: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
428: v_source_type NUMBER(1);

Line 425: v_cess_opening_balance JAI_CMN_RG_OTHERS.opening_balance%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;
426: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
427: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
428: v_source_type NUMBER(1);
429: v_slno NUMBER;

Line 426: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;

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;
426: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
427: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
428: v_source_type NUMBER(1);
429: v_slno NUMBER;
430:

Line 515: INSERT INTO JAI_CMN_RG_OTHERS

511: ELSIF p_transfer_from_to = 'TO' THEN
512: lv_credit := v_cess_amount;
513: END IF;--rchandan for bug#4428980
514:
515: INSERT INTO JAI_CMN_RG_OTHERS
516: (RG_OTHER_ID,
517: SOURCE_TYPE,
518: SOURCE_REGISTER,
519: SOURCE_REGISTER_ID,

Line 530: (JAI_CMN_RG_OTHERS_S.nextval,

526: CREATION_DATE,
527: LAST_UPDATED_BY,
528: LAST_UPDATE_DATE)
529: VALUES
530: (JAI_CMN_RG_OTHERS_S.nextval,
531: v_source_type,
532: p_source_register,
533: p_register_id,
534: v_tax_type,