DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on GL_INTERFACE

Line 3443: -- This procedure is written that whould pass GL entries for inclusive taxes in GL interface

3439: -- acct_inclu_taxes Public
3440: --
3441: -- DESCRIPTION:
3442: --
3443: -- This procedure is written that whould pass GL entries for inclusive taxes in GL interface
3444: --
3445: -- PARAMETERS:
3446: -- In: pn_customer_trx_id Indicates the customer trx id
3447: -- pn_org_id Indicates the transaction org id

Line 3587: -- Insert receivable inclusive taxes into GL Interface table

3583: xv_process_message := Sqlerrm||'. Get gl date in acct_inclu_taxes procedure.';
3584: RAISE exception_error;
3585: END;
3586:
3587: -- Insert receivable inclusive taxes into GL Interface table
3588: ln_total_inclu_tax_amt := 0;
3589:
3590: FOR inclu_tax_csr IN inclu_tax
3591: LOOP

Line 3597: INSERT INTO gl_interface

3593: ( pn_tax_id => inclu_tax_csr.tax_id
3594: , pv_tax_type => inclu_tax_csr.tax_type
3595: , pn_org_id => ln_org_id
3596: );
3597: INSERT INTO gl_interface
3598: ( status
3599: , set_of_books_id
3600: , user_je_source_name
3601: , user_je_category_name

Line 3643: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string

3639: , ln_cur_conversion_rate
3640: , lv_inv_org_code -- inventory organization code
3641: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
3642: , 'India Localization Entry' -- hard code string
3643: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
3644: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
3645: , 'CUSTOMER_TRX_ID' -- hard code string
3646: , pn_customer_trx_id -- value of customer_trx_id
3647: , ln_inv_org_id -- organization id of the inventory organization id

Line 3658: -- Insert receivable amount into GL Interface table

3654: || ' tax_amount = '|| inclu_tax_csr.tax_amount
3655: );
3656: END LOOP; -- inclu_tax cusor
3657:
3658: -- Insert receivable amount into GL Interface table
3659: INSERT INTO gl_interface
3660: ( status
3661: , set_of_books_id
3662: , user_je_source_name

Line 3659: INSERT INTO gl_interface

3655: );
3656: END LOOP; -- inclu_tax cusor
3657:
3658: -- Insert receivable amount into GL Interface table
3659: INSERT INTO gl_interface
3660: ( status
3661: , set_of_books_id
3662: , user_je_source_name
3663: , user_je_category_name

Line 3705: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string

3701: , ln_cur_conversion_rate
3702: , lv_inv_org_code -- inventory organization code
3703: , 'India Localization Entry for accounting inclusive taxes for invoice'||lv_inv_num
3704: , 'India Localization Entry' -- hard code string
3705: , 'acct_inclu_taxes' -- procedure name that makes the insert into gl_interface hard code string
3706: , 'RA_CUSTOMER_TRX_ALL' -- hard code string
3707: , 'CUSTOMER_TRX_ID' -- hard code string
3708: , pn_customer_trx_id -- value of customer_trx_id
3709: , ln_inv_org_id -- organization id of the inventory organization id

Line 3719: xv_process_message := 'Inclusive taxes have successed into GL Interface';

3715: || ' amount = '|| ln_total_inclu_tax_amt
3716: );
3717:
3718: xv_process_flag := 'SS';
3719: xv_process_message := 'Inclusive taxes have successed into GL Interface';
3720:
3721: --logging for debug
3722: IF (ln_proc_level >= ln_dbg_level)
3723: THEN