DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_LINES_S

Line 2246: -- Insert data into zx_lines_det_factors and zx_lines_summary

2242: END IF;
2243:
2244: x_retcode := CONC_SUCCESS;
2245:
2246: -- Insert data into zx_lines_det_factors and zx_lines_summary
2247: --
2248: INSERT ALL
2249: WHEN AP_LINE_LOOKUP_CODE IN ('ITEM', 'PREPAY','FREIGHT','MISCELLANEOUS') OR
2250: TAX_ONLY_LINE_FLAG = 'Y'

Line 2487: INTO ZX_LINES_SUMMARY (

2483: ,BILL_THIRD_PTY_ACCT_ID
2484: ,BILL_THIRD_PTY_ACCT_SITE_ID
2485: )
2486: WHEN AP_LINE_LOOKUP_CODE = 'TAX' THEN
2487: INTO ZX_LINES_SUMMARY (
2488: SUMMARY_TAX_LINE_ID
2489: ,INTERNAL_ORGANIZATION_ID
2490: ,APPLICATION_ID
2491: ,ENTITY_CODE

Line 3124: ZX_LINES_S.NEXTVAL

3120: ,ACCOUNT_SOURCE_TAX_RATE_ID
3121: ,RECOVERY_RATE_ID
3122: )
3123: VALUES(
3124: ZX_LINES_S.NEXTVAL
3125: ,REC_NREC_TAX_DIST_ID
3126: ,REC_NREC_TAX_DIST_NUMBER
3127: ,200
3128: ,CONTENT_OWNER_ID

Line 3420: ZX_LINES_S.NEXTVAL

3416: ,LEGAL_REPORTING_STATUS
3417: ,ACCOUNT_SOURCE_TAX_RATE_ID
3418: )
3419: VALUES (
3420: ZX_LINES_S.NEXTVAL
3421: ,TAX_LINE_NUMBER
3422: ,200
3423: ,CONTENT_OWNER_ID
3424: ,CURRENCY_CONVERSION_DATE

Line 4923: zx_lines_s.nextval TAX_LINE_ID,

4919: -- NULL TAX_HOLD_RELEASED_CODE,
4920: taxes.tax_id TAX_ID,
4921: -- NULL TAX_JURISDICTION_CODE,
4922: -- NULL TAX_JURISDICTION_ID,
4923: zx_lines_s.nextval TAX_LINE_ID,
4924: RANK() OVER
4925: (PARTITION BY
4926: NVL(poll.po_release_id,
4927: poh.po_header_id)