DBA Data[Home] [Help]

APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_OTHERS

Line 678: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,

674: /********************************************************************************************************************** */
675:
676: /************************************START JA_IN_OM_CESS_REGISTER_ENTRIES***********************************************/
677: procedure ja_in_om_cess_register_entries(p_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
678: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
681: p_register_type VARCHAR2 ,
682: p_cess_amount OUT NOCOPY NUMBER ,

Line 679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,

675:
676: /************************************START JA_IN_OM_CESS_REGISTER_ENTRIES***********************************************/
677: procedure ja_in_om_cess_register_entries(p_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
678: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
681: p_register_type VARCHAR2 ,
682: p_cess_amount OUT NOCOPY NUMBER ,
683: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added, Bug 4724137

Line 680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,

676: /************************************START JA_IN_OM_CESS_REGISTER_ENTRIES***********************************************/
677: procedure ja_in_om_cess_register_entries(p_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
678: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
679: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
680: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
681: p_register_type VARCHAR2 ,
682: p_cess_amount OUT NOCOPY NUMBER ,
683: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added, Bug 4724137
684: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/

Line 761: jai_cmn_rg_others_pkg.insert_row(

757: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
758:
759: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
760:
761: jai_cmn_rg_others_pkg.insert_row(
762: P_SOURCE_TYPE => p_source_type ,
763: P_SOURCE_NAME => p_source_name ,
764: P_SOURCE_ID => p_source_id ,
765: P_TAX_TYPE => tax_type_rec.tax_type ,

Line 795: jai_cmn_rg_others_pkg.insert_row(

791: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
792:
793: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before calling jai_Rg_others_pkg.insert_row');
794:
795: jai_cmn_rg_others_pkg.insert_row(
796: P_SOURCE_TYPE => p_source_type ,
797: P_SOURCE_NAME => p_source_name ,
798: P_SOURCE_ID => p_source_id ,
799: P_TAX_TYPE => tax_type_rec.tax_type ,

Line 823: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,

819: END ja_in_om_cess_register_entries;
820:
821: /**********************************************************************************************************************/
822: PROCEDURE ja_in_ar_cess_register_entries(p_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ,
823: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
824: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
825: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
826: p_register_type VARCHAR2 ,
827: p_cess_amount OUT NOCOPY NUMBER ,

Line 824: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,

820:
821: /**********************************************************************************************************************/
822: PROCEDURE ja_in_ar_cess_register_entries(p_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ,
823: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
824: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
825: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
826: p_register_type VARCHAR2 ,
827: p_cess_amount OUT NOCOPY NUMBER ,
828: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added for Bug 4724137

Line 825: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,

821: /**********************************************************************************************************************/
822: PROCEDURE ja_in_ar_cess_register_entries(p_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ,
823: p_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ,
824: p_source_name JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ,
825: p_source_id JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
826: p_register_type VARCHAR2 ,
827: p_cess_amount OUT NOCOPY NUMBER ,
828: p_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE DEFAULT NULL, -- added for Bug 4724137
829: p_cess_type VARCHAR2/*Bug 5989740 bduvarag*/

Line 892: jai_cmn_rg_others_pkg.insert_row(

888: For tax_type_rec in c_tax_type_rec
889: Loop
890:
891: ln_Cess_amount := ln_Cess_amount + nvl(tax_type_rec.tax_amount,0);
892: jai_cmn_rg_others_pkg.insert_row(
893: P_SOURCE_TYPE => p_source_type ,
894: P_SOURCE_NAME => p_source_name ,
895: P_SOURCE_ID => p_source_id ,
896: P_TAX_TYPE => tax_type_rec.tax_type ,

Line 919: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,

915: p_register_type varchar2 ,
916: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
917: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
918: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
919: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
920: p_currency_code gl_interface.currency_code%type ,
921: p_transaction_hdr_id Number ,
922: p_debit_account Number ,
923: p_Credit_account Number ,

Line 1277: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1276: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1277: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1278: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
1279:
1280: BEGIN
1281:

Line 2007: This was not necessary , hence call to the procedure JAI_CMN_RG_OTHERS_pkg.insert_row was done only

2003:
2004: 14. 16/02/2005 ssumaith - bug# 4185392 - File Version 115.4
2005:
2006: Even when cess amount is zero , still call to insert row for cess record was being done.
2007: This was not necessary , hence call to the procedure JAI_CMN_RG_OTHERS_pkg.insert_row was done only
2008: if the cess amount is a non zero value.
2009:
2010: Changes are made in the following places
2011:

Line 3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;

Line 3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/

3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/
3859: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;
3860: v_order_header_id WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID%TYPE;
3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;