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 63: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,

59:
60: --Added by Sanjikum for cess for Bug #4136939
61: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
62: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
63: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
64: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
65: IS
66: SELECT NVL(SUM(balance),0) balance
67: FROM JAI_CMN_RG_OTH_BALANCES a,

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

60: --Added by Sanjikum for cess for Bug #4136939
61: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
62: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
63: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
64: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
65: IS
66: SELECT NVL(SUM(balance),0) balance
67: FROM JAI_CMN_RG_OTH_BALANCES a,
68: JAI_CMN_INVENTORY_ORGS b

Line 67: FROM JAI_CMN_RG_OTH_BALANCES a,

63: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
64: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
65: IS
66: SELECT NVL(SUM(balance),0) balance
67: FROM JAI_CMN_RG_OTH_BALANCES a,
68: JAI_CMN_INVENTORY_ORGS b
69: WHERE a.org_unit_id = b.org_unit_id
70: AND b.organization_id = p_organization_id
71: AND b.location_id = p_location_id

Line 78: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,

74: AND a.tax_type = NVL(p_tax_type,a.tax_type);
75: /*Bug 5989740 bduvarag start*/
76: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
77: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
78: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
79: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
80: IS
81: SELECT NVL(SUM(balance),0) balance
82: FROM JAI_CMN_RG_OTH_BALANCES a,

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

75: /*Bug 5989740 bduvarag start*/
76: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
77: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
78: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
79: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
80: IS
81: SELECT NVL(SUM(balance),0) balance
82: FROM JAI_CMN_RG_OTH_BALANCES a,
83: JAI_CMN_INVENTORY_ORGS b

Line 82: FROM JAI_CMN_RG_OTH_BALANCES a,

78: p_register_type IN JAI_CMN_RG_OTH_BALANCES.register_type%TYPE,
79: p_tax_type IN JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE DEFAULT NULL)
80: IS
81: SELECT NVL(SUM(balance),0) balance
82: FROM JAI_CMN_RG_OTH_BALANCES a,
83: JAI_CMN_INVENTORY_ORGS b
84: WHERE a.org_unit_id = b.org_unit_id
85: AND b.organization_id = p_organization_id
86: AND b.location_id = p_location_id

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

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

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

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

Line 427: v_tax_type JAI_CMN_RG_OTH_BALANCES.tax_type%TYPE;

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