[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 ,
674:
675: /*This portion of the code is used to collect the values from the user extensible
676: procedures into nested tables based on the inputs we have collected into nested
677: tables so far (such as transaction ids, product ids,org ids etc) .This step
678: is necessary as we want to bulk insert all values into ZX_PRVDR_LINE_EXTNS_GT
679: through nested tables only.Doing this in a separate loop only for clarity*/
680:
681: derive_product_code;
682: derive_audit_flag;
696: derive_calculation_flag;
697:
698: END LOOP;
699:
700: /*This portion of the code performs a bulk insert into the ZX_PRVDR_LINE_EXTNS_GT
701: through all the pl/sql tables populated above*/
702: IF g_line_negation THEN
703: null;
704: ELSE
704: ELSE
705: BEGIN
706: FORALL j in 1..NVL(trx_id_tab.last,0)
707: INSERT INTO
708: ZX_PRVDR_LINE_EXTNS_GT
709: (
710: EVENT_CLASS_CODE,
711: APPLICATION_ID ,
712: ENTITY_CODE ,
803: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
805: END IF;
806: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: g_string :='Not able to insert in to ZX_PRVDR_LINE_EXTNS_GT ';
808: error_exception_handle(g_string);
809: x_messages_tbl:=g_messages_tbl;
810: return;
811: END;
984: tax_identifier_tab tax_identifier_table;
985:
986: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
987: l_location_type VARCHAR2(100);
988: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
989: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
990: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
991: l_tax_account_source_tax VARCHAR2(50);
992: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
985:
986: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
987: l_location_type VARCHAR2(100);
988: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
989: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
990: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
991: l_tax_account_source_tax VARCHAR2(50);
992: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
993: l_jurisdictions_found VARCHAR2(5);
986: l_api_name CONSTANT VARCHAR2(80) := 'POPULATE_EXEMPTION_DETAILS';
987: l_location_type VARCHAR2(100);
988: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
989: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
990: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
991: l_tax_account_source_tax VARCHAR2(50);
992: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
993: l_jurisdictions_found VARCHAR2(5);
994: l_multiple_jurisdictions_flag VARCHAR2(5);