[Home] [Help]
290: | OUT NOCOPY
291: |
292: | DESCRIPTION
293: | This routine contains the necessary logic to populate header_level user extensible
294: | attributes into ZX_PRVDR_LINE_EXTNS_GT.
295: |
296: | SCOPE - PUBLIC
297: |
298: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED/PRIVATE PROCEDURES ACCESSED
311: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
312:
313:
314: --This is the main driver cursor for fetching all records from the ZX_LINES_DET_FACTORS
315: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
316:
317:
318: CURSOR PROC_LINE_CSR IS
319: SELECT
374:
375:
376: --This is the cursor for fetching all records from the ZX_USR_PROC_NEG_LINE_V.
377: --The specific purpose of this view is to retain old data from zx_lines_det_factors
378: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
379:
380: CURSOR PROC_NEG_LINE_CSR IS
381: SELECT
382: Internal_Organization_Id ,
668:
669: /*This portion of the code is used to collect the values from the user extensible
670: procedures into nested tables based on the inputs we have collected into nested
671: tables so far (such as transaction ids, product ids,org ids etc) .This step
672: is necessary as we want to bulk insert all values into ZX_PRVDR_LINE_EXTNS_GT
673: through nested tables only.Doing this in a separate loop only for clarity*/
674:
675: derive_product_code;
676: derive_audit_flag;
690: derive_calculation_flag;
691:
692: END LOOP;
693:
694: /*This portion of the code performs a bulk insert into the ZX_PRVDR_LINE_EXTNS_GT
695: through all the pl/sql tables populated above*/
696: IF g_line_negation THEN
697: null;
698: ELSE
698: ELSE
699: BEGIN
700: FORALL j in 1..NVL(trx_id_tab.last,0)
701: INSERT INTO
702: ZX_PRVDR_LINE_EXTNS_GT
703: (
704: EVENT_CLASS_CODE,
705: APPLICATION_ID ,
706: ENTITY_CODE ,
797: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
798: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
799: END IF;
800: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: g_string :='Not able to insert in to ZX_PRVDR_LINE_EXTNS_GT ';
802: error_exception_handle(g_string);
803: x_messages_tbl:=g_messages_tbl;
804: return;
805: END;
985: tax_identifier_tab tax_identifier_table;
986:
987: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
988: l_location_type VARCHAR2(100);
989: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
990: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
991: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
992: l_tax_account_source_tax VARCHAR2(50);
993: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
986:
987: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
988: l_location_type VARCHAR2(100);
989: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
990: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
991: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
992: l_tax_account_source_tax VARCHAR2(50);
993: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
994: l_jurisdictions_found VARCHAR2(5);
987: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
988: l_location_type VARCHAR2(100);
989: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
990: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
991: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
992: l_tax_account_source_tax VARCHAR2(50);
993: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
994: l_jurisdictions_found VARCHAR2(5);
995: l_multiple_jurisdictions_flag VARCHAR2(5);