[Home] [Help]
282: | OUT NOCOPY
283: |
284: | DESCRIPTION
285: | This routine contains the necessary logic to populate header_level user extensible
286: | attributes into ZX_PRVDR_LINE_EXTNS_GT.
287: |
288: | SCOPE - PUBLIC
289: |
290: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED/PRIVATE PROCEDURES ACCESSED
303: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
304:
305:
306: --This is the main driver cursor for fetching all records from the ZX_LINES_DET_FACTORS
307: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
308:
309:
310: CURSOR PROC_LINE_CSR IS
311: SELECT
365:
366:
367: --This is the cursor for fetching all records from the ZX_USR_PROC_NEG_LINE_V.
368: --The specific purpose of this view is to retain old data from zx_lines_det_factors
369: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
370:
371: CURSOR PROC_NEG_LINE_CSR IS
372: SELECT
373: Internal_Organization_Id ,
624:
625: /*This portion of the code is used to collect the values from the user extensible
626: procedures into nested tables based on the inputs we have collected into nested
627: tables so far (such as transaction ids, product ids,org ids etc) .This step
628: is necessary as we want to bulk insert all values into ZX_PRVDR_LINE_EXTNS_GT
629: through nested tables only.Doing this in a separate loop only for clarity*/
630:
631: derive_trx_line_type;
632: derive_product_code;
641: derive_company_code;
642:
643: END LOOP;
644:
645: /*This portion of the code performs a bulk insert into the ZX_PRVDR_LINE_EXTNS_GT
646: through all the pl/sql tables populated above*/
647: IF g_line_negation THEN
648: null;
649: ELSE
651: BEGIN
652: FORALL j in 1..NVL(trx_id_tab.last,0)
653:
654: INSERT INTO
655: ZX_PRVDR_LINE_EXTNS_GT
656: (
657: EVENT_CLASS_CODE,
658: APPLICATION_ID ,
659: ENTITY_CODE ,
728: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
730: END IF;
731: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: g_string :='Not able to insert in to ZX_PRVDR_LINE_EXTNS_GT ';
733: error_exception_handle(g_string);
734: x_messages_tbl:=g_messages_tbl;
735: return;
736:
908: tax_identifier_tab tax_identifier_table;
909:
910: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
911: l_location_type VARCHAR2(100);
912: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
913: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
914: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
915: l_tax_account_source_tax VARCHAR2(50);
916: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
909:
910: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
911: l_location_type VARCHAR2(100);
912: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
913: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
914: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
915: l_tax_account_source_tax VARCHAR2(50);
916: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
917: l_jurisdictions_found VARCHAR2(5);
910: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
911: l_location_type VARCHAR2(100);
912: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
913: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
914: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
915: l_tax_account_source_tax VARCHAR2(50);
916: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
917: l_jurisdictions_found VARCHAR2(5);
918: l_multiple_jurisdictions_flag VARCHAR2(5);