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 56: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980

52: ) IS
53:
54: /* Added by Ramananda for bug#4407165 */
55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
56: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
57: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
58:
59: p_org_code org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043

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

53:
54: /* Added by Ramananda for bug#4407165 */
55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
56: lv_debit jai_cmn_rg_others.debit%TYPE ; --rchandan for bug#4428980
57: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
58:
59: p_org_code org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
60: p_org_code_to org_organization_definitions.organization_code%type; --Added by nprashar for bug # 13824043
61:

Line 169: v_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;

165: v_excise_cess_bal NUMBER;
166: v_excise_cess_amount NUMBER;
167: v_cvd_cess_amount NUMBER;
168: v_oth_balances c_oth_balances%ROWTYPE;
169: v_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
170: --End Added by Sanjikum for cess for Bug #4136939
171: /*Bug 5989740 bduvarag start*/
172: v_sh_excise_cess_bal NUMBER;
173: v_sh_excise_cess_amount NUMBER;

Line 287: from JAI_CMN_RG_OTHERS

283: and location_id = p_location_id
284: and fin_year = p_fin_year
285: and register_id < 0
286: and exists (select '1'
287: from JAI_CMN_RG_OTHERS
288: where source_type = 2 --2 is for PLA
289: and source_register_id = a.register_id
290: and tax_type = c_tax_type);
291:

Line 294: from JAI_CMN_RG_OTHERS a,

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

Line 306: from JAI_CMN_RG_OTHERS a

302: and b.fin_year = p_fin_year;
303:
304: cursor c_pla_cess_non_master_org(c_tax_type VARCHAR2) is
305: Select nvl(a.closing_balance,0) closing_balance
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

Line 319: FROM JAI_CMN_RG_OTHERS

315: AND JIP.location_id = p_location_id
316: AND JIP.fin_year = p_fin_year
317: AND JIP.register_id > 0
318: AND EXISTS (SELECT '1'
319: FROM JAI_CMN_RG_OTHERS
320: WHERE source_type = 2
321: AND source_register_id = JIP.register_id
322: AND source_register = p_source_register
323: AND tax_type = c_tax_type)

Line 340: from JAI_CMN_RG_OTHERS

336: and fin_year = p_fin_year
337: AND register_type = c_register_type
338: and register_id < 0
339: and exists (select '1'
340: from JAI_CMN_RG_OTHERS
341: where source_type = 1 --1 is for RG23
342: and source_register_id = a.register_id
343: and source_register = c_source_register
344: and tax_type = c_tax_type);

Line 349: from JAI_CMN_RG_OTHERS a,

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

Line 363: from JAI_CMN_RG_OTHERS a

359: AND a.source_register = c_source_register;
360:
361: cursor c_rg23_cess_non_master_org(c_tax_type VARCHAR2, c_register_type VARCHAR2, c_source_register VARCHAR2) IS
362: Select nvl(a.closing_balance,0) closing_balance
363: from JAI_CMN_RG_OTHERS a
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

Line 377: FROM JAI_CMN_RG_OTHERS

373: AND JIRP.location_id = p_location_id
374: AND JIRP.fin_year = p_fin_year
375: AND JIRP.register_type = p_register_type
376: AND EXISTS (SELECT '1'
377: FROM JAI_CMN_RG_OTHERS
378: WHERE source_type = 2
379: AND source_register_id = JIRP.register_id
380: AND source_register = p_source_register
381: AND tax_type = c_tax_type

Line 397: FROM JAI_CMN_RG_OTHERS a

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

Line 403: JAI_CMN_RG_OTHERS c

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

Line 417: FROM JAI_CMN_RG_OTHERS a

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

Line 423: JAI_CMN_RG_OTHERS c

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

Line 432: v_cess_amount JAI_CMN_RG_OTHERS.debit%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;
434: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
435: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
436: v_source_type NUMBER(1);

Line 433: v_cess_opening_balance JAI_CMN_RG_OTHERS.opening_balance%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;
434: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
435: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
436: v_source_type NUMBER(1);
437: v_slno NUMBER;

Line 434: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;

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;
434: v_cess_closing_balance JAI_CMN_RG_OTHERS.closing_balance%TYPE;
435: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;
436: v_source_type NUMBER(1);
437: v_slno NUMBER;
438:

Line 440: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside jai_cmn_rg_others');

436: v_source_type NUMBER(1);
437: v_slno NUMBER;
438:
439: BEGIN
440: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside jai_cmn_rg_others');
441:
442:
443:
444: FOR i in 1..4 LOOP/*Bug 5989740 bduvarag*/

Line 545: INSERT INTO JAI_CMN_RG_OTHERS

541: ELSIF p_transfer_from_to = 'TO' THEN
542: lv_credit := v_cess_amount;
543: END IF;--rchandan for bug#4428980
544:
545: INSERT INTO JAI_CMN_RG_OTHERS
546: (RG_OTHER_ID,
547: SOURCE_TYPE,
548: SOURCE_REGISTER,
549: SOURCE_REGISTER_ID,

Line 560: (JAI_CMN_RG_OTHERS_S.nextval,

556: CREATION_DATE,
557: LAST_UPDATED_BY,
558: LAST_UPDATE_DATE)
559: VALUES
560: (JAI_CMN_RG_OTHERS_S.nextval,
561: v_source_type,
562: p_source_register,
563: p_register_id,
564: v_tax_type,