APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_LINES_DET_FACTORS

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

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

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

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

Line 482: INTO ZX_LINES_DET_FACTORS(

478: trx_line_id = -9999) */
479:
480: INSERT ALL
481: WHEN trx_line_type IN ('LINE' ,'CB') THEN
482: INTO ZX_LINES_DET_FACTORS(
483: INTERNAL_ORGANIZATION_ID
484: ,APPLICATION_ID
485: ,ENTITY_CODE
486: ,EVENT_CLASS_CODE

Line 2187: (SELECT 1 FROM zx_lines_det_factors zxl

2183: AND rates.tax_status_code = status.tax_status_code(+)
2184: AND rates.content_owner_id = status.content_owner_id(+)
2185: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
2186: AND NOT EXISTS
2187: (SELECT 1 FROM zx_lines_det_factors zxl
2188: WHERE zxl.APPLICATION_ID = 222
2189: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
2190: 'INV','INVOICE',
2191: 'CM', 'CREDIT_MEMO',

Line 2246: -- Insert data into zx_lines_det_factors and zx_lines_summary

2242: END IF;
2243:
2244: x_retcode := CONC_SUCCESS;
2245:
2246: -- Insert data into zx_lines_det_factors and zx_lines_summary
2247: --
2248: INSERT ALL
2249: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2250: TAX_ONLY_LINE_FLAG = 'Y'

Line 2252: INTO ZX_LINES_DET_FACTORS (

2248: INSERT ALL
2249: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2250: TAX_ONLY_LINE_FLAG = 'Y'
2251: THEN
2252: INTO ZX_LINES_DET_FACTORS (
2253: --EVENT_ID
2254: OBJECT_VERSION_NUMBER
2255: ,INTERNAL_ORGANIZATION_ID
2256: ,APPLICATION_ID

Line 2961: (SELECT 1 FROM zx_lines_Det_Factors zxdet

2957: AND ptp.party_type_code = 'OU'
2958: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
2959: AND NVL(inv.historical_flag, 'N') = 'Y'
2960: AND NOT EXISTS
2961: (SELECT 1 FROM zx_lines_Det_Factors zxdet
2962: WHERE zxdet.APPLICATION_ID = 200
2963: AND zxdet.ENTITY_CODE = 'AP_INVOICES'
2964: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
2965: 'STANDARD', 'STANDARD INVOICES',

Line 3919: INSERT INTO ZX_LINES_DET_FACTORS (

3915: ZX_PO_REC_PKG.get_rec_info(
3916: p_start_rowid => p_start_rowid,
3917: p_end_rowid => p_end_rowid);
3918:
3919: INSERT INTO ZX_LINES_DET_FACTORS (
3920: -- ,EVENT_ID
3921: -- ,ACCOUNT_CCID
3922: -- ,ACCOUNT_STRING
3923: -- ,ADJUSTED_DOC_APPLICATION_ID

Line 4328: (SELECT 1 FROM zx_lines_Det_Factors zxdet

4324: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
4325: AND ptp.party_type_code = 'OU'
4326: AND hr.location_id(+) = poll.ship_to_location_id
4327: AND NOT EXISTS
4328: (SELECT 1 FROM zx_lines_Det_Factors zxdet
4329: WHERE zxdet.APPLICATION_ID = 201
4330: AND zxdet.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PURCHASE_ORDER')
4331: AND zxdet.EVENT_CLASS_CODE = NVL2(poll.po_release_id, 'RELEASE', 'PO_PA')
4332: AND zxdet.TRX_ID = NVL(poll.po_release_id,poh.po_header_id)