APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_LINES_DET_FACTORS

Line 480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,

476: END IF;
477:
478: x_retcode := CONC_SUCCESS;
479:
480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,
481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with
482: trx_line_id = -9999) */
483:
484: INSERT ALL

Line 481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with

477:
478: x_retcode := CONC_SUCCESS;
479:
480: /* Insert All Taxable Lines into ZX_LINES_DET_FACTORS. Incase there are No taxable lines,
481: (link_to_cust_trx_line_id is null, hence insert dummy lines in ZX_LINES_DET_FACTORS with
482: trx_line_id = -9999) */
483:
484: INSERT ALL
485: WHEN trx_line_type IN ('LINE' ,'CB') THEN

Line 486: INTO ZX_LINES_DET_FACTORS(

482: trx_line_id = -9999) */
483:
484: INSERT ALL
485: WHEN trx_line_type IN ('LINE' ,'CB') THEN
486: INTO ZX_LINES_DET_FACTORS(
487: INTERNAL_ORGANIZATION_ID
488: ,APPLICATION_ID
489: ,ENTITY_CODE
490: ,EVENT_CLASS_CODE

Line 2245: (SELECT 1 FROM zx_lines_det_factors zxl

2241: AND rates.tax_status_code = status.tax_status_code(+)
2242: AND rates.content_owner_id = status.content_owner_id(+)
2243: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
2244: AND NOT EXISTS
2245: (SELECT 1 FROM zx_lines_det_factors zxl
2246: WHERE zxl.APPLICATION_ID = 222
2247: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
2248: 'INV','INVOICE',
2249: 'CM', 'CREDIT_MEMO',

Line 2304: -- Insert data into zx_lines_det_factors and zx_lines_summary

2300: END IF;
2301:
2302: x_retcode := CONC_SUCCESS;
2303:
2304: -- Insert data into zx_lines_det_factors and zx_lines_summary
2305: --
2306: INSERT ALL
2307: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2308: TAX_ONLY_LINE_FLAG = 'Y'

Line 2310: INTO ZX_LINES_DET_FACTORS (

2306: INSERT ALL
2307: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2308: TAX_ONLY_LINE_FLAG = 'Y'
2309: THEN
2310: INTO ZX_LINES_DET_FACTORS (
2311: --EVENT_ID
2312: OBJECT_VERSION_NUMBER
2313: ,INTERNAL_ORGANIZATION_ID
2314: ,APPLICATION_ID

Line 3022: (SELECT 1 FROM zx_lines_Det_Factors zxdet

3018: AND ptp.party_type_code = 'OU'
3019: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
3020: AND NVL(inv.historical_flag, 'N') = 'Y'
3021: AND NOT EXISTS
3022: (SELECT 1 FROM zx_lines_Det_Factors zxdet
3023: WHERE zxdet.APPLICATION_ID = 200
3024: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
3025: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3026: 'STANDARD', 'STANDARD INVOICES',

Line 4005: INSERT INTO ZX_LINES_DET_FACTORS (

4001: ZX_PO_REC_PKG.get_rec_info(
4002: p_start_rowid => p_start_rowid,
4003: p_end_rowid => p_end_rowid);
4004:
4005: INSERT INTO ZX_LINES_DET_FACTORS (
4006: -- ,EVENT_ID
4007: -- ,ACCOUNT_CCID
4008: -- ,ACCOUNT_STRING
4009: -- ,ADJUSTED_DOC_APPLICATION_ID

Line 4416: (SELECT 1 FROM zx_lines_Det_Factors zxdet

4412: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
4413: AND ptp.party_type_code = 'OU'
4414: AND hr.location_id(+) = poll.ship_to_location_id
4415: AND NOT EXISTS
4416: (SELECT 1 FROM zx_lines_Det_Factors zxdet
4417: WHERE zxdet.APPLICATION_ID = 201
4418: AND zxdet.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PURCHASE_ORDER')
4419: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4420: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)