APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_LINES_DET_FACTORS

Line 57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');

53:
54: IF (g_level_statement >= g_current_runtime_level ) THEN
55: FND_LOG.STRING(g_level_statement,
56: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58: END IF;
59:
60:
61: -- Insert data into zx_lines_det_factors and zx_lines_summary

Line 61: -- Insert data into zx_lines_det_factors and zx_lines_summary

57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58: END IF;
59:
60:
61: -- Insert data into zx_lines_det_factors and zx_lines_summary
62: --
63: INSERT ALL
64: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
65: TAX_ONLY_LINE_FLAG = 'Y'

Line 67: INTO ZX_LINES_DET_FACTORS (

63: INSERT ALL
64: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
65: TAX_ONLY_LINE_FLAG = 'Y'
66: THEN
67: INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID
69: ,OBJECT_VERSION_NUMBER
70: ,INTERNAL_ORGANIZATION_ID
71: ,APPLICATION_ID

Line 1003: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188

999: AND NVL(lines.historical_flag, 'N') = 'Y'
1000: AND poll.line_location_id(+) = lines.po_line_location_id
1001: AND ptp.party_type_code = 'OU'
1002: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
1003: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1004: WHERE zxdet.application_id = 200
1005: AND zxdet.entity_code = 'AP_INVOICES'
1006: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1007: 'STANDARD', 'STANDARD INVOICES',

Line 2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');

2195:
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200: END IF;
2201:
2202: -- Insert data into zx_lines_det_factors and zx_lines_summary
2203: --

Line 2202: -- Insert data into zx_lines_det_factors and zx_lines_summary

2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200: END IF;
2201:
2202: -- Insert data into zx_lines_det_factors and zx_lines_summary
2203: --
2204: INSERT ALL
2205: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2206: TAX_ONLY_LINE_FLAG = 'Y'

Line 2208: INTO ZX_LINES_DET_FACTORS (

2204: INSERT ALL
2205: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2206: TAX_ONLY_LINE_FLAG = 'Y'
2207: THEN
2208: INTO ZX_LINES_DET_FACTORS (
2209: EVENT_ID
2210: ,OBJECT_VERSION_NUMBER
2211: ,INTERNAL_ORGANIZATION_ID
2212: ,APPLICATION_ID