1946:
1947: IF (g_level_statement >= g_current_runtime_level ) THEN
1948: FND_LOG.STRING(g_level_statement,
1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1950: 'Inserting data into zx_rec_nrec_dist');
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --
1949: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
1950: 'Inserting data into zx_rec_nrec_dist');
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --
1955: INSERT INTO ZX_REC_NREC_DIST(
1956: TAX_LINE_ID
1957: ,REC_NREC_TAX_DIST_ID
1951: END IF;
1952:
1953: -- Insert data into zx_rec_nrec_dist
1954: --
1955: INSERT INTO ZX_REC_NREC_DIST(
1956: TAX_LINE_ID
1957: ,REC_NREC_TAX_DIST_ID
1958: ,REC_NREC_TAX_DIST_NUMBER
1959: ,APPLICATION_ID
2091: ,LAST_UPDATED_BY
2092: ,OBJECT_VERSION_NUMBER)
2093: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
2094: pohzd.tax_line_id TAX_LINE_ID
2095: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
2096: ,DECODE(tmp.rec_flag,
2097: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
2098: pohzd.p_po_distribution_id
2099: ORDER BY
2403: AND rates.record_type_code(+) = 'MIGRATED'
2404: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
2405: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
2406: AND NOT EXISTS
2407: (SELECT 1 FROM zx_rec_nrec_dist zxdist
2408: WHERE zxdist.application_id = 201
2409: AND zxdist.entity_code = 'PURCHASE_ORDER'
2410: AND zxdist.event_class_code = 'PO_PA'
2411: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id
4308:
4309: IF (g_level_statement >= g_current_runtime_level ) THEN
4310: FND_LOG.STRING(g_level_statement,
4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4312: 'Inserting data into zx_rec_nrec_dist');
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --
4311: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_po',
4312: 'Inserting data into zx_rec_nrec_dist');
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --
4317: INSERT INTO ZX_REC_NREC_DIST(
4318: TAX_LINE_ID
4319: ,REC_NREC_TAX_DIST_ID
4313: END IF;
4314:
4315: -- Insert data into zx_rec_nrec_dist
4316: --
4317: INSERT INTO ZX_REC_NREC_DIST(
4318: TAX_LINE_ID
4319: ,REC_NREC_TAX_DIST_ID
4320: ,REC_NREC_TAX_DIST_NUMBER
4321: ,APPLICATION_ID
4453: ,LAST_UPDATED_BY
4454: ,OBJECT_VERSION_NUMBER)
4455: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
4456: pohzd.tax_line_id TAX_LINE_ID
4457: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
4458: ,DECODE(tmp.rec_flag,
4459: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
4460: pohzd.p_po_distribution_id
4461: ORDER BY
4765: AND rates.record_type_code(+) = 'MIGRATED'
4766: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
4767: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
4768: AND NOT EXISTS
4769: (SELECT 1 FROM zx_rec_nrec_dist zxdist
4770: WHERE zxdist.application_id = 201
4771: AND zxdist.entity_code = 'RELEASE'
4772: AND zxdist.event_class_code = 'RELEASE'
4773: AND zxdist.trx_id = p_upg_trx_info_rec.trx_id
6699:
6700: IF (g_level_statement >= g_current_runtime_level ) THEN
6701: FND_LOG.STRING(g_level_statement,
6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6703: 'Inserting data into zx_rec_nrec_dist');
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --
6702: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
6703: 'Inserting data into zx_rec_nrec_dist');
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --
6708: INSERT INTO ZX_REC_NREC_DIST(
6709: TAX_LINE_ID
6710: ,REC_NREC_TAX_DIST_ID
6704: END IF;
6705:
6706: -- Insert data into zx_rec_nrec_dist
6707: --
6708: INSERT INTO ZX_REC_NREC_DIST(
6709: TAX_LINE_ID
6710: ,REC_NREC_TAX_DIST_ID
6711: ,REC_NREC_TAX_DIST_NUMBER
6712: ,APPLICATION_ID
6844: ,LAST_UPDATED_BY
6845: ,OBJECT_VERSION_NUMBER)
6846: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
6847: pohzd.tax_line_id TAX_LINE_ID
6848: ,zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID
6849: ,DECODE(tmp.rec_flag,
6850: 'Y', (RANK() OVER (PARTITION BY pohzd.po_header_id,
6851: pohzd.p_po_distribution_id
6852: ORDER BY
9039:
9040: IF (g_level_statement >= g_current_runtime_level ) THEN
9041: FND_LOG.STRING(g_level_statement,
9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
9043: 'Inserting data into zx_rec_nrec_dist');
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --
9042: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk_po',
9043: 'Inserting data into zx_rec_nrec_dist');
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --
9048: INSERT INTO ZX_REC_NREC_DIST(
9049: TAX_LINE_ID
9050: ,REC_NREC_TAX_DIST_ID
9044: END IF;
9045:
9046: -- Insert data into zx_rec_nrec_dist
9047: --
9048: INSERT INTO ZX_REC_NREC_DIST(
9049: TAX_LINE_ID
9050: ,REC_NREC_TAX_DIST_ID
9051: ,REC_NREC_TAX_DIST_NUMBER
9052: ,APPLICATION_ID
9184: ,LAST_UPDATED_BY
9185: ,OBJECT_VERSION_NUMBER)
9186: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
9187: pohzd.tax_line_id TAX_LINE_ID
9188: ,zx_rec_nrec_dist_s.NEXTVAL REC_NREC_TAX_DIST_ID
9189: ,DECODE(tmp.rec_flag,
9190: 'Y', (RANK() OVER (PARTITION BY pohzd.trx_id,
9191: pohzd.p_po_distribution_id
9192: ORDER BY