APPS.JAI_PA_TAX_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 1044: from jai_cmn_document_taxes

1040: ----------------------------------------------------------------
1041: -- responsible to check for tax category id whether it is already exists .
1042: cursor cur_get_tax_caegotry is
1043: select tax_category_id
1044: from jai_cmn_document_taxes
1045: where source_doc_id = pn_draft_invoice_id and
1046: source_doc_line_id = pn_draft_invoice_line_id and
1047: source_doc_type = jai_constants.pa_draft_invoice ;
1048:

Line 1059: from jai_cmn_document_taxes

1055: draft_invoice_id = pn_draft_invoice_id ;
1056:
1057: cursor cur_get_tax_amount is
1058: select sum(tax_amt)
1059: from jai_cmn_document_taxes
1060: where source_doc_id = pn_draft_invoice_id and
1061: source_doc_line_id = pn_draft_invoice_line_id and
1062: source_doc_type = jai_constants.pa_draft_invoice ;
1063: -- for credit invoice generation

Line 1068: insert into jai_cmn_document_taxes

1064: begin
1065: ln_tax_amount := 0 ;
1066: -- for credit invoice generation , tax category should be copy from parent to credit memo
1067: if pkg_global_type.ln_draft_invoice_num_credited is not null then
1068: insert into jai_cmn_document_taxes
1069: (
1070: doc_tax_id ,
1071: tax_line_no ,
1072: tax_id ,

Line 1104: select jai_cmn_document_taxes_s.nextval ,

1100: last_update_date ,
1101: last_updated_by ,
1102: last_update_login
1103: )
1104: select jai_cmn_document_taxes_s.nextval ,
1105: j1.tax_line_no ,
1106: j1.tax_id ,
1107: j1.tax_type ,
1108: j1.currency_code ,

Line 1135: from jai_cmn_document_taxes j1 , JAI_CMN_TAXES_ALL j2

1131: fnd_global.user_id ,
1132: sysdate ,
1133: fnd_global.user_id ,
1134: fnd_global.login_id
1135: from jai_cmn_document_taxes j1 , JAI_CMN_TAXES_ALL j2
1136: where j1.source_doc_id = pkg_global_type.ln_draft_invoice_id and
1137: j1.source_doc_line_id = pkg_global_type.ln_draft_invoice_line_id and
1138: j1.source_doc_type = jai_constants.pa_draft_invoice and
1139: j1.tax_id = j2.tax_id ;

Line 1175: delete from jai_cmn_document_taxes

1171: close cur_get_tax_caegotry ;
1172:
1173: --if tax category id is present and it is different then delete from taxes table
1174: if ln_tax_category_id is not null and ln_tax_category_id <> pn_tax_category_id then
1175: delete from jai_cmn_document_taxes
1176: where source_doc_id = pn_draft_invoice_id and
1177: source_doc_line_id = pn_draft_invoice_line_id and
1178: source_doc_type = jai_constants.pa_draft_invoice ;
1179: end if ;

Line 1257: delete from jai_cmn_document_taxes

1253: pv_process_message out nocopy varchar2,
1254: pv_process_flag out nocopy varchar2
1255: ) is
1256: begin
1257: delete from jai_cmn_document_taxes
1258: where ( source_doc_id , source_doc_line_id ) in
1259: ( select draft_invoice_id , draft_invoice_line_id
1260: from jai_pa_draft_invoice_lines
1261: where project_id = pn_project_id and