eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ETAX_UTILITY_PKG dependencies on AP_ETAX_SERVICES_PKG

Line 166: IF (ap_etax_services_pkg.ret_dists.EXISTS(p_invoice_dist)) THEN

162: l_debug_info VARCHAR2(2000);
163: l_api_name CONSTANT VARCHAR2(100) := 'FIND_VAL';
164:
165: BEGIN
166: IF (ap_etax_services_pkg.ret_dists.EXISTS(p_invoice_dist)) THEN
167:
168: ------------------------------------------------------------------
169: l_debug_info := 'Found Collection Populated Returning 0 ';
170: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 972: IF NOT AP_ETAX_SERVICES_PKG.g_fsp_attributes.exists(l_org_id) THEN

968:
969:
970: END IF;
971:
972: IF NOT AP_ETAX_SERVICES_PKG.g_fsp_attributes.exists(l_org_id) THEN
973:
974: SELECT inventory_organization_id
975: INTO AP_ETAX_SERVICES_PKG.g_fsp_attributes(l_org_id).inventory_organization_id
976: FROM financials_system_params_all

Line 975: INTO AP_ETAX_SERVICES_PKG.g_fsp_attributes(l_org_id).inventory_organization_id

971:
972: IF NOT AP_ETAX_SERVICES_PKG.g_fsp_attributes.exists(l_org_id) THEN
973:
974: SELECT inventory_organization_id
975: INTO AP_ETAX_SERVICES_PKG.g_fsp_attributes(l_org_id).inventory_organization_id
976: FROM financials_system_params_all
977: WHERE org_id = l_org_id;
978:
979: END IF;

Line 981: p_product_org_id := AP_ETAX_SERVICES_PKG.g_fsp_attributes(l_org_id).inventory_organization_id;

977: WHERE org_id = l_org_id;
978:
979: END IF;
980:
981: p_product_org_id := AP_ETAX_SERVICES_PKG.g_fsp_attributes(l_org_id).inventory_organization_id;
982:
983: -------------------------------------------------------------------
984: l_debug_info := 'Step 2: Product Org Id '||p_product_org_id;
985: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4131: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN

4127: END IF;
4128:
4129: /*
4130: --bug 10621602 starts
4131: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
4132: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
4133:
4134: IF l_inv_dist_upd(j).line_type_lookup_code = 'NONREC_TAX' THEN
4135:

Line 4132: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN

4128:
4129: /*
4130: --bug 10621602 starts
4131: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
4132: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
4133:
4134: IF l_inv_dist_upd(j).line_type_lookup_code = 'NONREC_TAX' THEN
4135:
4136: l_inv_dist_upd(j).pa_addition_flag := 'N'; --Make the pa_addition flag N for retainage tax distributions.

Line 4285: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN

4281: END IF;
4282:
4283: /*
4284: --bug 10621602 starts
4285: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
4286: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
4287:
4288: l_inv_dist_upd(j).pa_addition_flag := 'N'; --Make the pa_addition flag N for retainage tax distributions.
4289:

Line 4286: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN

4282:
4283: /*
4284: --bug 10621602 starts
4285: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
4286: IF ( AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_upd(j).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
4287:
4288: l_inv_dist_upd(j).pa_addition_flag := 'N'; --Make the pa_addition flag N for retainage tax distributions.
4289:
4290: END IF;

Line 5132: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN

5128: END IF;
5129: -- End Project LCM 7588322
5130:
5131: --bug 10621602 starts
5132: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
5133:
5134: IF (AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_ins(i).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
5135: l_inv_dist_ins(i).pa_addition_flag := 'N'; --Make the pa_addition flag N for retainage tax distributions.
5136: END IF;

Line 5134: IF (AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_ins(i).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN

5130:
5131: --bug 10621602 starts
5132: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(l_inv_dist_ins(i).charge_applicable_to_dist_id) THEN
5133:
5134: IF (AP_ETAX_SERVICES_PKG.ret_dists(l_inv_dist_ins(i).charge_applicable_to_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN
5135: l_inv_dist_ins(i).pa_addition_flag := 'N'; --Make the pa_addition flag N for retainage tax distributions.
5136: END IF;
5137:
5138: END IF;

Line 6084: l_api_name VARCHAR2(100):='AP_ETAX_SERVICES_PKG.Return_Default_Import';

6080: AND ail.invoice_id = ve.trx_id;
6081: --AND ail.line_number = ve.trx_line_id; -- bug6255826
6082:
6083: -- Bug 6665695
6084: l_api_name VARCHAR2(100):='AP_ETAX_SERVICES_PKG.Return_Default_Import';
6085:
6086: BEGIN
6087: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Return_Default_Import<-' ||
6088: P_calling_sequence;

Line 6087: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Return_Default_Import<-' ||

6083: -- Bug 6665695
6084: l_api_name VARCHAR2(100):='AP_ETAX_SERVICES_PKG.Return_Default_Import';
6085:
6086: BEGIN
6087: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Return_Default_Import<-' ||
6088: P_calling_sequence;
6089: -----------------------------------------------------------------
6090: l_debug_info := 'Step 1: Get rejections from zx_trans_lines_val_errs'||
6091: ' table';

Line 7325: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN

7321:
7322: --bug 10621602 starts
7323: -- The below formula is only for the distribution related to retainage and retainge release invoice
7324:
7325: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7326:
7327: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7328:
7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

Line 7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

7325: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7326:
7327: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7328:
7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7330: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7331: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7332: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7333:

Line 7330: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||

7326:
7327: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7328:
7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7330: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7331: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7332: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7333:
7334: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7331: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||

7327: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7328:
7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7330: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7331: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7332: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7333:
7334: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7335:

Line 7332: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;

7328:
7329: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7330: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7331: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7332: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7333:
7334: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7335:
7336: END IF;

Line 7339: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage

7335:
7336: END IF;
7337:
7338:
7339: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7340:
7341: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7342: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7343:

Line 7341: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -

7337:
7338:
7339: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7340:
7341: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7342: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7343:
7344:
7345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7342: (p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec;

7338:
7339: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7340:
7341: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7342: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7343:
7344:
7345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7346:

Line 7347: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||

7343:
7344:
7345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7346:
7347: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7348: '(p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7349: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7350: ' ( ' || p_rate_tax_factor || ' * ' || p_ref_doc_unit_price || ' * (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' || p_ref_per_trx_cur_unit_nrec ;
7351:

Line 7348: '(p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec ' ||

7344:
7345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7346:
7347: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7348: '(p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7349: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7350: ' ( ' || p_rate_tax_factor || ' * ' || p_ref_doc_unit_price || ' * (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' || p_ref_per_trx_cur_unit_nrec ;
7351:
7352: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7349: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||

7345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7346:
7347: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7348: '(p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7349: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7350: ' ( ' || p_rate_tax_factor || ' * ' || p_ref_doc_unit_price || ' * (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' || p_ref_per_trx_cur_unit_nrec ;
7351:
7352: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7353:

Line 7350: ' ( ' || p_rate_tax_factor || ' * ' || p_ref_doc_unit_price || ' * (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' || p_ref_per_trx_cur_unit_nrec ;

7346:
7347: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7348: '(p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7349: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7350: ' ( ' || p_rate_tax_factor || ' * ' || p_ref_doc_unit_price || ' * (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' || p_ref_per_trx_cur_unit_nrec ;
7351:
7352: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7353:
7354: END IF;

Line 7366: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice

7362: END IF;
7363:
7364: END IF;
7365:
7366: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7367:
7368: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7369: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7370:

Line 7368: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -

7364: END IF;
7365:
7366: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7367:
7368: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7369: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7370:
7371:
7372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7369: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec;

7365:
7366: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7367:
7368: p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) -
7369: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec;
7370:
7371:
7372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7373:

Line 7374: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||

7370:
7371:
7372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7373:
7374: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7375: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7376: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )- ' ||
7377: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || '/100)))* '|| p_ref_per_trx_cur_unit_nrec ;
7378:

Line 7375: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec ' ||

7371:
7372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7373:
7374: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7375: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7376: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )- ' ||
7377: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || '/100)))* '|| p_ref_per_trx_cur_unit_nrec ;
7378:
7379: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7376: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )- ' ||

7372: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7373:
7374: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7375: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7376: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )- ' ||
7377: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || '/100)))* '|| p_ref_per_trx_cur_unit_nrec ;
7378:
7379: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7380:

Line 7377: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || '/100)))* '|| p_ref_per_trx_cur_unit_nrec ;

7373:
7374: l_debug_info := ' p_tax_ipv := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount) - ' ||
7375: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec ' ||
7376: p_rate_tax_factor || ' *(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )- ' ||
7377: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || '/100)))* '|| p_ref_per_trx_cur_unit_nrec ;
7378:
7379: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7380:
7381: END IF;

Line 7563: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN

7559:
7560: --bug10621602 starts
7561: -- The below formula is only for the distribution related to retainage and retainge release invoice
7562:
7563: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7564:
7565: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7566:
7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

Line 7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

7563: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7564:
7565: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7566:
7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7568: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7569: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7570: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7571:

Line 7568: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||

7564:
7565: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7566:
7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7568: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7569: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7570: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7571:
7572: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7569: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||

7565: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7566:
7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7568: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7569: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7570: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7571:
7572: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7573:

Line 7570: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;

7566:
7567: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7568: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7569: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7570: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7571:
7572: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7573:
7574: END IF;

Line 7577: IF (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage

7573:
7574: END IF;
7575:
7576:
7577: IF (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7578:
7579: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7580: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7581:

Line 7579: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -

7575:
7576:
7577: IF (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7578:
7579: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7580: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7581:
7582:
7583: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7580: (p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);

7576:
7577: IF (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7578:
7579: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7580: (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7581:
7582:
7583: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7584:

Line 7585: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||

7581:
7582:
7583: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7584:
7585: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7586: ' (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1) ' ||
7587: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7588: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7589: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;

Line 7586: ' (p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1) ' ||

7582:
7583: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7584:
7585: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7586: ' (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1) ' ||
7587: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7588: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7589: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7590:

Line 7587: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||

7583: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7584:
7585: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7586: ' (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1) ' ||
7587: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7588: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7589: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7590:
7591: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7588: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) ' ||

7584:
7585: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7586: ' (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1) ' ||
7587: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7588: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7589: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7590:
7591: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7592:

Line 7606: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice

7602:
7603:
7604: END IF;
7605:
7606: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7607:
7608: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7609: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7610:

Line 7608: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -

7604: END IF;
7605:
7606: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7607:
7608: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7609: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7610:
7611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7612:

Line 7609: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);

7605:
7606: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7607:
7608: p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) -
7609: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7610:
7611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7612:
7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||

Line 7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||

7609: (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1);
7610:
7611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7612:
7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7614: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1)'||
7615: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7616: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7617: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;

Line 7614: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))) p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1)'||

7610:
7611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7612:
7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7614: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1)'||
7615: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7616: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7617: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7618:

Line 7615: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||

7611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7612:
7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7614: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1)'||
7615: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7616: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7617: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7618:
7619: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7616: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) ' ||

7612:
7613: l_debug_info := ' p_tax_ipv_base := p_rate_tax_factor* ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ) - ' ||
7614: ' (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)))* p_ref_per_trx_cur_unit_nrec * nvl(p_inv_currency_rate , 1)'||
7615: p_rate_tax_factor || ' * (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' ) - ' ||
7616: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))) * ' ||
7617: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_currency_rate , 1) ;
7618:
7619: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7620:

Line 7857: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN

7853:
7854: --bug 10621602 starts
7855: -- The below formula is only for the distribution related to retainage and retainge release invoice
7856:
7857: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7858:
7859: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7860:
7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

Line 7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

7857: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
7858:
7859: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7860:
7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7862: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7863: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7864: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7865:

Line 7862: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||

7858:
7859: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7860:
7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7862: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7863: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7864: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7865:
7866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7863: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||

7859: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7860:
7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7862: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7863: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7864: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7865:
7866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7867:

Line 7864: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;

7860:
7861: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
7862: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
7863: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
7864: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
7865:
7866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7867:
7868: END IF;

Line 7871: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage

7867:
7868: END IF;
7869:
7870:
7871: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7872:
7873: p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;
7874:
7875: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7873: p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)) p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;

7869:
7870:
7871: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
7872:
7873: p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;
7874:
7875: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7876:
7877: l_debug_info := ' p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||

Line 7877: l_debug_info := ' p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)) p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||

7873: p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;
7874:
7875: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7876:
7877: l_debug_info := ' p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||
7878: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' * ( ' || p_inv_curr_conv_rate ||
7879: ' - ' || p_ref_doc_curr_conv_rate || ' ) ' ;
7880:
7881: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 7878: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100)) ' || p_ref_per_trx_cur_unit_nrec || ' * ( ' || p_inv_curr_conv_rate ||

7874:
7875: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7876:
7877: l_debug_info := ' p_tax_erv := (p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||
7878: ' ( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' * ( ' || p_inv_curr_conv_rate ||
7879: ' - ' || p_ref_doc_curr_conv_rate || ' ) ' ;
7880:
7881: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7882:

Line 7895: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice

7891: END IF;
7892:
7893: END IF;
7894:
7895: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7896:
7897: p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec
7898: *( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;
7899:

Line 7897: p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)) p_ref_per_trx_cur_unit_nrec

7893: END IF;
7894:
7895: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
7896:
7897: p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec
7898: *( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ;
7899:
7900:
7901: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7903: l_debug_info := ' p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)) p_ref_per_trx_cur_unit_nrec ' ||

7899:
7900:
7901: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7902:
7903: l_debug_info := ' p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec ' ||
7904: ' * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||
7905: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
7906: p_ref_per_trx_cur_unit_nrec || ' * ( ' || p_inv_curr_conv_rate || ' - ' || p_ref_doc_curr_conv_rate || ' ) ';
7907:

Line 7905: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||

7901: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7902:
7903: l_debug_info := ' p_tax_erv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*(AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))* p_ref_per_trx_cur_unit_nrec ' ||
7904: ' * ( p_inv_curr_conv_rate - p_ref_doc_curr_conv_rate) ' ||
7905: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
7906: p_ref_per_trx_cur_unit_nrec || ' * ( ' || p_inv_curr_conv_rate || ' - ' || p_ref_doc_curr_conv_rate || ' ) ';
7907:
7908: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
7909:

Line 8077: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN

8073:
8074: --bug 10621602 starts
8075: -- The below formula is only for the distribution related to retainage and retainge release invoice
8076:
8077: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
8078:
8079:
8080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8081:

Line 8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

8078:
8079:
8080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8081:
8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||
8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;

Line 8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||

8079:
8080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8081:
8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||
8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;
8087:

Line 8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||

8080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8081:
8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||
8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;
8087:
8088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||

8081:
8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||
8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;
8087:
8088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8089:

Line 8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;

8082: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8083: ' Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8084: ' Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8085: ' Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced ||
8086: ' Unit_price ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).unit_price;
8087:
8088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8089:
8090: END IF;

Line 8092: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage

8088: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8089:
8090: END IF;
8091:
8092: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8093:
8094: p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec)
8095: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec);
8096:

Line 8094: p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec)

8090: END IF;
8091:
8092: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8093:
8094: p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec)
8095: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec);
8096:
8097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8098:

Line 8095: - ((p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))p_ref_per_trx_cur_unit_nrec);

8091:
8092: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8093:
8094: p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec)
8095: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec);
8096:
8097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8098:
8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||

Line 8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||

8095: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec);
8096:
8097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8098:
8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||
8100: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec) ' ||
8101: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8102: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( 1- ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' ) ' ;
8103:

Line 8100: ' - ((p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))p_ref_per_trx_cur_unit_nrec) ' ||

8096:
8097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8098:
8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||
8100: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec) ' ||
8101: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8102: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( 1- ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' ) ' ;
8103:
8104: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8101: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||

8097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8098:
8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||
8100: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec) ' ||
8101: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8102: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( 1- ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' ) ' ;
8103:
8104: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8105:

Line 8102: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' ( 1- ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100)) ' || p_ref_per_trx_cur_unit_nrec || ' ) ' ;

8098:
8099: l_debug_info := 'p_tax_tv := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount )* p_inv_per_trx_cur_unit_nrec) ' ||
8100: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec) ' ||
8101: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8102: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *( 1- ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' || p_ref_per_trx_cur_unit_nrec || ' ) ' ;
8103:
8104: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8105:
8106: END IF;

Line 8118: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice

8114: END IF;
8115:
8116: END IF;
8117:
8118: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8119:
8120: p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)
8121: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec);
8122:

Line 8120: p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)

8116: END IF;
8117:
8118: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8119:
8120: p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)
8121: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec);
8122:
8123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8124:

Line 8121: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_priceAP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)p_ref_per_trx_cur_unit_nrec);

8117:
8118: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8119:
8120: p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)
8121: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec);
8122:
8123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8124:
8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||

Line 8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||

8121: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec);
8122:
8123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8124:
8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||
8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)* p_ref_per_trx_cur_unit_nrec) ' ||
8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||
8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;

Line 8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_priceAP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100) p_ref_per_trx_cur_unit_nrec) ' ||

8122:
8123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8124:
8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||
8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)* p_ref_per_trx_cur_unit_nrec) ' ||
8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||
8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;
8130:

Line 8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||

8123: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8124:
8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||
8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)* p_ref_per_trx_cur_unit_nrec) ' ||
8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||
8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;
8130:
8131: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||

8124:
8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||
8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)* p_ref_per_trx_cur_unit_nrec) ' ||
8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||
8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;
8130:
8131: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8132:

Line 8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;

8125: l_debug_info := 'p_tax_tv := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec)' ||
8126: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)* p_ref_per_trx_cur_unit_nrec) ' ||
8127: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' ) ' ||
8128: ' - (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' ||
8129: AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' / 100)* ' || p_ref_per_trx_cur_unit_nrec ;
8130:
8131: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8132:
8133: END IF;

Line 8316: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN

8312: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8313: END IF;
8314:
8315: --bug 10621602 starts
8316: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
8317:
8318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8319:
8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

Line 8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||

8316: IF AP_ETAX_SERVICES_PKG.ret_dists.exists(p_trx_line_dist_id) THEN
8317:
8318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8319:
8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8321: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8322: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8323: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
8324:

Line 8321: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||

8317:
8318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8319:
8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8321: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8322: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8323: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
8324:
8325: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8322: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||

8318: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8319:
8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8321: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8322: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8323: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
8324:
8325: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8326:

Line 8323: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;

8319:
8320: l_debug_info := 'Invoice Distribution amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount ||
8321: 'Retained amount ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retained_amount ||
8322: 'Retainage rate ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate ||
8323: 'Quantity_Invoiced' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced;
8324:
8325: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8326:
8327: END IF;

Line 8330: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage

8326:
8327: END IF;
8328:
8329:
8330: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8331:
8332: p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) )
8333: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8334:

Line 8332: p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) )

8328:
8329:
8330: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8331:
8332: p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) )
8333: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8334:
8335: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8336:

Line 8333: - ((p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));

8329:
8330: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN --- Standard invoice with retainage
8331:
8332: p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) )
8333: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8334:
8335: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8336:
8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||

Line 8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||

8333: - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8334:
8335: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8336:
8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||
8338: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8339: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8340: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
8341: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;

Line 8338: ' - ((p_quantity_invoiced * p_ref_doc_unit_price(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||

8334:
8335: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8336:
8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||
8338: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8339: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8340: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
8341: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8342:

Line 8339: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||

8335: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8336:
8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||
8338: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8339: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8340: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
8341: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8342:
8343: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8340: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' (1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100)) ' ||

8336:
8337: l_debug_info := 'p_tax_tv_base := ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount)* p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1) ) ' ||
8338: ' - ((p_quantity_invoiced * p_ref_doc_unit_price*(1 - AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100))*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8339: ' (( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' )* ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8340: ' - (( ' || p_quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' *(1 - ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100))* ' ||
8341: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8342:
8343: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8344:

Line 8357: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice

8353: END IF;
8354:
8355: END IF;
8356:
8357: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8358:
8359: p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1))
8360: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8361:

Line 8359: p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1))

8355: END IF;
8356:
8357: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8358:
8359: p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1))
8360: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8361:
8362:
8363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8360: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_priceAP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));

8356:
8357: IF ( AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).RETAINED_INVOICE_DIST_ID IS NOT NULL) THEN --- Retainage Release invoice
8358:
8359: p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1))
8360: - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1));
8361:
8362:
8363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8364:

Line 8365: l_debug_info := ' p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1)) ' ||

8361:
8362:
8363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8364:
8365: l_debug_info := ' p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1)) ' ||
8366: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8367: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8368: ' -(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100) * ' ||
8369: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;

Line 8366: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_priceAP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||

8362:
8363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8364:
8365: l_debug_info := ' p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1)) ' ||
8366: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8367: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8368: ' -(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100) * ' ||
8369: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8370:

Line 8367: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||

8363: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8364:
8365: l_debug_info := ' p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1)) ' ||
8366: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8367: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8368: ' -(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100) * ' ||
8369: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8370:
8371: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8368: ' -(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100) * ' ||

8364:
8365: l_debug_info := ' p_tax_tv_base := (AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount * p_inv_per_trx_cur_unit_nrec * nvl(p_inv_curr_rate , 1)) ' ||
8366: ' - ((AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced * p_ref_doc_unit_price*AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate/100)*p_ref_per_trx_cur_unit_nrec * nvl(p_ref_doc_curr_rate , 1)) ' ||
8367: ' ( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).amount || ' * ' || p_inv_per_trx_cur_unit_nrec || ' * ' || nvl(p_inv_curr_rate , 1) || ' ) ' ||
8368: ' -(( ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).quantity_invoiced || ' * ' || p_ref_doc_unit_price || ' * ' || AP_ETAX_SERVICES_PKG.ret_dists(p_trx_line_dist_id).retainage_rate || ' /100) * ' ||
8369: p_ref_per_trx_cur_unit_nrec || ' * ' || nvl(p_ref_doc_curr_rate , 1) || ' ) ' ;
8370:
8371: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
8372:

Line 10254: | Called from : AP_ETAX_SERVICES_PKG.Populate_Lines_GT()

10250: /*=============================================================================
10251: | FUNCTION - Is_Incl_Tax_Driver_Updatable()
10252: |
10253: | DESCRIPTION
10254: | Called from : AP_ETAX_SERVICES_PKG.Populate_Lines_GT()
10255: | APINLIN.pld
10256: | APXINWKB.fmb
10257: | RETURN TRUE : Allow To Override Tax drivers
10258: | RETURN FALUSE : Don't Allow To Override Tax drivers

Line 10870: current_calling_sequence VARCHAR2(2000) := 'AP_ETAX_SERVICES_PKG.GET_CCID_FROM_PROJECTS';

10866: l_unbuilt_flex VARCHAR2(240):='';
10867: l_reason_unbuilt_flex VARCHAR2(2000):='';
10868:
10869: user_id NUMBER;
10870: current_calling_sequence VARCHAR2(2000) := 'AP_ETAX_SERVICES_PKG.GET_CCID_FROM_PROJECTS';
10871:
10872:
10873: BEGIN
10874: