DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_LINES_DET_FACTORS

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

77:
78: IF (g_level_statement >= g_current_runtime_level ) THEN
79: FND_LOG.STRING(g_level_statement,
80: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
81: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
82: END IF;
83:
84:
85: -- Insert data into zx_lines_det_factors and zx_lines_summary

Line 85: -- Insert data into zx_lines_det_factors and zx_lines_summary

81: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
82: END IF;
83:
84:
85: -- Insert data into zx_lines_det_factors and zx_lines_summary
86: --
87: INSERT ALL
88: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
89: TAX_ONLY_LINE_FLAG = 'Y'

Line 91: INTO ZX_LINES_DET_FACTORS (

87: INSERT ALL
88: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
89: TAX_ONLY_LINE_FLAG = 'Y'
90: THEN
91: INTO ZX_LINES_DET_FACTORS (
92: EVENT_ID
93: ,OBJECT_VERSION_NUMBER
94: ,INTERNAL_ORGANIZATION_ID
95: ,APPLICATION_ID

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

1025: AND NVL(lines.historical_flag, 'N') = 'Y'
1026: AND poll.line_location_id(+) = lines.po_line_location_id
1027: AND ptp.party_type_code = 'OU'
1028: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
1029: AND NOT EXISTS (SELECT 1 FROM zx_lines_det_factors zxdet --Bug 6738188
1030: WHERE zxdet.application_id = 200
1031: AND zxdet.entity_code = 'AP_INVOICES'
1032: AND zxdet.event_class_code = DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
1033: 'STANDARD', 'STANDARD INVOICES',

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

2244:
2245: IF (g_level_statement >= g_current_runtime_level ) THEN
2246: FND_LOG.STRING(g_level_statement,
2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2248: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2249: END IF;
2250:
2251: -- Insert data into zx_lines_det_factors and zx_lines_summary
2252: --

Line 2251: -- Insert data into zx_lines_det_factors and zx_lines_summary

2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2248: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2249: END IF;
2250:
2251: -- Insert data into zx_lines_det_factors and zx_lines_summary
2252: --
2253: INSERT ALL
2254: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2255: TAX_ONLY_LINE_FLAG = 'Y'

Line 2257: INTO ZX_LINES_DET_FACTORS (

2253: INSERT ALL
2254: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2255: TAX_ONLY_LINE_FLAG = 'Y'
2256: THEN
2257: INTO ZX_LINES_DET_FACTORS (
2258: EVENT_ID
2259: ,OBJECT_VERSION_NUMBER
2260: ,INTERNAL_ORGANIZATION_ID
2261: ,APPLICATION_ID