eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_TAX_INTERFACE_PVT dependencies on ZX_LINES

Line 22: PROCEDURE populate_zx_lines_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,

18:
19: PROCEDURE populate_zx_headers_with_req(p_requisition_header_id IN NUMBER,
20: p_calling_program IN VARCHAR2);
21:
22: PROCEDURE populate_zx_lines_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
23: p_calling_program IN VARCHAR2);
24:
25: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
26: p_calling_program IN VARCHAR2);

Line 25: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,

21:
22: PROCEDURE populate_zx_lines_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
23: p_calling_program IN VARCHAR2);
24:
25: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
26: p_calling_program IN VARCHAR2);
27:
28: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
29: p_calling_program IN VARCHAR2);

Line 28: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,

24:
25: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
26: p_calling_program IN VARCHAR2);
27:
28: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
29: p_calling_program IN VARCHAR2);
30:
31: PROCEDURE populate_zx_dists_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
32: p_calling_program IN VARCHAR2);

Line 39: PROCEDURE populate_zx_lines_with_po_cal(p_po_header_id_tbl IN PO_TBL_NUMBER,

35:
36: PROCEDURE populate_zx_dists_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
37: p_calling_program IN VARCHAR2);
38: -- Bug 11665348
39: PROCEDURE populate_zx_lines_with_po_cal(p_po_header_id_tbl IN PO_TBL_NUMBER,
40: p_calling_program IN VARCHAR2);
41:
42: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,
43: p_calling_program IN VARCHAR2);

Line 42: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,

38: -- Bug 11665348
39: PROCEDURE populate_zx_lines_with_po_cal(p_po_header_id_tbl IN PO_TBL_NUMBER,
40: p_calling_program IN VARCHAR2);
41:
42: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,
43: p_calling_program IN VARCHAR2);
44: -- Bug 11665348
45:
46:

Line 271: populate_zx_lines_with_po(p_po_header_id_tbl, p_calling_program);

267: populate_zx_headers_with_po(p_po_header_id_tbl, p_calling_program);
268: d_progress := 70;
269: populate_zx_headers_with_rel(p_po_release_id_tbl, p_calling_program);
270: d_progress := 80;
271: populate_zx_lines_with_po(p_po_header_id_tbl, p_calling_program);
272: d_progress := 90;
273: populate_zx_lines_with_rel(p_po_release_id_tbl, p_calling_program);
274:
275: d_progress := 100;

Line 273: populate_zx_lines_with_rel(p_po_release_id_tbl, p_calling_program);

269: populate_zx_headers_with_rel(p_po_release_id_tbl, p_calling_program);
270: d_progress := 80;
271: populate_zx_lines_with_po(p_po_header_id_tbl, p_calling_program);
272: d_progress := 90;
273: populate_zx_lines_with_rel(p_po_release_id_tbl, p_calling_program);
274:
275: d_progress := 100;
276: -- Call eTax API calculate_tax to construct tax lines
277: -- For lines wih line_level_action of COPY_AND_CREATE eTax will use

Line 451: populate_zx_lines_with_po_cal(p_po_header_id_tbl, p_calling_program);

447:
448:
449: -- Populate ZX headers and lines GT tables with transaction data
450: d_progress := 196;
451: populate_zx_lines_with_po_cal(p_po_header_id_tbl, p_calling_program);
452: d_progress := 198;
453: populate_zx_lines_with_rel_cal(p_po_release_id_tbl, p_calling_program);
454:
455: BEGIN

Line 453: populate_zx_lines_with_rel_cal(p_po_release_id_tbl, p_calling_program);

449: -- Populate ZX headers and lines GT tables with transaction data
450: d_progress := 196;
451: populate_zx_lines_with_po_cal(p_po_header_id_tbl, p_calling_program);
452: d_progress := 198;
453: populate_zx_lines_with_rel_cal(p_po_release_id_tbl, p_calling_program);
454:
455: BEGIN
456: SELECT COUNT(1) INTO l_count FROM zx_transaction_lines_gt;
457: EXCEPTION WHEN OTHERS THEN

Line 586: the tax lines insertion in to ZX_LINES fails. */

582: PO_LOG.stmt(d_module_base,d_progress,'Number of records in zx_errors_gt '||l_count);
583: END IF;
584:
585: /* Bug#12317965: ZX_LINE_DET_FACTORS should not have records inserted, in case
586: the tax lines insertion in to ZX_LINES fails. */
587: d_progress := 245;
588: ROLLBACK TO SAVEPOINT calculate_tax_savepoint;
589:
590: END IF;

Line 928: -- Add a join to zl.trx_id so that the index on zx_lines can be used

924:
925: d_progress := 510;
926:
927: -- bug5685869
928: -- Add a join to zl.trx_id so that the index on zx_lines can be used
929: -- more efficiently
930:
931: -- Set the taxable flag column of shipments which have tax lines
932: UPDATE po_line_locations_all pll

Line 934: DECODE((SELECT COUNT(1) FROM zx_lines zl

930:
931: -- Set the taxable flag column of shipments which have tax lines
932: UPDATE po_line_locations_all pll
933: SET pll.taxable_flag =
934: DECODE((SELECT COUNT(1) FROM zx_lines zl
935: WHERE zl.trx_line_id = pll.line_location_id
936: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
937: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
938: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

Line 1338: populate_zx_lines_with_req(p_requisition_header_id, p_calling_program);

1334: d_progress := 30;
1335: populate_zx_headers_with_req(p_requisition_header_id, p_calling_program);
1336:
1337: d_progress := 40;
1338: populate_zx_lines_with_req(p_requisition_header_id, p_calling_program);
1339:
1340: d_progress := 50;
1341: -- Check if zx lines gt table is empty
1342: BEGIN

Line 1341: -- Check if zx lines gt table is empty

1337: d_progress := 40;
1338: populate_zx_lines_with_req(p_requisition_header_id, p_calling_program);
1339:
1340: d_progress := 50;
1341: -- Check if zx lines gt table is empty
1342: BEGIN
1343: SELECT COUNT(1) INTO l_line_count FROM zx_transaction_lines_gt;
1344: EXCEPTION WHEN OTHERS THEN
1345: l_line_count := 0;

Line 1996: DECODE((SELECT COUNT(1) FROM zx_lines zl

1992:
1993: /* Bug 6157632 Start */
1994: UPDATE po_line_locations_all pll
1995: SET pll.taxable_flag =
1996: DECODE((SELECT COUNT(1) FROM zx_lines zl
1997: WHERE zl.trx_line_id = pll.line_location_id
1998: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
1999: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2000: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

Line 2226: DECODE((SELECT COUNT(1) FROM zx_lines zl

2222:
2223: /* Bug 6157632 Start */
2224: UPDATE po_line_locations_all pll
2225: SET pll.taxable_flag =
2226: DECODE((SELECT COUNT(1) FROM zx_lines zl
2227: WHERE zl.trx_line_id = pll.line_location_id
2228: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID
2229: AND ( (zl.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
2230: AND zl.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

Line 2577: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc

2573: -- Bug 5025018. Updated tax attribute mappings
2574: ,ph.org_id --rounding_bill_to_party_id
2575: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2576: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2577: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2578: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2579: AND fc.currency_code = ph.currency_code
2580: -- Conditions for getting Additional Tax Attributes
2581: -- Note that the po_header_id is of current document being processed,

Line 2583: -- with zx_lines_det_factors because that table is denormalized

2579: AND fc.currency_code = ph.currency_code
2580: -- Conditions for getting Additional Tax Attributes
2581: -- Note that the po_header_id is of current document being processed,
2582: -- not of any source document. Get the first row obtained from join
2583: -- with zx_lines_det_factors because that table is denormalized
2584: AND zxldet.trx_id(+) = ph.po_header_id
2585: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2586: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.PO_ENTITY_CODE
2587: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE

Line 2799: LEFT OUTER JOIN zx_lines_det_factors zxldet

2795: -- Conditions for getting Additional Tax Attributes
2796: -- Copy from Planned PO if its a newly created Scheduled Release
2797: -- ELSE simply copy from existing release header (ie. in case of a
2798: -- shipment split or regular blanket/scheduled release create/update
2799: LEFT OUTER JOIN zx_lines_det_factors zxldet
2800: ON ((pr.po_header_id = zxldet.trx_id
2801: AND PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
2802: AND PO_CONSTANTS_SV.PO_ENTITY_CODE = zxldet.entity_code
2803: AND PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE = zxldet.event_class_code

Line 2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet

2983: ,zxldet.default_taxation_country --default_taxation_country
2984: ,DECODE(p_calling_program, --icx_session_id
2985: 'DETERMINE_RECOVERY_REQ', null,
2986: FND_GLOBAL.session_id)
2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join

Line 2992: -- with zx_lines_det_factors because that table is denormalized

2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,
2991: -- not of any source document. Get the first row obtained from join
2992: -- with zx_lines_det_factors because that table is denormalized
2993: AND zxldet.trx_id(+) = prh.requisition_header_id
2994: AND zxldet.application_id(+) = PO_CONSTANTS_SV.APPLICATION_ID
2995: AND zxldet.entity_code(+) = PO_CONSTANTS_SV.REQ_ENTITY_CODE
2996: AND zxldet.event_class_code(+) = PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE

Line 3002: /* Bug 11665348: Modified the procedures populate_zx_lines_with_po and

2998: AND rownum = 1;
2999:
3000: END populate_zx_headers_with_req;
3001:
3002: /* Bug 11665348: Modified the procedures populate_zx_lines_with_po and
3003: populate_zx_lines_with_rel so that they will dump the data into zx_transaction_lines_gt
3004: only for the PO shipments which are not received and not billed and not shipped.
3005: */
3006:

Line 3003: populate_zx_lines_with_rel so that they will dump the data into zx_transaction_lines_gt

2999:
3000: END populate_zx_headers_with_req;
3001:
3002: /* Bug 11665348: Modified the procedures populate_zx_lines_with_po and
3003: populate_zx_lines_with_rel so that they will dump the data into zx_transaction_lines_gt
3004: only for the PO shipments which are not received and not billed and not shipped.
3005: */
3006:
3007: -----------------------------------------------------------------------------

Line 3009: --Name: populate_zx_lines_with_po

3005: */
3006:
3007: -----------------------------------------------------------------------------
3008: --Start of Comments
3009: --Name: populate_zx_lines_with_po
3010: --Pre-reqs:
3011: -- None
3012: --Modifies:
3013: -- ZX_TRANSACTION_LINES_GT

Line 3030: PROCEDURE populate_zx_lines_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,

3026: --Notes:
3027: -- Used by calculate_tax procedure. Not to be used externally
3028: --End of Comments
3029: -----------------------------------------------------------------------------
3030: PROCEDURE populate_zx_lines_with_po(p_po_header_id_tbl IN PO_TBL_NUMBER,
3031: p_calling_program IN VARCHAR2
3032: ) IS
3033: BEGIN
3034:

Line 3294: zx_lines_det_factors zxldet, po_vendors pv,

3290: WHERE p_calling_program = 'PDOI'
3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id
3298: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO

Line 3335: END populate_zx_lines_with_po;

3331: --AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
3332: --AND nvl(pll.cancel_flag,'N') = 'N'
3333: --AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED';
3334:
3335: END populate_zx_lines_with_po;
3336:
3337:
3338: -----------------------------------------------------------------------------
3339: --Start of Comments

Line 3340: --Name: populate_zx_lines_with_rel

3336:
3337:
3338: -----------------------------------------------------------------------------
3339: --Start of Comments
3340: --Name: populate_zx_lines_with_rel
3341: --Pre-reqs:
3342: -- None
3343: --Modifies:
3344: -- ZX_TRANSACTION_LINES_GT

Line 3361: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,

3357: --Notes:
3358: -- Used by calculate_tax procedure. Not to be used externally
3359: --End of Comments
3360: -----------------------------------------------------------------------------
3361: PROCEDURE populate_zx_lines_with_rel(p_po_release_id_tbl IN PO_TBL_NUMBER,
3362: p_calling_program IN VARCHAR2
3363: ) IS
3364: BEGIN
3365: -- Populate zx_transaction_lines_gt for Releases

Line 3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON

3615: -- currently processed. Join with trx_line_id itself is unique
3616: -- because the document type has been classified with
3617: -- event_class_code and line_location_id will always be unique
3618: -- whether PO shipment or Release shipment
3619: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
3620: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
3621: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
3622: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
3623: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

Line 3652: END populate_zx_lines_with_rel;

3648: AND pr.po_release_id = p_po_release_id_tbl(i)
3649: AND ph.po_header_id = pr.po_header_id
3650: AND pl.po_line_id = pll.po_line_id;
3651:
3652: END populate_zx_lines_with_rel;
3653:
3654:
3655: -----------------------------------------------------------------------------
3656:

Line 3657: /* Bug 11665348 : Creating 2 new procedures populate_zx_lines_with_po_cal and

3653:
3654:
3655: -----------------------------------------------------------------------------
3656:
3657: /* Bug 11665348 : Creating 2 new procedures populate_zx_lines_with_po_cal and
3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.

Line 3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt

3654:
3655: -----------------------------------------------------------------------------
3656:
3657: /* Bug 11665348 : Creating 2 new procedures populate_zx_lines_with_po_cal and
3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.
3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all

Line 3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all

3658: populate_zx_lines_with_rel_cal which populates the data in zx_transaction_lines_gt
3659: only when the shipments is received or billed or shipped. This has been done for these
3660: shipments to skip the call to get_default_tax_attribs as per the EB Tax suggestion in bug
3661: 11665348 to fulfill requirement by PO PM team to retain the tax on received/billed shipments.
3662: These 2 procedures uses a join for zx_lines_det_factors and po_line_locations_all
3663: ON line_location_id instead of original_shipment_id as we need to pass value of
3664: input_tax_classification_code for receioved/billed PO shipments as per the suggestion
3665: of EB Tax team in bug 11711366
3666: */

Line 3670: --Name: populate_zx_lines_with_po_cal

3666: */
3667:
3668: -----------------------------------------------------------------------------
3669: --Start of Comments
3670: --Name: populate_zx_lines_with_po_cal
3671: --Pre-reqs:
3672: -- None
3673: --Modifies:
3674: -- ZX_TRANSACTION_LINES_GT

Line 3679: -- which are not already populated by populate_zx_lines_with_po

3675: --Locks:
3676: -- ZX_TRANSACTION_LINES_GT
3677: --Function:
3678: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
3679: -- which are not already populated by populate_zx_lines_with_po
3680: --Parameters:
3681: --IN:
3682: --p_po_header_id_tbl
3683: -- PL/SQL table with list of po_header_id's to process for tax_calculation

Line 3690: PROCEDURE populate_zx_lines_with_po_cal(p_po_header_id_tbl IN PO_TBL_NUMBER,

3686: --Notes:
3687: -- Used by calculate_tax procedure. Not to be used externally
3688: --End of Comments
3689: -----------------------------------------------------------------------------
3690: PROCEDURE populate_zx_lines_with_po_cal(p_po_header_id_tbl IN PO_TBL_NUMBER,
3691: p_calling_program IN VARCHAR2
3692: ) IS
3693: BEGIN
3694:

Line 3954: zx_lines_det_factors zxldet, po_vendors pv,

3950: WHERE p_calling_program = 'PDOI'
3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id
3958: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO

Line 3992: END populate_zx_lines_with_po_cal;

3988: --AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
3989: --AND nvl(pll.cancel_flag,'N') = 'N'
3990: --AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED';
3991:
3992: END populate_zx_lines_with_po_cal;
3993:
3994:
3995: -----------------------------------------------------------------------------
3996: --Start of Comments

Line 3997: --Name: populate_zx_lines_with_rel_cal

3993:
3994:
3995: -----------------------------------------------------------------------------
3996: --Start of Comments
3997: --Name: populate_zx_lines_with_rel_cal
3998: --Pre-reqs:
3999: -- None
4000: --Modifies:
4001: -- ZX_TRANSACTION_LINES_GT

Line 4006: -- which are not already populated by populate_zx_lines_with_rel.

4002: --Locks:
4003: -- ZX_TRANSACTION_LINES_GT
4004: --Function:
4005: -- Populate ZX_TRANSACTION_LINES_GT with transaction line and shipment data
4006: -- which are not already populated by populate_zx_lines_with_rel.
4007: --Parameters:
4008: --IN:
4009: --p_po_release_id_tbl
4010: -- PL/SQL table with list of po_release_id's to process for tax_calculation

Line 4017: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,

4013: --Notes:
4014: -- Used by calculate_tax procedure. Not to be used externally
4015: --End of Comments
4016: -----------------------------------------------------------------------------
4017: PROCEDURE populate_zx_lines_with_rel_cal(p_po_release_id_tbl IN PO_TBL_NUMBER,
4018: p_calling_program IN VARCHAR2
4019: ) IS
4020: BEGIN
4021: -- Populate zx_transaction_lines_gt for Releases

Line 4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON

4264: LEFT OUTER JOIN mtl_system_items_b msib
4265: ON (pl.item_id = msib.inventory_item_id
4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code

Line 4270: -- SCAN is performed on the table zx_lines_det_factors.

4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4269: -- Bug#12622509: The performance of the SQL is very bad, as FULL TABLE
4270: -- SCAN is performed on the table zx_lines_det_factors.
4271: (PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4272: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4273: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4274: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

Line 4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON

4280: -- currently processed. Join with trx_line_id itself is unique
4281: -- because the document type has been classified with
4282: -- event_class_code and line_location_id will always be unique
4283: -- whether PO shipment or Release shipment
4284: LEFT OUTER JOIN zx_lines_det_factors zxldet ON
4285: ((PO_CONSTANTS_SV.APPLICATION_ID = zxldet.application_id
4286: AND PO_CONSTANTS_SV.REL_ENTITY_CODE = zxldet.entity_code
4287: AND PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE = zxldet.event_class_code
4288: AND PO_CONSTANTS_SV.REL_TRX_LEVEL_TYPE = zxldet.trx_level_type

Line 4312: END populate_zx_lines_with_rel_cal;

4308: AND pr.po_release_id = p_po_release_id_tbl(i)
4309: AND ph.po_header_id = pr.po_header_id
4310: AND pl.po_line_id = pll.po_line_id;
4311:
4312: END populate_zx_lines_with_rel_cal;
4313:
4314:
4315: -----------------------------------------------------------------------------
4316: --End Bug 11665348

Line 4321: --Name: populate_zx_lines_with_req

4317:
4318: -----------------------------------------------------------------------------
4319:
4320: --Start of Comments
4321: --Name: populate_zx_lines_with_req
4322: --Pre-reqs:
4323: -- None
4324: --Modifies:
4325: -- ZX_TRANSACTION_LINES_GT

Line 4340: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,

4336: --Notes:
4337: -- Used by calculate_tax_requisition procedure. Not to be used externally
4338: --End of Comments
4339: -----------------------------------------------------------------------------
4340: PROCEDURE populate_zx_lines_with_req(p_requisition_header_id IN NUMBER,
4341: p_calling_program IN VARCHAR2
4342: ) IS
4343: l_functional_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4344: l_set_of_books_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%TYPE;

Line 4545: -- zx_lines_det_factors table.

4541: --Bug 5632300. Parameter to confirm that tax classification is overridden
4542:
4543: -- Bug 14155908: When the req split is done passing the user_upd_det_factors_flag
4544: -- to zx_transaction_lines_gt as that of the parent req line's value in
4545: -- zx_lines_det_factors table.
4546: ,Decode (p_calling_program,
4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111

Line 4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,

4547: 'REQUISITION_MODIFY', zxldet.user_upd_det_factors_flag,
4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
4552: mtl_system_items_b msib, fnd_currencies fc
4553: WHERE prh.requisition_header_id = p_requisition_header_id
4554: AND prh.requisition_header_id = prl.requisition_header_id
4555: -- Conditions for getting Additional Tax Attributes

Line 4581: END populate_zx_lines_with_req;

4577: AND nvl(prl.closed_code, 'OPEN') <> 'FINALLY CLOSED'
4578: AND prl.line_location_id IS NULL
4579: AND prl.at_sourcing_flag IS NULL;
4580:
4581: END populate_zx_lines_with_req;
4582:
4583:
4584: -----------------------------------------------------------------------------
4585: --Start of Comments

Line 5476: FROM zx_lines zl

5472: --into gt table even if there are multiple tax lines for each shipment
5473: FROM dual
5474: WHERE EXISTS
5475: (SELECT 'TAX LINES EXIST'
5476: FROM zx_lines zl
5477: -- Restrict to only rows that have corresponding tax lines
5478: -- Since this is called from OA, so conditions are only for SPO
5479: WHERE zl.trx_id = p_po_header_id
5480: AND zl.trx_line_id = p_del_shipment_table(i)

Line 6255: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;

6251: PROCEDURE log_line_tax_attributes(p_module_base IN VARCHAR2,
6252: p_progress IN NUMBER) IS
6253: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6254: d_progress NUMBER := p_progress;
6255: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
6256: l_zx_lines_tbl zx_lines_type;
6257: BEGIN
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:

Line 6256: l_zx_lines_tbl zx_lines_type;

6252: p_progress IN NUMBER) IS
6253: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
6254: d_progress NUMBER := p_progress;
6255: TYPE zx_lines_type IS TABLE OF ZX_TRANSACTION_LINES_GT%ROWTYPE;
6256: l_zx_lines_tbl zx_lines_type;
6257: BEGIN
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:
6260: SELECT *

Line 6261: BULK COLLECT INTO l_zx_lines_tbl

6257: BEGIN
6258: PO_LOG.stmt(d_module_base,d_progress,'Contents of zx_transaction_lines_gt:');
6259:
6260: SELECT *
6261: BULK COLLECT INTO l_zx_lines_tbl
6262: FROM zx_transaction_lines_gt;
6263:
6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');

Line 6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP

6260: SELECT *
6261: BULK COLLECT INTO l_zx_lines_tbl
6262: FROM zx_transaction_lines_gt;
6263:
6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);

Line 6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);

6262: FROM zx_transaction_lines_gt;
6263:
6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);

Line 6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);

6263:
6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);

Line 6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);

6264: FOR i IN 1..l_zx_lines_tbl.COUNT LOOP
6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);

Line 6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);

6265: PO_LOG.stmt(d_module_base,d_progress,' row '||i||':');
6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);

Line 6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);

6266: PO_LOG.stmt(d_module_base,d_progress,' application_id = '||l_zx_lines_tbl(i).application_id);
6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);

Line 6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);

6267: PO_LOG.stmt(d_module_base,d_progress,' entity_code = '||l_zx_lines_tbl(i).entity_code);
6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);

Line 6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);

6268: PO_LOG.stmt(d_module_base,d_progress,' event_class_code = '||l_zx_lines_tbl(i).event_class_code);
6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);

Line 6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);

6269: PO_LOG.stmt(d_module_base,d_progress,' trx_id = '||l_zx_lines_tbl(i).trx_id);
6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);

Line 6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);

6270: PO_LOG.stmt(d_module_base,d_progress,' trx_level_type = '||l_zx_lines_tbl(i).trx_level_type);
6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);

Line 6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);

6271: PO_LOG.stmt(d_module_base,d_progress,' trx_line_id = '||l_zx_lines_tbl(i).trx_line_id);
6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);

Line 6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);

6272: PO_LOG.stmt(d_module_base,d_progress,' line_level_action = '||l_zx_lines_tbl(i).line_level_action);
6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);

Line 6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);

6273: PO_LOG.stmt(d_module_base,d_progress,' line_class = '||l_zx_lines_tbl(i).line_class);
6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);

Line 6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);

6274: PO_LOG.stmt(d_module_base,d_progress,' trx_line_type = '||l_zx_lines_tbl(i).trx_line_type);
6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);

Line 6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);

6275: PO_LOG.stmt(d_module_base,d_progress,' trx_line_date = '||l_zx_lines_tbl(i).trx_line_date);
6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);

Line 6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);

6276: PO_LOG.stmt(d_module_base,d_progress,' trx_business_category = '||l_zx_lines_tbl(i).trx_business_category);
6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);

Line 6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);

6277: PO_LOG.stmt(d_module_base,d_progress,' line_intended_use = '||l_zx_lines_tbl(i).line_intended_use);
6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);

Line 6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);

6278: PO_LOG.stmt(d_module_base,d_progress,' user_defined_fisc_class = '||l_zx_lines_tbl(i).user_defined_fisc_class);
6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);

Line 6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);

6279: PO_LOG.stmt(d_module_base,d_progress,' line_amt = '||l_zx_lines_tbl(i).line_amt);
6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);

Line 6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);

6280: PO_LOG.stmt(d_module_base,d_progress,' trx_line_quantity = '||l_zx_lines_tbl(i).trx_line_quantity);
6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);

Line 6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);

6281: PO_LOG.stmt(d_module_base,d_progress,' product_id = '||l_zx_lines_tbl(i).product_id);
6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);

Line 6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);

6282: PO_LOG.stmt(d_module_base,d_progress,' product_fisc_classification = '||l_zx_lines_tbl(i).product_fisc_classification);
6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);

Line 6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);

6283: PO_LOG.stmt(d_module_base,d_progress,' uom_code = '||l_zx_lines_tbl(i).uom_code);
6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);

Line 6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);

6284: PO_LOG.stmt(d_module_base,d_progress,' product_type = '||l_zx_lines_tbl(i).product_type);
6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);

Line 6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);

6285: PO_LOG.stmt(d_module_base,d_progress,' product_code = '||l_zx_lines_tbl(i).product_code);
6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);

Line 6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);

6286: PO_LOG.stmt(d_module_base,d_progress,' product_category = '||l_zx_lines_tbl(i).product_category);
6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);

Line 6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);

6287: PO_LOG.stmt(d_module_base,d_progress,' fob_point = '||l_zx_lines_tbl(i).fob_point);
6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */

Line 6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);

6288: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_id = '||l_zx_lines_tbl(i).ship_from_party_id);
6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);

Line 6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);

6289: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_id = '||l_zx_lines_tbl(i).bill_from_party_id);
6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);

Line 6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);

6290: PO_LOG.stmt(d_module_base,d_progress,' ship_from_party_site_id = '||l_zx_lines_tbl(i).ship_from_party_site_id);
6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);

Line 6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */

6291: PO_LOG.stmt(d_module_base,d_progress,' bill_from_party_site_id = '||l_zx_lines_tbl(i).bill_from_party_site_id);
6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);

Line 6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);

6292: PO_LOG.stmt(d_module_base,d_progress,' ship_to_location_id = '||l_zx_lines_tbl(i).ship_to_location_id);
6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);

Line 6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);

6293: PO_LOG.stmt(d_module_base,d_progress,' ship_from_location_id = '||l_zx_lines_tbl(i).ship_from_location_id);
6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);

Line 6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);

6294: PO_LOG.stmt(d_module_base,d_progress,' bill_to_location_id = '||l_zx_lines_tbl(i).bill_to_location_id);
6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);

Line 6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);

6295: PO_LOG.stmt(d_module_base,d_progress,' bill_from_location_id = '||l_zx_lines_tbl(i).bill_from_location_id); /* 8752470 */
6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);

Line 6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);

6296: PO_LOG.stmt(d_module_base,d_progress,' account_ccid = '||l_zx_lines_tbl(i).account_ccid);
6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);

Line 6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);

6297: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_application_id = '||l_zx_lines_tbl(i).ref_doc_application_id);
6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);

Line 6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);

6298: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_entity_code = '||l_zx_lines_tbl(i).ref_doc_entity_code);
6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);

Line 6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);

6299: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_event_class_code = '||l_zx_lines_tbl(i).ref_doc_event_class_code);
6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);

Line 6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);

6300: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_id = '||l_zx_lines_tbl(i).ref_doc_trx_id);
6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);

Line 6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);

6301: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_line_id = '||l_zx_lines_tbl(i).ref_doc_line_id);
6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);

Line 6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);

6302: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key1 = '||l_zx_lines_tbl(i).line_trx_user_key1);
6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);

Line 6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);

6303: PO_LOG.stmt(d_module_base,d_progress,' line_trx_user_key2 = '||l_zx_lines_tbl(i).line_trx_user_key2);
6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);

Line 6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);

6304: PO_LOG.stmt(d_module_base,d_progress,' trx_line_number = '||l_zx_lines_tbl(i).trx_line_number);
6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);

Line 6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);

6305: PO_LOG.stmt(d_module_base,d_progress,' trx_line_description = '||l_zx_lines_tbl(i).trx_line_description);
6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);

Line 6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);

6306: PO_LOG.stmt(d_module_base,d_progress,' product_description = '||l_zx_lines_tbl(i).product_description);
6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);

Line 6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);

6307: PO_LOG.stmt(d_module_base,d_progress,' assessable_value = '||l_zx_lines_tbl(i).assessable_value);
6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);

Line 6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);

6308: PO_LOG.stmt(d_module_base,d_progress,' line_amt_includes_tax_flag = '||l_zx_lines_tbl(i).line_amt_includes_tax_flag);
6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);

Line 6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);

6309: PO_LOG.stmt(d_module_base,d_progress,' input_tax_classification_code = '||l_zx_lines_tbl(i).input_tax_classification_code);
6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);

Line 6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);

6310: PO_LOG.stmt(d_module_base,d_progress,' source_application_id = '||l_zx_lines_tbl(i).source_application_id);
6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);

Line 6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);

6311: PO_LOG.stmt(d_module_base,d_progress,' source_entity_code = '||l_zx_lines_tbl(i).source_entity_code);
6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);

Line 6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);

6312: PO_LOG.stmt(d_module_base,d_progress,' source_event_class_code = '||l_zx_lines_tbl(i).source_event_class_code);
6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);

Line 6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);

6313: PO_LOG.stmt(d_module_base,d_progress,' source_trx_id = '||l_zx_lines_tbl(i).source_trx_id);
6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);

Line 6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);

6314: PO_LOG.stmt(d_module_base,d_progress,' source_line_id = '||l_zx_lines_tbl(i).source_line_id);
6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);

Line 6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);

6315: PO_LOG.stmt(d_module_base,d_progress,' source_trx_level_type = '||l_zx_lines_tbl(i).source_trx_level_type);
6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);

Line 6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);

6316: PO_LOG.stmt(d_module_base,d_progress,' unit_price = '||l_zx_lines_tbl(i).unit_price);
6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);

Line 6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);

6317: PO_LOG.stmt(d_module_base,d_progress,' ref_doc_trx_level_type = '||l_zx_lines_tbl(i).ref_doc_trx_level_type);
6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);

Line 6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);

6318: PO_LOG.stmt(d_module_base,d_progress,' product_org_id = '||l_zx_lines_tbl(i).product_org_id);
6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);

Line 6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);

6319: PO_LOG.stmt(d_module_base,d_progress,' ship_to_party_id = '||l_zx_lines_tbl(i).ship_to_party_id);
6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);
6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);

Line 6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);

6320: PO_LOG.stmt(d_module_base,d_progress,' bill_to_party_id = '||l_zx_lines_tbl(i).bill_to_party_id);
6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);
6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);
6328: END LOOP;

Line 6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);

6321: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_code = '||l_zx_lines_tbl(i).trx_line_currency_code);
6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);
6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);
6328: END LOOP;
6329: EXCEPTION

Line 6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);

6322: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_date = '||l_zx_lines_tbl(i).trx_line_currency_conv_date);
6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);
6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);
6328: END LOOP;
6329: EXCEPTION
6330: WHEN OTHERS THEN

Line 6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);

6323: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_rate = '||l_zx_lines_tbl(i).trx_line_currency_conv_rate);
6324: PO_LOG.stmt(d_module_base,d_progress,' trx_line_currency_conv_type = '||l_zx_lines_tbl(i).trx_line_currency_conv_type);
6325: PO_LOG.stmt(d_module_base,d_progress,' trx_line_mau = '||l_zx_lines_tbl(i).trx_line_mau);
6326: PO_LOG.stmt(d_module_base,d_progress,' trx_line_precision = '||l_zx_lines_tbl(i).trx_line_precision);
6327: PO_LOG.stmt(d_module_base,d_progress,' user_upd_det_factors_flag = '||l_zx_lines_tbl(i).user_upd_det_factors_flag);
6328: END LOOP;
6329: EXCEPTION
6330: WHEN OTHERS THEN
6331: PO_LOG.stmt(d_module_base,d_progress,'Failure while writing log '||SQLCODE||SQLERRM);