APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_LINES_S

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 420: INTO ZX_LINES_SUMMARY (

416: ,BILL_THIRD_PTY_ACCT_ID
417: ,BILL_THIRD_PTY_ACCT_SITE_ID
418: )
419: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
420: INTO ZX_LINES_SUMMARY (
421: SUMMARY_TAX_LINE_ID
422: ,INTERNAL_ORGANIZATION_ID
423: ,APPLICATION_ID
424: ,ENTITY_CODE

Line 1201: ZX_LINES_S.NEXTVAL

1197: ,ACCOUNT_SOURCE_TAX_RATE_ID
1198: ,RECOVERY_RATE_ID
1199: )
1200: VALUES(
1201: ZX_LINES_S.NEXTVAL
1202: ,REC_NREC_TAX_DIST_ID
1203: ,REC_NREC_TAX_DIST_NUMBER
1204: ,APPLICATION_ID
1205: ,CONTENT_OWNER_ID

Line 1567: ZX_LINES_S.NEXTVAL

1563: ,LEGAL_REPORTING_STATUS
1564: ,ACCOUNT_SOURCE_TAX_RATE_ID
1565: )
1566: VALUES (
1567: ZX_LINES_S.NEXTVAL
1568: ,TAX_LINE_NUMBER
1569: ,APPLICATION_ID
1570: ,CONTENT_OWNER_ID
1571: ,CURRENCY_CONVERSION_DATE

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 2561: INTO ZX_LINES_SUMMARY (

2557: ,BILL_THIRD_PTY_ACCT_ID
2558: ,BILL_THIRD_PTY_ACCT_SITE_ID
2559: )
2560: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2561: INTO ZX_LINES_SUMMARY (
2562: SUMMARY_TAX_LINE_ID
2563: ,INTERNAL_ORGANIZATION_ID
2564: ,APPLICATION_ID
2565: ,ENTITY_CODE

Line 3326: ZX_LINES_S.NEXTVAL

3322: ,ACCOUNT_SOURCE_TAX_RATE_ID
3323: ,RECOVERY_RATE_ID
3324: )
3325: VALUES(
3326: ZX_LINES_S.NEXTVAL
3327: ,REC_NREC_TAX_DIST_ID
3328: ,REC_NREC_TAX_DIST_NUMBER
3329: ,APPLICATION_ID
3330: ,CONTENT_OWNER_ID

Line 3692: ZX_LINES_S.NEXTVAL

3688: ,LEGAL_REPORTING_STATUS
3689: ,ACCOUNT_SOURCE_TAX_RATE_ID
3690: )
3691: VALUES (
3692: ZX_LINES_S.NEXTVAL
3693: ,TAX_LINE_NUMBER
3694: ,APPLICATION_ID
3695: ,CONTENT_OWNER_ID
3696: ,CURRENCY_CONVERSION_DATE