APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 258: from JAI_CMN_INVENTORY_ORGS

254:
255: /*Bug 5989740 bduvarag end*/
256: cursor c_fetch_cess_account(cp_organization_id number , cp_location_id number) is
257: select cess_paid_payable_account_id
258: from JAI_CMN_INVENTORY_ORGS
259: where organization_id = cp_organization_id
260: and location_id = cp_location_id;
261: /*Bug 5989740 bduvarag start*/
262: cursor c_fetch_sh_cess_account(cp_organization_id number , cp_location_id number) is

Line 264: from JAI_CMN_INVENTORY_ORGS

260: and location_id = cp_location_id;
261: /*Bug 5989740 bduvarag start*/
262: cursor c_fetch_sh_cess_account(cp_organization_id number , cp_location_id number) is
263: select sh_cess_paid_payable_acct_id
264: from JAI_CMN_INVENTORY_ORGS
265: where organization_id = cp_organization_id
266: and location_id = cp_location_id;
267: /*Bug 5989740 bduvarag end*/
268:

Line 281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;

277: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
278: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
279: v_cess_amount number;
280: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
282: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
283: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
284: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
285:

Line 283: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/

279: v_cess_amount number;
280: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
282: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
283: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
284: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
285:
286: /*
287: The procedure assumes that it will be called from the ja_in_accounting_entries procedure only when

Line 870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,

866: /**********************************************************************************************************************/
867: procedure ja_in_cess_register_entries(
868: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
869: p_register_type varchar2 ,
870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
873: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
874: p_currency_code gl_interface.currency_code%type ,

Line 1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1146: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1155: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1156:

Line 1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1155: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1156:
1157:

Line 1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1155: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1156:
1157:
1158: -- get the delivery details

Line 1186: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

1182: FROM mtl_interorg_parameters
1183: WHERE from_organization_id = p_from_org_id
1184: AND to_organization_id = p_to_org_id;
1185:
1186: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
1187: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
1188: ) IS
1189: SELECT excise_rcvble_account ,
1190: excise_23d_account,

Line 1187: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE

1183: WHERE from_organization_id = p_from_org_id
1184: AND to_organization_id = p_to_org_id;
1185:
1186: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
1187: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
1188: ) IS
1189: SELECT excise_rcvble_account ,
1190: excise_23d_account,
1191: excise_in_rg23d,

Line 1194: FROM JAI_CMN_INVENTORY_ORGS

1190: excise_23d_account,
1191: excise_in_rg23d,
1192: Trading,
1193: Manufacturing
1194: FROM JAI_CMN_INVENTORY_ORGS
1195: WHERE organization_id = cp_organization_id
1196: AND location_id = cp_location_id;
1197:
1198:

Line 1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

1219: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1220: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1221: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

1220: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1221: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

1221: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1229: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1229: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1230: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1229: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1230: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1231: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

Line 1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1227: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1228: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1229: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1230: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1231: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1232: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;

Line 2461: FROM JAI_CMN_INVENTORY_ORGS

2457: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2458: WHERE A.site_use_id = p_customer_site_id);
2459: CURSOR rm_account_cur IS
2460: SELECT modvat_rm_account_id , excise_edu_cess_rm_account ,SH_CESS_RM_ACCOUNT/*Bug 5989740 bduvarag*/
2461: FROM JAI_CMN_INVENTORY_ORGS
2462: WHERE organization_id = p_org_id AND location_id = p_location_id;
2463:
2464: CURSOR cg_account_cur IS
2465: SELECT modvat_cg_account_id , excise_edu_cess_cg_account ,SH_CESS_CG_ACCOUNT_ID/*Bug 5989740 bduvarag*/

Line 2466: FROM JAI_CMN_INVENTORY_ORGS

2462: WHERE organization_id = p_org_id AND location_id = p_location_id;
2463:
2464: CURSOR cg_account_cur IS
2465: SELECT modvat_cg_account_id , excise_edu_cess_cg_account ,SH_CESS_CG_ACCOUNT_ID/*Bug 5989740 bduvarag*/
2466: FROM JAI_CMN_INVENTORY_ORGS
2467: WHERE organization_id = p_org_id AND location_id = p_location_id;
2468:
2469: CURSOR debit_account_cur IS
2470: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID , /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */

Line 2472: FROM JAI_CMN_INVENTORY_ORGS

2468:
2469: CURSOR debit_account_cur IS
2470: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID , /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */
2471: SH_CESS_PAID_PAYABLE_ACCT_ID/*Bug 5989740 bduvarag*/
2472: FROM JAI_CMN_INVENTORY_ORGS
2473: WHERE organization_id = p_org_id AND location_id = p_location_id;
2474:
2475: CURSOR mod_debit_acc_org IS
2476: SELECT MODVAT_REVERSE_ACCOUNT_ID

Line 2477: FROM JAI_CMN_INVENTORY_ORGS

2473: WHERE organization_id = p_org_id AND location_id = p_location_id;
2474:
2475: CURSOR mod_debit_acc_org IS
2476: SELECT MODVAT_REVERSE_ACCOUNT_ID
2477: FROM JAI_CMN_INVENTORY_ORGS
2478: WHERE organization_id = p_org_id
2479: AND location_id = p_location_id;
2480:
2481: /* Bug 4931887. Added by Lakshmi Gopalsami

Line 2490: FROM JAI_CMN_INVENTORY_ORGS

2486:
2487:
2488: CURSOR ssi_unit_flag_cur IS
2489: SELECT ssi_unit_flag
2490: FROM JAI_CMN_INVENTORY_ORGS
2491: WHERE organization_id = p_org_id AND
2492: location_id = p_location_id;
2493:
2494: ln_register_id number;

Line 2836: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;

2832: v_additional_opening_balance NUMBER;
2833: v_additional_closing_balance NUMBER;
2834: v_other_opening_balance NUMBER;
2835: v_other_closing_balance NUMBER;
2836: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
2837: v_rg_basic_balance NUMBER;
2838: v_rg_additional_balance NUMBER;
2839: v_rg_other_balance NUMBER;
2840: v_order_type_id JAI_OM_WSH_LINES_ALL.order_type_id%TYPE;

Line 2883: FROM JAI_CMN_INVENTORY_ORGS

2879:
2880: --Changed by Nagaraj.s for Enh2415656...
2881: CURSOR pla_account_cur IS
2882: SELECT MODVAT_PLA_ACCOUNT_ID,NVL(export_oriented_unit,'N')
2883: FROM JAI_CMN_INVENTORY_ORGS
2884: WHERE organization_id = p_org_id
2885: AND location_id = p_location_id;
2886:
2887: CURSOR debit_account_cur IS

Line 2890: FROM JAI_CMN_INVENTORY_ORGS

2886:
2887: CURSOR debit_account_cur IS
2888: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID, /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */
2889: SH_CESS_PAID_PAYABLE_ACCT_ID/*Bug 5989740 bduvarag*/
2890: FROM JAI_CMN_INVENTORY_ORGS
2891: WHERE organization_id = p_org_id AND location_id = p_location_id;
2892:
2893: /* Bug 4931887. Added by Lakshmi Gopalsami
2894: Removed the references to currency_cur

Line 2901: FROM JAI_CMN_INVENTORY_ORGS

2897: */
2898:
2899: CURSOR ssi_unit_flag_cur IS
2900: SELECT NVL(ssi_unit_flag, 'N')
2901: FROM JAI_CMN_INVENTORY_ORGS
2902: WHERE organization_id = p_org_id AND
2903: location_id = p_location_id;
2904:
2905: --Cursors Added by Nagaraj.s for ENH2415656..

Line 3471: FROM JAI_CMN_INVENTORY_ORGS

3467: -- End, Vijay Shankar for Bug# 3657742
3468: /*
3469: CURSOR rg23d_Account IS
3470: SELECT EXCISE_23D_ACCOUNT
3471: FROM JAI_CMN_INVENTORY_ORGS
3472: WHERE organization_id = p_org_id AND location_id = p_location_id;
3473:
3474: CURSOR debit_account_cur IS
3475: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID

Line 3476: FROM JAI_CMN_INVENTORY_ORGS

3472: WHERE organization_id = p_org_id AND location_id = p_location_id;
3473:
3474: CURSOR debit_account_cur IS
3475: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID
3476: FROM JAI_CMN_INVENTORY_ORGS
3477: WHERE organization_id = p_org_id AND location_id = p_location_id;
3478: */
3479: /* Bug 4931887. Added by Lakshmi Gopalsami
3480: Removed the references to currency_cur

Line 3516: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

3512: FROM mtl_interorg_parameters
3513: WHERE from_organization_id = p_from_org_id
3514: AND to_organization_id = p_to_org_id;
3515:
3516: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
3517: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3518: ) IS
3519: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3520: FROM JAI_CMN_INVENTORY_ORGS

Line 3517: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE

3513: WHERE from_organization_id = p_from_org_id
3514: AND to_organization_id = p_to_org_id;
3515:
3516: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
3517: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3518: ) IS
3519: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3520: FROM JAI_CMN_INVENTORY_ORGS
3521: WHERE organization_id = cp_organization_id

Line 3520: FROM JAI_CMN_INVENTORY_ORGS

3516: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
3517: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3518: ) IS
3519: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3520: FROM JAI_CMN_INVENTORY_ORGS
3521: WHERE organization_id = cp_organization_id
3522: AND location_id = cp_location_id;
3523:
3524:

Line 3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

3546: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3547: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3548: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

3547: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3548: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

3548: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3556: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3556: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3557: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3556: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3557: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3558: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

Line 3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3554: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3555: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3556: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3557: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3558: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3559: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/

Line 3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3568: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3577:
3578: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';

Line 3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3577:
3578: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';
3579:

Line 3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3577:
3578: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';
3579:
3580: