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 212: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;

208: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
209:
210: --Bug 13906472 fix. Header level attribute has_lines_to_notify flag should be set to TRUE when the lines are notified.
211: -- set status on header level for notified lines
212: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;
213: END IF;
214: END LOOP;
215:
216:

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

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

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

498: mtl_system_items items
499: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
500: AND draft_lines.draft_id = l_draft_id_tbl(i)
501: AND draft_lines.item_id = items.inventory_item_id(+)
502: AND items.organization_id(+) = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
503:
504: d_position := 30;
505:
506: DELETE FROM po_session_gt

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

682: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));
683: END IF;
684:
685: -- update description in item master
686: IF (NVL(PO_PDOI_PARAMS.g_request.create_items, 'N') = 'Y' AND
687: x_lines.item_id_tbl(i) IS NOT NULL) THEN
688: l_update_item_queue(i) := i;
689: END IF;
690:

Line 713: PO_PDOI_PARAMS.g_request.process_code);

709: x_lines.unit_price_tbl(i));
710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));

Line 715: PO_PDOI_PARAMS.g_request.role);

711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));
718: PO_LOG.stmt(d_module, d_position, 'uom_different',
719: l_uom_different);

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

723:
724: -- bug5149827
725: -- If original intf line id exists, automatically set exceed tolerance
726: -- to true so that it goes through price tolerance check
727: IF (PO_PDOI_PARAMS.g_request.process_code <>
728: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
729: AND
730: l_orig_intf_line_id_tbl(l_index) IS NOT NULL) THEN
731: IF (PO_LOG.d_stmt) THEN

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

741: x_lines.unit_price_tbl(i) <> NVL(l_unit_price_tbl(l_index), -1)) THEN
742:
743: IF (x_lines.unit_price_tbl(i) <> PO_PDOI_CONSTANTS.g_NULLIFY_NUM) THEN
744: -- only check tolerance when previous status is not NOTIFIED
745: IF (PO_PDOI_PARAMS.g_request.process_code <>
746: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
747:
748: -- bug5149827
749: -- If original interface line id is there, then the line

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

752: -- do not check the price tolerance when
753: -- 1. user role is CAT ADMIN/SUPPLIER and
754: -- 2. document type is GBPA
755:
756: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
757: OR
758: NOT
759: (PO_PDOI_PARAMS.g_request.document_type =
760: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET

Line 759: (PO_PDOI_PARAMS.g_request.document_type =

755:
756: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
757: OR
758: NOT
759: (PO_PDOI_PARAMS.g_request.document_type =
760: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
761: AND
762: NVL(x_lines.hd_global_agreement_flag_tbl(i), 'N') = 'Y')) THEN
763:

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

791: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
792: -- When we update an existing blanket with a new unit_price,
793: -- retroactive_date in po_lines must be updated with the timestamp.
794: -- This has to be done for non-cumulative blanket lines only.
795: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
796: NVL(l_price_break_lookup_code_tbl(l_index), 'NON CUMULATIVE') = 'NON CUMULATIVE') THEN
797: l_retroactive_date_tbl(l_index) := sysdate;
798: END IF;
799:

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

833: -- set process_code to be 'NOTIFIED' for this line;
834: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
835:
836: -- set status on header level for notified lines
837: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_to_notify := FND_API.g_TRUE;
838:
839: END IF; -- l_exceed_tolerance = true
840:
841: -- check check expiration_date

Line 845: IF (PO_PDOI_PARAMS.g_request.document_type IN (

841: -- check check expiration_date
842: -- do the following update only when price does not exceed tolerance
843: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
844: -- If the new value is '#DEL', we null out the expiration_date
845: IF (PO_PDOI_PARAMS.g_request.document_type IN (
846: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) AND --bug10132621
847: x_lines.expiration_date_tbl(i) IS NOT NULL) THEN
848: IF (x_lines.expiration_date_tbl(i) =
849: PO_PDOI_CONSTANTS.g_NULLIFY_DATE) THEN

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

885: PO_LOG.stmt(d_module, d_position, 'l_precision', l_precision);
886: END IF;
887:
888: -- retroactive_date reset to sysdate since price is changed
889: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
890: NVL(l_price_break_lookup_code_tbl(l_index), 'NON CUMULATIVE') = 'NON CUMULATIVE') THEN
891: l_retroactive_date_tbl(l_index) := sysdate;
892: END IF;
893:

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

1046: d_position := 250;
1047:
1048: -- set has_lines_updated flag in g_docs_info
1049: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
1050: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
1051:
1052: IF (PO_LOG.d_stmt) THEN
1053: PO_LOG.stmt(d_module, d_position, 'line updated for document',
1054: x_lines.intf_header_id_tbl(i));

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

1080: p_init_msg_list => FND_API.g_TRUE,
1081: p_commit => FND_API.g_TRUE,
1082: p_Transaction_Type => 'UPDATE',
1083: p_Inventory_Item_Id => x_lines.item_id_tbl(l_index),
1084: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1085: p_description => NVL(x_lines.item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),
1086: p_Item_Number => x_lines.item_tbl(l_index),
1087: x_Inventory_Item_Id => l_inventory_item_id,
1088: x_Organization_Id => l_organization_id,

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

1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,
1162: program_update_date = sysdate
1163: WHERE inventory_item_id = l_update_item_id_tbl(i)
1164: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1165:
1166: d_position := 280;
1167:
1168: FORALL i IN 1..l_update_item_id_tbl.COUNT

Line 1172: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id

1168: FORALL i IN 1..l_update_item_id_tbl.COUNT
1169: UPDATE mtl_system_items_tl
1170: SET description = l_update_item_desc_tbl(i)
1171: WHERE inventory_item_id = l_update_item_id_tbl(i)
1172: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id
1173: AND language = USERENV('LANG');
1174: */
1175:
1176: d_position := 280;

Line 1226: IF (PO_PDOI_PARAMS.g_request.document_type =

1222: WHERE key = l_key
1223: RETURNING num1, num2, char1 BULK COLLECT INTO
1224: l_change_loc_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;
1225:
1226: IF (PO_PDOI_PARAMS.g_request.document_type =
1227: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
1228: -- read lines into draft, the actual update of price discount
1229: -- happens when we process the line locations
1230: FOR i IN 1..l_change_loc_id_tbl.COUNT

Line 1521: IF (PO_PDOI_PARAMS.g_request.document_type =

1517: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1518:
1519: /*
1520: -- delete existing price breaks for Quotation if new price breaks are added
1521: IF (PO_PDOI_PARAMS.g_request.document_type =
1522: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1523: d_position := 10;
1524:
1525: -- get existing line_location_ids

Line 2117: PO_PDOI_PARAMS.g_request.org_id,

2113: clm_contract_officer
2114: )
2115: SELECT
2116: p_headers.draft_id_tbl(i),
2117: PO_PDOI_PARAMS.g_request.org_id,
2118: NULL, -- delete_flag
2119: NULL, -- change_accepted_flag
2120: p_headers.po_header_id_tbl(i),
2121: p_headers.agent_id_tbl(i),

Line 2293: IF (PO_PDOI_PARAMS.g_request.document_type =

2289: IF (PO_LOG.d_proc) THEN
2290: PO_LOG.proc_begin(d_module);
2291: END IF;
2292:
2293: IF (PO_PDOI_PARAMS.g_request.document_type =
2294: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
2295: FORALL i IN 1..p_headers.rec_count
2296: INSERT INTO po_ga_org_assign_draft
2297: (

Line 2318: PO_PDOI_PARAMS.g_request.org_id,

2314: p_headers.draft_id_tbl(i),
2315: NULL, -- delete_flag,
2316: NULL, -- change_accepted_flag,
2317: p_headers.po_header_id_tbl(i),
2318: PO_PDOI_PARAMS.g_request.org_id,
2319: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2320: p_headers.vendor_site_id_tbl(i),
2321: PO_PDOI_PARAMS.g_request.org_id,
2322: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,

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

2315: NULL, -- delete_flag,
2316: NULL, -- change_accepted_flag,
2317: p_headers.po_header_id_tbl(i),
2318: PO_PDOI_PARAMS.g_request.org_id,
2319: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2320: p_headers.vendor_site_id_tbl(i),
2321: PO_PDOI_PARAMS.g_request.org_id,
2322: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,
2323: p_headers.last_update_date_tbl(i),

Line 2321: PO_PDOI_PARAMS.g_request.org_id,

2317: p_headers.po_header_id_tbl(i),
2318: PO_PDOI_PARAMS.g_request.org_id,
2319: NVL(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag),
2320: p_headers.vendor_site_id_tbl(i),
2321: PO_PDOI_PARAMS.g_request.org_id,
2322: PO_GA_ORG_ASSIGNMENTS_S.nextval, -- org_assignment_id,
2323: p_headers.last_update_date_tbl(i),
2324: p_headers.last_updated_by_tbl(i),
2325: p_headers.last_update_login_tbl(i),

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

2328: FROM po_headers_interface
2329: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2330: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2331: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2332: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_end (d_module);

Line 2391: IF (PO_PDOI_PARAMS.g_request.document_type =

2387: PO_LOG.proc_begin(d_module);
2388: END IF;
2389:
2390: -- add distribution row from po_headers_interface table
2391: IF (PO_PDOI_PARAMS.g_request.document_type =
2392: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2393: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2394: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2395: d_position := 10;

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

2389:
2390: -- add distribution row from po_headers_interface table
2391: IF (PO_PDOI_PARAMS.g_request.document_type =
2392: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2393: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2394: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2395: d_position := 10;
2396:
2397: FORALL i IN 1.. p_headers.rec_count

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

2390: -- add distribution row from po_headers_interface table
2391: IF (PO_PDOI_PARAMS.g_request.document_type =
2392: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2393: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2394: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2395: d_position := 10;
2396:
2397: FORALL i IN 1.. p_headers.rec_count
2398: INSERT INTO po_distributions_draft_all

Line 2428: PO_PDOI_PARAMS.g_request.org_id,

2424: program_update_date
2425: )
2426: SELECT
2427: p_headers.draft_id_tbl(i),
2428: PO_PDOI_PARAMS.g_request.org_id,
2429: NULL, -- delete_flag,
2430: NULL, -- change_accepted_flag,
2431: p_headers.po_dist_id_tbl(i),
2432: p_headers.po_header_id_tbl(i),

Line 2434: PO_PDOI_PARAMS.g_sys.sob_id,

2430: NULL, -- change_accepted_flag,
2431: p_headers.po_dist_id_tbl(i),
2432: p_headers.po_header_id_tbl(i),
2433: 1, -- distribution_num
2434: PO_PDOI_PARAMS.g_sys.sob_id,
2435: p_headers.rate_date_tbl(i),
2436: p_headers.rate_tbl(i),
2437: p_headers.gl_encumbered_date_tbl(i),
2438: p_headers.gl_encumbered_period_tbl(i),

Line 2638: PO_PDOI_PARAMS.g_request.org_id,

2634: clm_misc_loa
2635: )
2636: SELECT
2637: p_dists.draft_id_tbl(i),
2638: PO_PDOI_PARAMS.g_request.org_id,
2639: NULL, -- delete_flag,
2640: NULL, -- change_accepted_flag,
2641: p_dists.po_dist_id_tbl(i),
2642: p_dists.last_update_date_tbl(i),

Line 2647: PO_PDOI_PARAMS.g_sys.sob_id,

2643: p_dists.last_updated_by_tbl(i),
2644: p_dists.hd_po_header_id_tbl(i),
2645: p_dists.ln_po_line_id_tbl(i),
2646: p_dists.loc_line_loc_id_tbl(i),
2647: PO_PDOI_PARAMS.g_sys.sob_id,
2648: p_dists.charge_account_id_tbl(i),
2649: p_dists.quantity_ordered_tbl(i),
2650: p_dists.last_update_login_tbl(i),
2651: p_dists.creation_date_tbl(i),

Line 2947: PO_PDOI_PARAMS.g_request.org_id,

2943: --clm_period_perf_start_date
2944: )
2945: SELECT
2946: p_lines.draft_id_tbl(i),
2947: PO_PDOI_PARAMS.g_request.org_id,
2948: NULL, -- delete_flag,
2949: DECODE (p_lines.process_code_tbl(i),
2950: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
2951: PO_DRAFTS_PVT.g_chg_accepted_flag_NOTIFY,

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

3030: p_lines.job_id_tbl(i),
3031: p_lines.contractor_first_name_tbl(i),
3032: p_lines.contractor_last_name_tbl(i),
3033: p_lines.amount_tbl(i),
3034: DECODE(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3035: DECODE(p_lines.purchase_basis_tbl(i), 'TEMP LABOR', TRUNC(p_lines.effective_date_tbl(i)), NULL),
3036: NULL), -- bug 4181354
3037: p_lines.order_type_lookup_code_tbl(i),
3038: p_lines.purchase_basis_tbl(i),

Line 3268: PO_PDOI_PARAMS.g_request.org_id,

3264: description -- PDOI for Complex PO Project
3265: )
3266: SELECT
3267: p_line_locs.draft_id_tbl(i),
3268: PO_PDOI_PARAMS.g_request.org_id,
3269: NULL, -- delete_flag,
3270: NULL, -- change_accepted_flag,
3271: p_line_locs.line_loc_id_tbl(i),
3272: p_line_locs.last_update_date_tbl(i),

Line 4544: PO_PDOI_PARAMS.g_request.org_id,

4540: '-2', -- REQ_TEMPLATE_NAME
4541: -2, --REQ_TEMPLATE_LINE_NUM
4542: NVL(PAVI.IP_CATEGORY_ID, -2),
4543: NVL(PAVI.INVENTORY_ITEM_ID, -2),
4544: PO_PDOI_PARAMS.g_request.org_id,
4545: DECODE(PAVI.MANUFACTURER_PART_NUM, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.MANUFACTURER_PART_NUM),
4546: DECODE(PAVI.THUMBNAIL_IMAGE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.THUMBNAIL_IMAGE),
4547: DECODE(PAVI.SUPPLIER_URL, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.SUPPLIER_URL),
4548: DECODE(PAVI.MANUFACTURER_URL, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.MANUFACTURER_URL),

Line 5458: PO_PDOI_PARAMS.g_request.org_id,

5454: '-2', -- REQ_TEMPLATE_NAME
5455: -2, -- REQ_TEMPLATE_LINE_NUM
5456: NVL(PAVTI.IP_CATEGORY_ID, -2),
5457: NVL(PAVTI.INVENTORY_ITEM_ID, -2),
5458: PO_PDOI_PARAMS.g_request.org_id,
5459: PAVTI.LANGUAGE,
5460: NVL(PAVTI.DESCRIPTION, PAVTI.LINE_DESCRIPTION),
5461: DECODE(PAVTI.MANUFACTURER, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.MANUFACTURER),
5462: DECODE(PAVTI.COMMENTS, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.COMMENTS),