DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on STANDARD

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

2750: --
2751: -- DESCRIPTION:
2752: --
2753: -- This procedure is main entrance procedure used by form JAINAPST and
2754: -- standard AP invoice workbench.it invokes the procedure create_tax_line
2755: -- to populate the tax lines
2756: --
2757: -- PARAMETERS:
2758: -- In: pn_invoice_id number

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

2946: --insert into eric_log values ( 1.1,'Item_Dist_Lines_Validated',sysdate);
2947:
2948: --only the tax_category_id in the cursor can be modified in the IL form
2949: --if the current function is invoked by IL form, line_number will be
2950: --specified. in the standard AP invoice form only line amount is changed
2951: --in the line level while vndr_site_id or currency_code are in header level
2952: --we need fetch one line rather than loop every item lines here
2953:
2954: OPEN jai_invoice_exist_cur;

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

3274: , pv_tax_modified => lv_std_tax_modified
3275: );
3276: END IF; --( (lv_std_tax_modified, 'N') = 'Y',Modified Tax line in IL form)
3277:
3278: -- 1. When the line amount is changed in the standard form
3279: -- program going to this branch
3280: -- 2. A new item line inserted from standard AP form
3281:
3282: -- For the first case, program need to update the item line amount in

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

3276: END IF; --( (lv_std_tax_modified, 'N') = 'Y',Modified Tax line in IL form)
3277:
3278: -- 1. When the line amount is changed in the standard form
3279: -- program going to this branch
3280: -- 2. A new item line inserted from standard AP form
3281:
3282: -- For the first case, program need to update the item line amount in
3283: -- jai_ap_invoice_lines
3284: --get invoice header information

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

3338: , pv_tax_modified => lv_std_tax_modified
3339: );
3340: END LOOP; --(diff_inv_lines_rec IN diff_inv_lines_cur)
3341:
3342: --delete item lines from Standard Invoice Work Bench
3343: --then delete its related taxes invoice lines and tax dist lines
3344: Delete_Useless_Lines ( pn_invoice_id => ln_std_invoice_id );
3345:
3346: --allocate tax amount in distribution lines according to the propotion

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

3395: -- Default_Calculate_Taxes Public
3396: --
3397: -- DESCRIPTION:
3398: --
3399: -- This procedure is to invoke standard procedure to insert item information
3400: -- into jai_cmn_document_taxes
3401: --
3402: -- PARAMETERS:
3403: -- In: pn_invoice_id IN NUMBER invoice id

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

3722: --
3723: -- DESCRIPTION:
3724: --
3725: -- This procedure is to create tax invoice line and distribution line in
3726: -- both standard tables of ap module and jai ap modules
3727: --
3728: -- This procedures will fetch all the related information which we need to
3729: -- populate the base tables and IlL tables. Maintly to get the project
3730: -- realted information for the Project invoices, asset related info for

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

4429:
4430: --When updating tax category from IL form,set the tax_category_id
4431: --as the input parementer
4432:
4433: --If the program invoked from Standard AP invoice workbench,
4434: --Get the tax_category_id from configration of vendor-vndr site combination
4435: IF ( pn_tax_category_id is null
4436: AND pn_line_number is null ) --invoked form standard ap form
4437: THEN

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

4432:
4433: --If the program invoked from Standard AP invoice workbench,
4434: --Get the tax_category_id from configration of vendor-vndr site combination
4435: IF ( pn_tax_category_id is null
4436: AND pn_line_number is null ) --invoked form standard ap form
4437: THEN
4438: Get_Tax_Cat_Serv_Type ( pn_vendor_id => ln_vendor_id
4439: , pn_vendor_site_id => ln_vendor_site_id
4440: , xn_tax_category_id => ln_tax_category_id

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

4827: --insert into eric_log values (7.802,'jai_doc_taxes_rec.tax_id = '|| jai_doc_taxes_rec.tax_id,sysdate);
4828:
4829: /*Removed this IF from here by Jia Li for inclusive tax on 2008/01/23
4830: --added by eric for inclusive tax
4831: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables
4832: ----------------------------------------------------------
4833: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N')
4834: THEN
4835: ----------------------------------------------------------

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

4900: END IF; --(lv_tax_type = 'NR')
4901:
4902: --Moved IF to here by Jia Li for inclusive tax on 2008/01/23
4903: --added by eric for inclusive tax
4904: --insert exclusive tax into jai_ap_invoice_lines and standard ap tables
4905: ----------------------------------------------------------
4906: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N')
4907: THEN
4908: ----------------------------------------------------------