APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_LINES_S

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

440: ,BILL_THIRD_PTY_ACCT_ID
441: ,BILL_THIRD_PTY_ACCT_SITE_ID
442: )
443: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
444: INTO ZX_LINES_SUMMARY (
445: SUMMARY_TAX_LINE_ID
446: ,INTERNAL_ORGANIZATION_ID
447: ,APPLICATION_ID
448: ,ENTITY_CODE

Line 1227: ZX_LINES_S.NEXTVAL

1223: ,ACCOUNT_SOURCE_TAX_RATE_ID
1224: ,RECOVERY_RATE_ID
1225: )
1226: VALUES(
1227: ZX_LINES_S.NEXTVAL
1228: ,REC_NREC_TAX_DIST_ID
1229: ,REC_NREC_TAX_DIST_NUMBER
1230: ,APPLICATION_ID
1231: ,CONTENT_OWNER_ID

Line 1594: ZX_LINES_S.NEXTVAL

1590: ,LEGAL_REPORTING_STATUS
1591: ,ACCOUNT_SOURCE_TAX_RATE_ID
1592: )
1593: VALUES (
1594: ZX_LINES_S.NEXTVAL
1595: ,TAX_LINE_NUMBER
1596: ,APPLICATION_ID
1597: ,CONTENT_OWNER_ID
1598: ,CURRENCY_CONVERSION_DATE

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

2606: ,BILL_THIRD_PTY_ACCT_ID
2607: ,BILL_THIRD_PTY_ACCT_SITE_ID
2608: )
2609: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2610: INTO ZX_LINES_SUMMARY (
2611: SUMMARY_TAX_LINE_ID
2612: ,INTERNAL_ORGANIZATION_ID
2613: ,APPLICATION_ID
2614: ,ENTITY_CODE

Line 3377: ZX_LINES_S.NEXTVAL

3373: ,ACCOUNT_SOURCE_TAX_RATE_ID
3374: ,RECOVERY_RATE_ID
3375: )
3376: VALUES(
3377: ZX_LINES_S.NEXTVAL
3378: ,REC_NREC_TAX_DIST_ID
3379: ,REC_NREC_TAX_DIST_NUMBER
3380: ,APPLICATION_ID
3381: ,CONTENT_OWNER_ID

Line 3743: ZX_LINES_S.NEXTVAL

3739: ,LEGAL_REPORTING_STATUS
3740: ,ACCOUNT_SOURCE_TAX_RATE_ID
3741: )
3742: VALUES (
3743: ZX_LINES_S.NEXTVAL
3744: ,TAX_LINE_NUMBER
3745: ,APPLICATION_ID
3746: ,CONTENT_OWNER_ID
3747: ,CURRENCY_CONVERSION_DATE