APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_LINES_DET_FACTORS

Line 61: 'Inserting data into zx_lines_det_factors');

57:
58: IF (g_level_statement >= g_current_runtime_level ) THEN
59: FND_LOG.STRING(g_level_statement,
60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:
64: -- Insert data into zx_lines_det_factors
65: --

Line 64: -- Insert data into zx_lines_det_factors

60: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
61: 'Inserting data into zx_lines_det_factors');
62: END IF;
63:
64: -- Insert data into zx_lines_det_factors
65: --
66: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
67: INSERT INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID

Line 67: INSERT INTO ZX_LINES_DET_FACTORS (

63:
64: -- Insert data into zx_lines_det_factors
65: --
66: IF p_upg_trx_info_rec.entity_code = 'PURCHASE_ORDER' THEN
67: INSERT INTO ZX_LINES_DET_FACTORS (
68: EVENT_ID
69: ,ACCOUNT_CCID
70: ,ACCOUNT_STRING
71: ,ADJUSTED_DOC_APPLICATION_ID

Line 473: (SELECT 1 FROM zx_lines_det_factors zxl

469: )
470: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
471: AND ptp.party_type_code = 'OU'
472: AND NOT EXISTS
473: (SELECT 1 FROM zx_lines_det_factors zxl
474: WHERE zxl.APPLICATION_ID = 201
475: AND zxl.EVENT_CLASS_CODE = 'PO_PA'
476: AND zxl.ENTITY_CODE = 'PURCHASE_ORDER'
477: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 2364: -- Insert data into zx_lines_det_factors

2360: END IF;
2361:
2362: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2363:
2364: -- Insert data into zx_lines_det_factors
2365: --
2366: INSERT INTO ZX_LINES_DET_FACTORS (
2367: EVENT_ID
2368: ,ACCOUNT_CCID

Line 2366: INSERT INTO ZX_LINES_DET_FACTORS (

2362: ELSIF p_upg_trx_info_rec.entity_code = 'RELEASE' THEN
2363:
2364: -- Insert data into zx_lines_det_factors
2365: --
2366: INSERT INTO ZX_LINES_DET_FACTORS (
2367: EVENT_ID
2368: ,ACCOUNT_CCID
2369: ,ACCOUNT_STRING
2370: ,ADJUSTED_DOC_APPLICATION_ID

Line 2781: (SELECT 1 FROM zx_lines_det_factors zxl

2777: )
2778: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,poll.org_id)
2779: AND ptp.party_type_code = 'OU'
2780: AND NOT EXISTS
2781: (SELECT 1 FROM zx_lines_det_factors zxl
2782: WHERE zxl.APPLICATION_ID = 201
2783: AND zxl.EVENT_CLASS_CODE = 'RELEASE'
2784: AND zxl.ENTITY_CODE = 'RELEASE'
2785: AND zxl.TRX_ID = p_upg_trx_info_rec.trx_id

Line 4766: 'Inserting data into zx_lines_det_factors');

4762:
4763: IF (g_level_statement >= g_current_runtime_level ) THEN
4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (

Line 4768: -- Insert data into zx_lines_det_factors

4764: FND_LOG.STRING(g_level_statement,
4765: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (
4771: EVENT_ID
4772: ,ACCOUNT_CCID

Line 4770: INSERT INTO ZX_LINES_DET_FACTORS (

4766: 'Inserting data into zx_lines_det_factors');
4767: END IF;
4768: -- Insert data into zx_lines_det_factors
4769: --
4770: INSERT INTO ZX_LINES_DET_FACTORS (
4771: EVENT_ID
4772: ,ACCOUNT_CCID
4773: ,ACCOUNT_STRING
4774: ,ADJUSTED_DOC_APPLICATION_ID

Line 7056: -- Insert data into zx_lines_det_factors

7052: END IF;
7053:
7054: -- bug 5166217 : Do bulk migration for RELEASE
7055: --
7056: -- Insert data into zx_lines_det_factors
7057: --
7058: INSERT INTO ZX_LINES_DET_FACTORS (
7059: EVENT_ID
7060: ,ACCOUNT_CCID

Line 7058: INSERT INTO ZX_LINES_DET_FACTORS (

7054: -- bug 5166217 : Do bulk migration for RELEASE
7055: --
7056: -- Insert data into zx_lines_det_factors
7057: --
7058: INSERT INTO ZX_LINES_DET_FACTORS (
7059: EVENT_ID
7060: ,ACCOUNT_CCID
7061: ,ACCOUNT_STRING
7062: ,ADJUSTED_DOC_APPLICATION_ID