APPS.ZX_AP_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 2625: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|

2621: /*===========================================================================+
2622: | PROCEDURE |
2623: | insert_tax_info |
2624: | DESCRIPTION |
2625: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
2626: | |
2627: | SCOPE - Private |
2628: | |
2629: | NOTES |

Line 2655: INSERT INTO ZX_REP_TRX_DETAIL_T(

2651: ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));
2652: END IF;
2653:
2654: FORALL i IN 1 .. l_count
2655: INSERT INTO ZX_REP_TRX_DETAIL_T(
2656: DETAIL_TAX_LINE_ID,
2657: APPLICATION_ID,
2658: EXTRACT_REPORT_LINE_NUMBER,
2659: EVENT_CLASS_CODE,

Line 2839: ZX_REP_TRX_DETAIL_T_S.NEXTVAL,

2835: trx_level_type, --Bug 5393051
2836: unit_price,
2837: gl_date) --Bug 5523095
2838: VALUES(
2839: ZX_REP_TRX_DETAIL_T_S.NEXTVAL,
2840: gt_application_id(i),
2841: gt_extract_rep_line_num(i),
2842: gt_event_class_code(i),
2843: gt_internal_organization_id(i),

Line 3226: FROM ZX_REP_TRX_DETAIL_T DTL

3222: --3.Needs Revalidation and don't have any hold.
3223: --4.Needs Revalidation and have atleast one un-released accounting not allowed hold.
3224:
3225: DELETE
3226: FROM ZX_REP_TRX_DETAIL_T DTL
3227: WHERE REQUEST_ID = g_request_id
3228: AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
3229: AND EXISTS
3230: (SELECT 1