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 61: CURSOR c_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,

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

Line 62: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

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

Line 68: JAI_CMN_INVENTORY_ORGS b

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

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

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

Line 77: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

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

Line 83: JAI_CMN_INVENTORY_ORGS b

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

Line 205: FROM JAI_CMN_INVENTORY_ORGS

201: CURSOR rg23a_account_cur( p_orgid IN Number,
202: p_locid IN Number
203: )IS
204: SELECT MODVAT_RM_ACCOUNT_ID
205: FROM JAI_CMN_INVENTORY_ORGS
206: WHERE organization_id = p_orgid
207: AND location_id = p_locid;
208:
209: CURSOR rg23c_account_cur( p_orgid IN Number,

Line 213: FROM JAI_CMN_INVENTORY_ORGS

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

Line 221: FROM JAI_CMN_INVENTORY_ORGS

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

Line 239: JAI_CMN_INVENTORY_ORGS

235: 'C', SH_CESS_CG_ACCOUNT_ID
236: ) sh_cess_account_id
237:
238: FROM
239: JAI_CMN_INVENTORY_ORGS
240: WHERE organization_id = p_orgid
241: AND location_id = p_locid;
242:
243: lv_currency varchar2(10) ;

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

251: lv_to_account_id number ;
252:
253: /*Bug 4543171 bduvarag end*/
254: --Added by Sanjikum for cess for Bug #4136939
255: PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
256: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
257: p_register_type IN VARCHAR2,
258: p_source_register IN VARCHAR2,
259: p_excise_cess_amount IN NUMBER,

Line 256: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

252:
253: /*Bug 4543171 bduvarag end*/
254: --Added by Sanjikum for cess for Bug #4136939
255: PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
256: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
257: p_register_type IN VARCHAR2,
258: p_source_register IN VARCHAR2,
259: p_excise_cess_amount IN NUMBER,
260: p_sh_exc_cess_amount IN NUMBER, /*Bug 5989740 bduvarag*/

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

380:
381: );
382:
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

Line 385: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

381: );
382:
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

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

399: AND c.tax_type = c_tax_type
400: AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
401: AND c.source_register = c_source_register);
402:
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

Line 404: c_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

400: AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
401: AND c.source_register = c_source_register);
402:
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