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_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_PDOI_PARAMS

Line 180: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_CAT_ADMIN

176: -- set all lines to notified if:
177: -- 1. user role is CAT ADMIN and
178: -- 2. document type is LBPA/QTN and
179: -- 3. the line's current status is not notified
180: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_CAT_ADMIN
181: AND
182: ((PO_PDOI_PARAMS.g_request.document_type =
183: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET -- blanket
184: AND

Line 182: ((PO_PDOI_PARAMS.g_request.document_type =

178: -- 2. document type is LBPA/QTN and
179: -- 3. the line's current status is not notified
180: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_CAT_ADMIN
181: AND
182: ((PO_PDOI_PARAMS.g_request.document_type =
183: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET -- blanket
184: AND
185: ( x_lines.rec_count > 0 AND
186: NVL(x_lines.hd_global_agreement_flag_tbl(1), 'N') = 'N')) -- local

Line 188: PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION

184: AND
185: ( x_lines.rec_count > 0 AND
186: NVL(x_lines.hd_global_agreement_flag_tbl(1), 'N') = 'N')) -- local
187: OR
188: PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION
189: )
190: AND
191: (PO_PDOI_PARAMS.g_request.process_code <>
192: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED)

Line 191: (PO_PDOI_PARAMS.g_request.process_code <>

187: OR
188: PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION
189: )
190: AND
191: (PO_PDOI_PARAMS.g_request.process_code <>
192: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED)
193: ) THEN
194: d_position := 20;
195:

Line 213: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;

209: END IF;
210: END LOOP;
211:
212: -- set status on header level for notified lines
213: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;
214: ELSE
215: d_position := 30;
216:
217: -- populate value of has_lines_updated in g_doc_info for each document

Line 222: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';

218: FOR i IN 1..x_lines.rec_count
219: LOOP
220: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
221: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
222: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
223: END IF;
224: END LOOP;
225:
226: END IF;

Line 479: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

475: mtl_system_items items
476: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
477: AND draft_lines.draft_id = l_draft_id_tbl(i)
478: AND draft_lines.item_id = items.inventory_item_id(+)
479: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
480:
481: d_position := 30;
482:
483: DELETE FROM po_session_gt

Line 641: IF (NVL(PO_PDOI_PARAMS.g_request.create_items, 'N') = 'Y' AND

637: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));
638: END IF;
639:
640: -- update description in item master
641: IF (NVL(PO_PDOI_PARAMS.g_request.create_items, 'N') = 'Y' AND
642: x_lines.item_id_tbl(i) IS NOT NULL) THEN
643: l_update_item_queue(i) := i;
644: END IF;
645:

Line 668: PO_PDOI_PARAMS.g_request.process_code);

664: x_lines.unit_price_tbl(i));
665: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
666: l_unit_price_tbl(l_index));
667: PO_LOG.stmt(d_module, d_position, 'process_code in request',
668: PO_PDOI_PARAMS.g_request.process_code);
669: PO_LOG.stmt(d_module, d_position, 'role in request',
670: PO_PDOI_PARAMS.g_request.role);
671: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
672: x_lines.hd_global_agreement_flag_tbl(i));

Line 670: PO_PDOI_PARAMS.g_request.role);

666: l_unit_price_tbl(l_index));
667: PO_LOG.stmt(d_module, d_position, 'process_code in request',
668: PO_PDOI_PARAMS.g_request.process_code);
669: PO_LOG.stmt(d_module, d_position, 'role in request',
670: PO_PDOI_PARAMS.g_request.role);
671: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
672: x_lines.hd_global_agreement_flag_tbl(i));
673: PO_LOG.stmt(d_module, d_position, 'uom_different',
674: l_uom_different);

Line 682: IF (PO_PDOI_PARAMS.g_request.process_code <>

678:
679: -- bug5149827
680: -- If original intf line id exists, automatically set exceed tolerance
681: -- to true so that it goes through price tolerance check
682: IF (PO_PDOI_PARAMS.g_request.process_code <>
683: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
684: AND
685: l_orig_intf_line_id_tbl(l_index) IS NOT NULL) THEN
686: IF (PO_LOG.d_stmt) THEN

Line 700: IF (PO_PDOI_PARAMS.g_request.process_code <>

696: x_lines.unit_price_tbl(i) <> NVL(l_unit_price_tbl(l_index), -1)) THEN
697:
698: IF (x_lines.unit_price_tbl(i) <> PO_PDOI_CONSTANTS.g_NULLIFY_NUM) THEN
699: -- only check tolerance when previous status is not NOTIFIED
700: IF (PO_PDOI_PARAMS.g_request.process_code <>
701: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
702:
703: -- bug5149827
704: -- If original interface line id is there, then the line

Line 711: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER

707: -- do not check the price tolerance when
708: -- 1. user role is CAT ADMIN/SUPPLIER and
709: -- 2. document type is GBPA
710:
711: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
712: OR
713: NOT
714: (PO_PDOI_PARAMS.g_request.document_type =
715: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET

Line 714: (PO_PDOI_PARAMS.g_request.document_type =

710:
711: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
712: OR
713: NOT
714: (PO_PDOI_PARAMS.g_request.document_type =
715: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
716: AND
717: NVL(x_lines.hd_global_agreement_flag_tbl(i), 'N') = 'Y')) THEN
718:

Line 750: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

746: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
747: -- When we update an existing blanket with a new unit_price,
748: -- retroactive_date in po_lines must be updated with the timestamp.
749: -- This has to be done for non-cumulative blanket lines only.
750: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
751: NVL(l_price_break_lookup_code_tbl(l_index), 'NON CUMULATIVE') = 'NON CUMULATIVE') THEN
752: l_retroactive_date_tbl(l_index) := sysdate;
753: END IF;
754:

Line 792: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_to_notify := FND_API.g_TRUE;

788: -- set process_code to be 'NOTIFIED' for this line;
789: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
790:
791: -- set status on header level for notified lines
792: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_to_notify := FND_API.g_TRUE;
793:
794: END IF; -- l_exceed_tolerance = true
795:
796: -- check check expiration_date

Line 800: IF (PO_PDOI_PARAMS.g_request.document_type =

796: -- check check expiration_date
797: -- do the following update only when price does not exceed tolerance
798: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
799: -- If the new value is '#DEL', we null out the expiration_date
800: IF (PO_PDOI_PARAMS.g_request.document_type =
801: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
802: x_lines.expiration_date_tbl(i) IS NOT NULL) THEN
803: IF (x_lines.expiration_date_tbl(i) =
804: PO_PDOI_CONSTANTS.g_NULLIFY_DATE) THEN

Line 844: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

840: PO_LOG.stmt(d_module, d_position, 'l_precision', l_precision);
841: END IF;
842:
843: -- retroactive_date reset to sysdate since price is changed
844: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
845: NVL(l_price_break_lookup_code_tbl(l_index), 'NON CUMULATIVE') = 'NON CUMULATIVE') THEN
846: l_retroactive_date_tbl(l_index) := sysdate;
847: END IF;
848:

Line 959: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';

955: d_position := 250;
956:
957: -- set has_lines_updated flag in g_docs_info
958: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
959: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
960:
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'line updated for document',
963: x_lines.intf_header_id_tbl(i));

Line 993: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,

989: p_init_msg_list => FND_API.g_TRUE,
990: p_commit => FND_API.g_TRUE,
991: p_Transaction_Type => 'UPDATE',
992: p_Inventory_Item_Id => x_lines.item_id_tbl(l_index),
993: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
994: p_description => NVL(x_lines.item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),
995: p_Item_Number => x_lines.item_tbl(l_index),
996: x_Inventory_Item_Id => l_inventory_item_id,
997: x_Organization_Id => l_organization_id,

Line 1073: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;

1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,
1071: program_update_date = sysdate
1072: WHERE inventory_item_id = l_update_item_id_tbl(i)
1073: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1074:
1075: d_position := 280;
1076:
1077: FORALL i IN 1..l_update_item_id_tbl.COUNT

Line 1081: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id

1077: FORALL i IN 1..l_update_item_id_tbl.COUNT
1078: UPDATE mtl_system_items_tl
1079: SET description = l_update_item_desc_tbl(i)
1080: WHERE inventory_item_id = l_update_item_id_tbl(i)
1081: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id
1082: AND language = USERENV('LANG');
1083: */
1084:
1085: d_position := 280;

Line 1131: IF (PO_PDOI_PARAMS.g_request.document_type =

1127: WHERE key = l_key
1128: RETURNING num1, num2, char1 BULK COLLECT INTO
1129: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1130:
1131: IF (PO_PDOI_PARAMS.g_request.document_type =
1132: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1133: -- read lines into draft, the actual update of price discount
1134: -- happens when we process the line locations
1135: FOR i IN 1..l_change_loc_id_tbl.COUNT

Line 1327: IF (PO_PDOI_PARAMS.g_request.document_type =

1323: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1324:
1325: /*
1326: -- delete existing price breaks for Quotation if new price breaks are added
1327: IF (PO_PDOI_PARAMS.g_request.document_type =
1328: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1329: d_position := 10;
1330:
1331: -- get existing line_location_ids

Line 1901: PO_PDOI_PARAMS.g_request.org_id,

1897: tax_attribute_update_code
1898: )
1899: SELECT
1900: p_headers.draft_id_tbl(i),
1901: PO_PDOI_PARAMS.g_request.org_id,
1902: NULL, -- delete_flag
1903: NULL, -- change_accepted_flag
1904: p_headers.po_header_id_tbl(i),
1905: p_headers.agent_id_tbl(i),

Line 2057: IF (PO_PDOI_PARAMS.g_request.document_type =

2053: IF (PO_LOG.d_proc) THEN
2054: PO_LOG.proc_begin(d_module);
2055: END IF;
2056:
2057: IF (PO_PDOI_PARAMS.g_request.document_type =
2058: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
2059: FORALL i IN 1..p_headers.rec_count
2060: INSERT INTO po_ga_org_assign_draft
2061: (

Line 2082: PO_PDOI_PARAMS.g_request.org_id,

2078: p_headers.draft_id_tbl(i),
2079: NULL, -- delete_flag,
2080: NULL, -- change_accepted_flag,
2081: p_headers.po_header_id_tbl(i),
2082: PO_PDOI_PARAMS.g_request.org_id,
2083: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2084: p_headers.vendor_site_id_tbl(i),
2085: PO_PDOI_PARAMS.g_request.org_id,
2086: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,

Line 2083: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),

2079: NULL, -- delete_flag,
2080: NULL, -- change_accepted_flag,
2081: p_headers.po_header_id_tbl(i),
2082: PO_PDOI_PARAMS.g_request.org_id,
2083: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2084: p_headers.vendor_site_id_tbl(i),
2085: PO_PDOI_PARAMS.g_request.org_id,
2086: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,
2087: p_headers.last_update_date_tbl(i),

Line 2085: PO_PDOI_PARAMS.g_request.org_id,

2081: p_headers.po_header_id_tbl(i),
2082: PO_PDOI_PARAMS.g_request.org_id,
2083: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2084: p_headers.vendor_site_id_tbl(i),
2085: PO_PDOI_PARAMS.g_request.org_id,
2086: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,
2087: p_headers.last_update_date_tbl(i),
2088: p_headers.last_updated_by_tbl(i),
2089: p_headers.last_update_login_tbl(i),

Line 2096: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';

2092: FROM po_headers_interface
2093: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2094: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2095: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2096: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';
2097: END IF;
2098:
2099: IF (PO_LOG.d_proc) THEN
2100: PO_LOG.proc_end (d_module);

Line 2155: IF (PO_PDOI_PARAMS.g_request.document_type =

2151: PO_LOG.proc_begin(d_module);
2152: END IF;
2153:
2154: -- add distribution row from po_headers_interface table
2155: IF (PO_PDOI_PARAMS.g_request.document_type =
2156: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2157: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2159: d_position := 10;

Line 2157: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND

2153:
2154: -- add distribution row from po_headers_interface table
2155: IF (PO_PDOI_PARAMS.g_request.document_type =
2156: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2157: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2159: d_position := 10;
2160:
2161: FORALL i IN 1.. p_headers.rec_count

Line 2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN

2154: -- add distribution row from po_headers_interface table
2155: IF (PO_PDOI_PARAMS.g_request.document_type =
2156: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2157: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2159: d_position := 10;
2160:
2161: FORALL i IN 1.. p_headers.rec_count
2162: INSERT INTO po_distributions_draft_all

Line 2192: PO_PDOI_PARAMS.g_request.org_id,

2188: program_update_date
2189: )
2190: SELECT
2191: p_headers.draft_id_tbl(i),
2192: PO_PDOI_PARAMS.g_request.org_id,
2193: NULL, -- delete_flag,
2194: NULL, -- change_accepted_flag,
2195: p_headers.po_dist_id_tbl(i),
2196: p_headers.po_header_id_tbl(i),

Line 2198: PO_PDOI_PARAMS.g_sys.sob_id,

2194: NULL, -- change_accepted_flag,
2195: p_headers.po_dist_id_tbl(i),
2196: p_headers.po_header_id_tbl(i),
2197: 1, -- distribution_num
2198: PO_PDOI_PARAMS.g_sys.sob_id,
2199: p_headers.rate_date_tbl(i),
2200: p_headers.rate_tbl(i),
2201: p_headers.gl_encumbered_date_tbl(i),
2202: p_headers.gl_encumbered_period_tbl(i),

Line 2391: PO_PDOI_PARAMS.g_request.org_id,

2387: tax_attribute_update_code
2388: )
2389: SELECT
2390: p_dists.draft_id_tbl(i),
2391: PO_PDOI_PARAMS.g_request.org_id,
2392: NULL, -- delete_flag,
2393: NULL, -- change_accepted_flag,
2394: p_dists.po_dist_id_tbl(i),
2395: p_dists.last_update_date_tbl(i),

Line 2400: PO_PDOI_PARAMS.g_sys.sob_id,

2396: p_dists.last_updated_by_tbl(i),
2397: p_dists.hd_po_header_id_tbl(i),
2398: p_dists.ln_po_line_id_tbl(i),
2399: p_dists.loc_line_loc_id_tbl(i),
2400: PO_PDOI_PARAMS.g_sys.sob_id,
2401: p_dists.charge_account_id_tbl(i),
2402: p_dists.quantity_ordered_tbl(i),
2403: p_dists.last_update_login_tbl(i),
2404: p_dists.creation_date_tbl(i),

Line 2654: PO_PDOI_PARAMS.g_request.org_id,

2650: original_interface_line_id -- bug5149827
2651: )
2652: SELECT
2653: p_lines.draft_id_tbl(i),
2654: PO_PDOI_PARAMS.g_request.org_id,
2655: NULL, -- delete_flag,
2656: DECODE (p_lines.process_code_tbl(i),
2657: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
2658: PO_DRAFTS_PVT.g_chg_accepted_flag_NOTIFY,

Line 2741: DECODE(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

2737: p_lines.job_id_tbl(i),
2738: p_lines.contractor_first_name_tbl(i),
2739: p_lines.contractor_last_name_tbl(i),
2740: p_lines.amount_tbl(i),
2741: DECODE(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
2742: DECODE(p_lines.purchase_basis_tbl(i), 'TEMP LABOR', TRUNC(p_lines.effective_date_tbl(i)), NULL),
2743: NULL), -- bug 4181354
2744: p_lines.order_type_lookup_code_tbl(i),
2745: p_lines.purchase_basis_tbl(i),

Line 2936: PO_PDOI_PARAMS.g_request.org_id,

2932: matching_basis
2933: )
2934: SELECT
2935: p_line_locs.draft_id_tbl(i),
2936: PO_PDOI_PARAMS.g_request.org_id,
2937: NULL, -- delete_flag,
2938: NULL, -- change_accepted_flag,
2939: p_line_locs.line_loc_id_tbl(i),
2940: p_line_locs.last_update_date_tbl(i),

Line 4204: PO_PDOI_PARAMS.g_request.org_id,

4200: '-2', -- REQ_TEMPLATE_NAME
4201: -2, --REQ_TEMPLATE_LINE_NUM
4202: NVL(PAVI.IP_CATEGORY_ID, -2),
4203: NVL(PAVI.INVENTORY_ITEM_ID, -2),
4204: PO_PDOI_PARAMS.g_request.org_id,
4205: DECODE(PAVI.MANUFACTURER_PART_NUM, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.MANUFACTURER_PART_NUM),
4206: DECODE(PAVI.THUMBNAIL_IMAGE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.THUMBNAIL_IMAGE),
4207: DECODE(PAVI.SUPPLIER_URL, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.SUPPLIER_URL),
4208: DECODE(PAVI.MANUFACTURER_URL, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.MANUFACTURER_URL),

Line 5118: PO_PDOI_PARAMS.g_request.org_id,

5114: '-2', -- REQ_TEMPLATE_NAME
5115: -2, -- REQ_TEMPLATE_LINE_NUM
5116: NVL(PAVTI.IP_CATEGORY_ID, -2),
5117: NVL(PAVTI.INVENTORY_ITEM_ID, -2),
5118: PO_PDOI_PARAMS.g_request.org_id,
5119: PAVTI.LANGUAGE,
5120: NVL(PAVTI.DESCRIPTION, PAVTI.LINE_DESCRIPTION),
5121: DECODE(PAVTI.MANUFACTURER, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.MANUFACTURER),
5122: DECODE(PAVTI.COMMENTS, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.COMMENTS),