APPS.ARP_ETAX_AUTOINV_UTIL dependencies on ZX_TRANSACTION_LINES_GT

Line 205: /* Private Procedure - Inserts lines (not tax) into ZX_TRANSACTION_LINES_GT

201: RAISE;
202:
203: END insert_headers;
204:
205: /* Private Procedure - Inserts lines (not tax) into ZX_TRANSACTION_LINES_GT
206:
207: Dev Note:
208:
209: 1) Added outer joins to REC/gldist because the dists don't exist (yet) for

Line 239: INSERT INTO ZX_TRANSACTION_LINES_GT

235:
236: l_so_org_id := oe_profile.value('SO_ORGANIZATION_ID',
237: arp_global.sysparam.org_id);
238:
239: INSERT INTO ZX_TRANSACTION_LINES_GT
240: (
241: application_id,
242: entity_code,
243: event_class_code,

Line 461: update zx_transaction_lines_gt ZXL

457: END IF;
458:
459: /* 6874006 - removed salesrep/person logic from main insert
460: and shifted it to a separate UPDATE */
461: update zx_transaction_lines_gt ZXL
462: set (poo_party_id, poo_location_id) =
463: (select SR_PER.organization_id, -- poo_party_id
464: SR_HRL.location_id -- poo_location_id
465: from RA_CUSTOMER_TRX TRX,

Line 605: UPDATE zx_transaction_lines_gt line

601: the line-level action to CREATE_WITH_TAX */
602: IF g_tax_lines_inserted > 0
603: THEN
604: /* set line level action */
605: UPDATE zx_transaction_lines_gt line
606: SET line_level_action = 'CREATE_WITH_TAX'
607: WHERE EXISTS
608: (SELECT 'manual tax line'
609: FROM ZX_IMPORT_TAX_LINES_GT tax

Line 784: /* Insert lines into ZX_TRANSACTION_LINES_GT */

780:
781: /* Insert lines into ZX_TRX_HEADERS_GT */
782: insert_headers(p_request_id, p_phase);
783:
784: /* Insert lines into ZX_TRANSACTION_LINES_GT */
785: insert_lines(p_request_id, p_phase);
786:
787: /* Detect Manual Tax Lines and stores (caches) results
788: in global variables. This will not do anything on subsequent