DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on STANDARD

Line 3231: -- standard AP invoice workbench.it invokes the procedure create_tax_line

3227: --
3228: -- DESCRIPTION:
3229: --
3230: -- This procedure is main entrance procedure used by form JAINAPST and
3231: -- standard AP invoice workbench.it invokes the procedure create_tax_line
3232: -- to populate the tax lines
3233: --
3234: -- PARAMETERS:
3235: -- In: pn_invoice_id number

Line 3519: --specified. in the standard AP invoice form only line amount is changed

3515: --insert into eric_log values ( 1.1,'Item_Dist_Lines_Validated',sysdate);
3516:
3517: --only the tax_category_id in the cursor can be modified in the IL form
3518: --if the current function is invoked by IL form, line_number will be
3519: --specified. in the standard AP invoice form only line amount is changed
3520: --in the line level while vndr_site_id or currency_code are in header level
3521: --we need fetch one line rather than loop every item lines here
3522:
3523: OPEN jai_invoice_exist_cur;

Line 3847: -- 1. When the line amount is changed in the standard form

3843: , pv_tax_modified => lv_std_tax_modified
3844: );
3845: END IF; --( (lv_std_tax_modified, 'N') = 'Y',Modified Tax line in IL form)
3846:
3847: -- 1. When the line amount is changed in the standard form
3848: -- program going to this branch
3849: -- 2. A new item line inserted from standard AP form
3850:
3851: -- For the first case, program need to update the item line amount in

Line 3849: -- 2. A new item line inserted from standard AP form

3845: END IF; --( (lv_std_tax_modified, 'N') = 'Y',Modified Tax line in IL form)
3846:
3847: -- 1. When the line amount is changed in the standard form
3848: -- program going to this branch
3849: -- 2. A new item line inserted from standard AP form
3850:
3851: -- For the first case, program need to update the item line amount in
3852: -- jai_ap_invoice_lines
3853: --get invoice header information

Line 3948: --delete item lines from Standard Invoice Work Bench

3944: );
3945: end if; /* Commented above end if and added here for bug 14650698 */
3946: END LOOP; --(diff_inv_lines_rec IN diff_inv_lines_cur)
3947:
3948: --delete item lines from Standard Invoice Work Bench
3949: --then delete its related taxes invoice lines and tax dist lines
3950: Delete_Useless_Lines ( pn_invoice_id => ln_std_invoice_id );
3951:
3952: --allocate tax amount in distribution lines according to the propotion

Line 4053: -- This procedure is to invoke standard procedure to insert item information

4049: -- Default_Calculate_Taxes Public
4050: --
4051: -- DESCRIPTION:
4052: --
4053: -- This procedure is to invoke standard procedure to insert item information
4054: -- into jai_cmn_document_taxes
4055: --
4056: -- PARAMETERS:
4057: -- In: pn_invoice_id IN NUMBER invoice id

Line 4381: -- both standard tables of ap module and jai ap modules

4377: --
4378: -- DESCRIPTION:
4379: --
4380: -- This procedure is to create tax invoice line and distribution line in
4381: -- both standard tables of ap module and jai ap modules
4382: --
4383: -- This procedures will fetch all the related information which we need to
4384: -- populate the base tables and IlL tables. Maintly to get the project
4385: -- realted information for the Project invoices, asset related info for

Line 5271: --If the program invoked from Standard AP invoice workbench,

5267:
5268: --When updating tax category from IL form,set the tax_category_id
5269: --as the input parementer
5270:
5271: --If the program invoked from Standard AP invoice workbench,
5272: --Get the tax_category_id from configration of vendor-vndr site combination
5273: IF ( pn_tax_category_id is null
5274: AND pn_line_number is null ) --invoked form standard ap form
5275: THEN

Line 5274: AND pn_line_number is null ) --invoked form standard ap form

5270:
5271: --If the program invoked from Standard AP invoice workbench,
5272: --Get the tax_category_id from configration of vendor-vndr site combination
5273: IF ( pn_tax_category_id is null
5274: AND pn_line_number is null ) --invoked form standard ap form
5275: THEN
5276: Get_Tax_Cat_Serv_Type ( pn_vendor_id => ln_vendor_id
5277: , pn_vendor_site_id => ln_vendor_site_id
5278: , xn_tax_category_id => ln_tax_category_id

Line 5737: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables

5733: --insert into eric_log values (7.802,'jai_doc_taxes_rec.tax_id = '|| jai_doc_taxes_rec.tax_id,sysdate);
5734:
5735: /*Removed this IF from here by Jia Li for inclusive tax on 2008/01/23
5736: --added by eric for inclusive tax
5737: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables
5738: ----------------------------------------------------------
5739: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N')
5740: THEN
5741: ----------------------------------------------------------

Line 5818: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables

5814: END IF; --(lv_tax_type = 'NR')
5815:
5816: --Moved IF to here by Jia Li for inclusive tax on 2008/01/23
5817: --added by eric for inclusive tax
5818: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables
5819: ----------------------------------------------------------
5820: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N')
5821: THEN
5822: ----------------------------------------------------------