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_OTH_BALANCES

Line 71: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,

67:
68: --Added by Sanjikum for cess for Bug #4136939
69: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
70: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
71: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
72: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
73: IS
74: SELECT NVL(SUM(balance),0) balance
75: FROM JAI_CMN_RG_OTH_BALANCES a,

Line 72: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)

68: --Added by Sanjikum for cess for Bug #4136939
69: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
70: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
71: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
72: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
73: IS
74: SELECT NVL(SUM(balance),0) balance
75: FROM JAI_CMN_RG_OTH_BALANCES a,
76: JAI_CMN_INVENTORY_ORGS b

Line 75: FROM JAI_CMN_RG_OTH_BALANCES a,

71: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
72: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
73: IS
74: SELECT NVL(SUM(balance),0) balance
75: FROM JAI_CMN_RG_OTH_BALANCES a,
76: JAI_CMN_INVENTORY_ORGS b
77: WHERE a.org_unit_id = b.org_unit_id
78: AND b.organization_id = p_organization_id
79: AND b.location_id = p_location_id

Line 86: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,

82: AND a.tax_type = NVL(p_tax_type,a.tax_type);
83: /*Bug 5989740 bduvarag start*/
84: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
85: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
86: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
87: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
88: IS
89: SELECT NVL(SUM(balance),0) balance
90: FROM JAI_CMN_RG_OTH_BALANCES a,

Line 87: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)

83: /*Bug 5989740 bduvarag start*/
84: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
85: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
86: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
87: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
88: IS
89: SELECT NVL(SUM(balance),0) balance
90: FROM JAI_CMN_RG_OTH_BALANCES a,
91: JAI_CMN_INVENTORY_ORGS b

Line 90: FROM JAI_CMN_RG_OTH_BALANCES a,

86: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
87: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
88: IS
89: SELECT NVL(SUM(balance),0) balance
90: FROM JAI_CMN_RG_OTH_BALANCES a,
91: JAI_CMN_INVENTORY_ORGS b
92: WHERE a.org_unit_id = b.org_unit_id
93: AND b.organization_id = p_organization_id
94: AND b.location_id = p_location_id

Line 395: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS

391:
392: /*CURSOR cess_balance_cur_pla(c_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
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

Line 415: c_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE) IS

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,
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

Line 435: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;

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:
439: BEGIN