APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_LINES_DET_FACTORS

Line 96: 'Inserting data into zx_lines_det_factors');

92:
93: IF (g_level_statement >= g_current_runtime_level ) THEN
94: FND_LOG.STRING(g_level_statement,
95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
96: 'Inserting data into zx_lines_det_factors');
97: END IF;
98:
99: -- Insert data into zx_lines_det_factors
100: --

Line 99: -- Insert data into zx_lines_det_factors

95: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
96: 'Inserting data into zx_lines_det_factors');
97: END IF;
98:
99: -- Insert data into zx_lines_det_factors
100: --
101: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
102: INSERT INTO ZX_LINES_DET_FACTORS (
103: EVENT_ID

Line 102: INSERT INTO ZX_LINES_DET_FACTORS (

98:
99: -- Insert data into zx_lines_det_factors
100: --
101: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
102: INSERT INTO ZX_LINES_DET_FACTORS (
103: EVENT_ID
104: ,ACCOUNT_CCID
105: ,ACCOUNT_STRING
106: ,ADJUSTED_DOC_APPLICATION_ID

Line 507: (SELECT 1 FROM zx_lines_det_factors zxl

503: )
504: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
505: AND ptp.party_type_code = 'OU'
506: AND NOT EXISTS
507: (SELECT 1 FROM zx_lines_det_factors zxl
508: WHERE zxl.APPLICATION_ID = 201
509: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
510: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
511: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 2426: -- Insert data into zx_lines_det_factors

2422: END IF;
2423:
2424: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2425:
2426: -- Insert data into zx_lines_det_factors
2427: --
2428: INSERT INTO ZX_LINES_DET_FACTORS (
2429: EVENT_ID
2430: ,ACCOUNT_CCID

Line 2428: INSERT INTO ZX_LINES_DET_FACTORS (

2424: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2425:
2426: -- Insert data into zx_lines_det_factors
2427: --
2428: INSERT INTO ZX_LINES_DET_FACTORS (
2429: EVENT_ID
2430: ,ACCOUNT_CCID
2431: ,ACCOUNT_STRING
2432: ,ADJUSTED_DOC_APPLICATION_ID

Line 2842: (SELECT 1 FROM zx_lines_det_factors zxl

2838: )
2839: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
2840: AND ptp.party_type_code = 'OU'
2841: AND NOT EXISTS
2842: (SELECT 1 FROM zx_lines_det_factors zxl
2843: WHERE zxl.APPLICATION_ID = 201
2844: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
2845: AND zxl.ENTITY_CODE = 'RELEASE'
2846: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 4856: 'Inserting data into zx_lines_det_factors');

4852:
4853: IF (g_level_statement >= g_current_runtime_level ) THEN
4854: FND_LOG.STRING(g_level_statement,
4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (

Line 4858: -- Insert data into zx_lines_det_factors

4854: FND_LOG.STRING(g_level_statement,
4855: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (
4861: EVENT_ID
4862: ,ACCOUNT_CCID

Line 4860: INSERT INTO ZX_LINES_DET_FACTORS (

4856: 'Inserting data into zx_lines_det_factors');
4857: END IF;
4858: -- Insert data into zx_lines_det_factors
4859: --
4860: INSERT INTO ZX_LINES_DET_FACTORS (
4861: EVENT_ID
4862: ,ACCOUNT_CCID
4863: ,ACCOUNT_STRING
4864: ,ADJUSTED_DOC_APPLICATION_ID

Line 7172: -- Insert data into zx_lines_det_factors

7168: END IF;
7169:
7170: -- bug 5166217 : Do bulk migration for RELEASE
7171: --
7172: -- Insert data into zx_lines_det_factors
7173: --
7174: INSERT INTO ZX_LINES_DET_FACTORS (
7175: EVENT_ID
7176: ,ACCOUNT_CCID

Line 7174: INSERT INTO ZX_LINES_DET_FACTORS (

7170: -- bug 5166217 : Do bulk migration for RELEASE
7171: --
7172: -- Insert data into zx_lines_det_factors
7173: --
7174: INSERT INTO ZX_LINES_DET_FACTORS (
7175: EVENT_ID
7176: ,ACCOUNT_CCID
7177: ,ACCOUNT_STRING
7178: ,ADJUSTED_DOC_APPLICATION_ID