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_INVENTORY_ORGS

Line 69: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

65: where organization_id = p_organization_id
66: and location_id = p_location_id;
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

Line 70: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

66: and location_id = p_location_id;
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

Line 76: JAI_CMN_INVENTORY_ORGS b

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
80: AND a.register_type = p_register_type

Line 84: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

80: AND a.register_type = p_register_type
81: AND a.tax_type in (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess)
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

Line 85: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

81: AND a.tax_type in (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess)
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

Line 91: JAI_CMN_INVENTORY_ORGS b

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
95: AND a.register_type = p_register_type

Line 213: FROM JAI_CMN_INVENTORY_ORGS

209: CURSOR rg23a_account_cur( p_orgid IN Number,
210: p_locid IN Number
211: )IS
212: SELECT MODVAT_RM_ACCOUNT_ID
213: FROM JAI_CMN_INVENTORY_ORGS
214: WHERE organization_id = p_orgid
215: AND location_id = p_locid;
216:
217: CURSOR rg23c_account_cur( p_orgid IN Number,

Line 221: FROM JAI_CMN_INVENTORY_ORGS

217: CURSOR rg23c_account_cur( p_orgid IN Number,
218: p_locid IN Number
219: )IS
220: SELECT MODVAT_CG_ACCOUNT_ID
221: FROM JAI_CMN_INVENTORY_ORGS
222: WHERE organization_id = p_orgid
223: AND location_id = p_locid;
224:
225: CURSOR pla_account_cur( p_orgid IN Number,

Line 229: FROM JAI_CMN_INVENTORY_ORGS

225: CURSOR pla_account_cur( p_orgid IN Number,
226: p_locid IN Number
227: )IS
228: SELECT MODVAT_PLA_ACCOUNT_ID
229: FROM JAI_CMN_INVENTORY_ORGS
230: WHERE organization_id = p_orgid
231: AND location_id = p_locid;
232:
233:

Line 247: JAI_CMN_INVENTORY_ORGS

243: 'C', SH_CESS_CG_ACCOUNT_ID
244: ) sh_cess_account_id
245:
246: FROM
247: JAI_CMN_INVENTORY_ORGS
248: WHERE organization_id = p_orgid
249: AND location_id = p_locid;
250:
251: lv_currency varchar2(10) ;

Line 263: PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

259: lv_to_account_id number ;
260:
261: /*Bug 4543171 bduvarag end*/
262: --Added by Sanjikum for cess for Bug #4136939
263: PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
264: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
265: p_register_type IN VARCHAR2,
266: p_source_register IN VARCHAR2,
267: p_excise_cess_amount IN NUMBER,

Line 264: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

260:
261: /*Bug 4543171 bduvarag end*/
262: --Added by Sanjikum for cess for Bug #4136939
263: PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
264: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
265: p_register_type IN VARCHAR2,
266: p_source_register IN VARCHAR2,
267: p_excise_cess_amount IN NUMBER,
268: p_sh_exc_cess_amount IN NUMBER, /*Bug 5989740 bduvarag*/

Line 392: /*CURSOR cess_balance_cur_pla(c_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

388:
389: );
390:
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

Line 393: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

389: );
390:
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

Line 411: CURSOR cess_balance_cur(c_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

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

Line 412: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%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,
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