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_VAL_LINES2 dependencies on PO_TBL_NUMBER

Line 73: p_id_tbl IN po_tbl_number,

69: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
70: -- This method is called only for Standard PO and quotation documents
71: -------------------------------------------------------------------------
72: PROCEDURE over_tolerance_err_flag(
73: p_id_tbl IN po_tbl_number,
74: p_over_tolerance_err_flag_tbl IN po_tbl_varchar30,
75: x_result_set_id IN OUT NOCOPY NUMBER,
76: x_result_type OUT NOCOPY VARCHAR2)
77: IS

Line 146: p_id_tbl IN po_tbl_number,

142: -- Expiration date on the line cannot be earlier than the header effective start date and
143: -- cannot be later than header effective end date
144: -------------------------------------------------------------------------
145: PROCEDURE expiration_date_blanket(
146: p_id_tbl IN po_tbl_number,
147: p_expiration_date_tbl IN po_tbl_date,
148: p_header_start_date_tbl IN po_tbl_date,
149: p_header_end_date_tbl IN po_tbl_date,
150: x_results IN OUT NOCOPY po_validation_results_type,

Line 212: p_id_tbl IN po_tbl_number,

208: -- flag has to be 'Y'. Global_agreement_flag and outside operation flag
209: -- can now both be 'Y' -- Bug Number : 14017950 - Enabling OSP line type for GBPA.
210: -------------------------------------------------------------------------
211: PROCEDURE global_agreement_flag(
212: p_id_tbl IN po_tbl_number,
213: p_global_agreement_flag_tbl IN po_tbl_varchar1,
214: p_purchase_basis_tbl IN po_tbl_varchar30,
215: p_line_type_id_tbl IN po_tbl_number,
216: x_result_set_id IN OUT NOCOPY NUMBER,

Line 215: p_line_type_id_tbl IN po_tbl_number,

211: PROCEDURE global_agreement_flag(
212: p_id_tbl IN po_tbl_number,
213: p_global_agreement_flag_tbl IN po_tbl_varchar1,
214: p_purchase_basis_tbl IN po_tbl_varchar30,
215: p_line_type_id_tbl IN po_tbl_number,
216: x_result_set_id IN OUT NOCOPY NUMBER,
217: x_results IN OUT NOCOPY po_validation_results_type,
218: x_result_type OUT NOCOPY VARCHAR2)
219: IS

Line 306: p_id_tbl IN po_tbl_number,

302: -- If order_type_lookup_code is 'FIXED PRICE',and amount is not empty,
303: -- then amount must be greater than or equal to zero
304: -------------------------------------------------------------------------
305: PROCEDURE amount_blanket(
306: p_id_tbl IN po_tbl_number,
307: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
308: p_amount_tbl IN po_tbl_number,
309: x_results IN OUT NOCOPY po_validation_results_type,
310: x_result_type OUT NOCOPY VARCHAR2)

Line 308: p_amount_tbl IN po_tbl_number,

304: -------------------------------------------------------------------------
305: PROCEDURE amount_blanket(
306: p_id_tbl IN po_tbl_number,
307: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
308: p_amount_tbl IN po_tbl_number,
309: x_results IN OUT NOCOPY po_validation_results_type,
310: x_result_type OUT NOCOPY VARCHAR2)
311: IS
312: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;

Line 372: p_id_tbl IN po_tbl_number,

368: -- If services procurement is not enabled, the order_type_lookup_code cannot
369: -- be 'FIXED PRICE' or 'RATE'.
370: -------------------------------------------------------------------------
371: PROCEDURE order_type_lookup_code(
372: p_id_tbl IN po_tbl_number,
373: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
374: x_results IN OUT NOCOPY po_validation_results_type,
375: x_result_type OUT NOCOPY VARCHAR2)
376: IS

Line 427: p_id_tbl IN po_tbl_number,

423: -- contractor first name and last name fields could be populated;
424: -- otherwise, they should be empty
425: -------------------------------------------------------------------------
426: PROCEDURE contractor_name(
427: p_id_tbl IN po_tbl_number,
428: p_doc_type IN VARCHAR2,
429: p_purchase_basis_tbl IN po_tbl_varchar30,
430: p_contractor_last_name_tbl IN po_tbl_varchar2000,
431: p_contractor_first_name_tbl IN po_tbl_varchar2000,

Line 483: p_id_tbl IN po_tbl_number,

479: -------------------------------------------------------------------------
480: -- If purchase basis is TEMP LABOR, then job id must not be null
481: -------------------------------------------------------------------------
482: PROCEDURE job_id(
483: p_id_tbl IN po_tbl_number,
484: p_job_id_tbl IN po_tbl_number,
485: p_job_business_group_id_tbl IN po_tbl_number,
486: p_purchase_basis_tbl IN po_tbl_varchar30,
487: p_category_id_tbl IN po_tbl_number,

Line 484: p_job_id_tbl IN po_tbl_number,

480: -- If purchase basis is TEMP LABOR, then job id must not be null
481: -------------------------------------------------------------------------
482: PROCEDURE job_id(
483: p_id_tbl IN po_tbl_number,
484: p_job_id_tbl IN po_tbl_number,
485: p_job_business_group_id_tbl IN po_tbl_number,
486: p_purchase_basis_tbl IN po_tbl_varchar30,
487: p_category_id_tbl IN po_tbl_number,
488: x_result_set_id IN OUT NOCOPY NUMBER,

Line 485: p_job_business_group_id_tbl IN po_tbl_number,

481: -------------------------------------------------------------------------
482: PROCEDURE job_id(
483: p_id_tbl IN po_tbl_number,
484: p_job_id_tbl IN po_tbl_number,
485: p_job_business_group_id_tbl IN po_tbl_number,
486: p_purchase_basis_tbl IN po_tbl_varchar30,
487: p_category_id_tbl IN po_tbl_number,
488: x_result_set_id IN OUT NOCOPY NUMBER,
489: x_results IN OUT NOCOPY po_validation_results_type,

Line 487: p_category_id_tbl IN po_tbl_number,

483: p_id_tbl IN po_tbl_number,
484: p_job_id_tbl IN po_tbl_number,
485: p_job_business_group_id_tbl IN po_tbl_number,
486: p_purchase_basis_tbl IN po_tbl_varchar30,
487: p_category_id_tbl IN po_tbl_number,
488: x_result_set_id IN OUT NOCOPY NUMBER,
489: x_results IN OUT NOCOPY po_validation_results_type,
490: x_result_type OUT NOCOPY VARCHAR2)
491: IS

Line 685: p_id_tbl IN po_tbl_number,

681: -- If services procurement not enabled, order_type_lookup_code cannot be
682: -- 'FIXED PRICE' or 'RATE'
683: -------------------------------------------------------------------------
684: PROCEDURE job_business_group_id(
685: p_id_tbl IN po_tbl_number,
686: p_job_id_tbl IN po_tbl_number,
687: p_job_business_group_id_tbl IN po_tbl_number,
688: p_purchase_basis_tbl IN po_tbl_varchar30,
689: x_result_set_id IN OUT NOCOPY NUMBER,

Line 686: p_job_id_tbl IN po_tbl_number,

682: -- 'FIXED PRICE' or 'RATE'
683: -------------------------------------------------------------------------
684: PROCEDURE job_business_group_id(
685: p_id_tbl IN po_tbl_number,
686: p_job_id_tbl IN po_tbl_number,
687: p_job_business_group_id_tbl IN po_tbl_number,
688: p_purchase_basis_tbl IN po_tbl_varchar30,
689: x_result_set_id IN OUT NOCOPY NUMBER,
690: x_result_type OUT NOCOPY VARCHAR2)

Line 687: p_job_business_group_id_tbl IN po_tbl_number,

683: -------------------------------------------------------------------------
684: PROCEDURE job_business_group_id(
685: p_id_tbl IN po_tbl_number,
686: p_job_id_tbl IN po_tbl_number,
687: p_job_business_group_id_tbl IN po_tbl_number,
688: p_purchase_basis_tbl IN po_tbl_varchar30,
689: x_result_set_id IN OUT NOCOPY NUMBER,
690: x_result_type OUT NOCOPY VARCHAR2)
691: IS

Line 791: p_id_tbl IN po_tbl_number,

787: -------------------------------------------------------------------------
788: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
789: -------------------------------------------------------------------------
790: PROCEDURE capital_expense_flag(
791: p_id_tbl IN po_tbl_number,
792: p_purchase_basis_tbl IN po_tbl_varchar30,
793: p_capital_expense_flag_tbl IN po_tbl_varchar1,
794: x_results IN OUT NOCOPY po_validation_results_type,
795: x_result_type OUT NOCOPY VARCHAR2)

Line 841: p_id_tbl IN po_tbl_number,

837: -------------------------------------------------------------------------
838: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
839: -------------------------------------------------------------------------
840: PROCEDURE un_number_id(
841: p_id_tbl IN po_tbl_number,
842: p_purchase_basis_tbl IN po_tbl_varchar30,
843: p_un_number_id_tbl IN po_tbl_number,
844: x_result_set_id IN OUT NOCOPY NUMBER,
845: x_results IN OUT NOCOPY po_validation_results_type,

Line 843: p_un_number_id_tbl IN po_tbl_number,

839: -------------------------------------------------------------------------
840: PROCEDURE un_number_id(
841: p_id_tbl IN po_tbl_number,
842: p_purchase_basis_tbl IN po_tbl_varchar30,
843: p_un_number_id_tbl IN po_tbl_number,
844: x_result_set_id IN OUT NOCOPY NUMBER,
845: x_results IN OUT NOCOPY po_validation_results_type,
846: x_result_type OUT NOCOPY VARCHAR2)
847: IS

Line 932: p_id_tbl IN po_tbl_number,

928: -------------------------------------------------------------------------
929: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
930: -------------------------------------------------------------------------
931: PROCEDURE hazard_class_id(
932: p_id_tbl IN po_tbl_number,
933: p_purchase_basis_tbl IN po_tbl_varchar30,
934: p_hazard_class_id_tbl IN po_tbl_number,
935: x_result_set_id IN OUT NOCOPY NUMBER,
936: x_results IN OUT NOCOPY po_validation_results_type,

Line 934: p_hazard_class_id_tbl IN po_tbl_number,

930: -------------------------------------------------------------------------
931: PROCEDURE hazard_class_id(
932: p_id_tbl IN po_tbl_number,
933: p_purchase_basis_tbl IN po_tbl_varchar30,
934: p_hazard_class_id_tbl IN po_tbl_number,
935: x_result_set_id IN OUT NOCOPY NUMBER,
936: x_results IN OUT NOCOPY po_validation_results_type,
937: x_result_type OUT NOCOPY VARCHAR2)
938: IS

Line 1023: p_id_tbl IN po_tbl_number,

1019: -------------------------------------------------------------------------
1020: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
1021: -------------------------------------------------------------------------
1022: PROCEDURE item_id(
1023: p_id_tbl IN po_tbl_number,
1024: p_item_id_tbl IN po_tbl_number,
1025: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1026: p_line_type_id_tbl IN po_tbl_number,
1027: p_inventory_org_id IN NUMBER,

Line 1024: p_item_id_tbl IN po_tbl_number,

1020: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
1021: -------------------------------------------------------------------------
1022: PROCEDURE item_id(
1023: p_id_tbl IN po_tbl_number,
1024: p_item_id_tbl IN po_tbl_number,
1025: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1026: p_line_type_id_tbl IN po_tbl_number,
1027: p_inventory_org_id IN NUMBER,
1028: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1026: p_line_type_id_tbl IN po_tbl_number,

1022: PROCEDURE item_id(
1023: p_id_tbl IN po_tbl_number,
1024: p_item_id_tbl IN po_tbl_number,
1025: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1026: p_line_type_id_tbl IN po_tbl_number,
1027: p_inventory_org_id IN NUMBER,
1028: x_result_set_id IN OUT NOCOPY NUMBER,
1029: x_results IN OUT NOCOPY po_validation_results_type,
1030: x_result_type OUT NOCOPY VARCHAR2)

Line 1179: p_id_tbl IN po_tbl_number,

1175: -- from what is setup for the item. Would not allow item_description update if item attribute
1176: -- allow_item_desc_update_flag is N.
1177: -------------------------------------------------------------------------
1178: PROCEDURE item_description(
1179: p_id_tbl IN po_tbl_number,
1180: p_item_description_tbl IN po_tbl_varchar2000,
1181: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1182: p_item_id_tbl IN po_tbl_number,
1183: p_create_or_update_item IN VARCHAR2,

Line 1182: p_item_id_tbl IN po_tbl_number,

1178: PROCEDURE item_description(
1179: p_id_tbl IN po_tbl_number,
1180: p_item_description_tbl IN po_tbl_varchar2000,
1181: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1182: p_item_id_tbl IN po_tbl_number,
1183: p_create_or_update_item IN VARCHAR2,
1184: p_inventory_org_id IN NUMBER,
1185: x_result_set_id IN OUT NOCOPY NUMBER,
1186: x_result_type OUT NOCOPY VARCHAR2)

Line 1271: p_id_tbl IN po_tbl_number,

1267: -------------------------------------------------------------------------
1268: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
1269: -------------------------------------------------------------------------
1270: PROCEDURE unit_meas_lookup_code(
1271: p_id_tbl IN po_tbl_number,
1272: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1273: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1274: p_item_id_tbl IN po_tbl_number,
1275: p_line_type_id_tbl IN po_tbl_number,

Line 1274: p_item_id_tbl IN po_tbl_number,

1270: PROCEDURE unit_meas_lookup_code(
1271: p_id_tbl IN po_tbl_number,
1272: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1273: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1274: p_item_id_tbl IN po_tbl_number,
1275: p_line_type_id_tbl IN po_tbl_number,
1276: p_inventory_org_id IN NUMBER,
1277: x_result_set_id IN OUT NOCOPY NUMBER,
1278: x_results IN OUT NOCOPY po_validation_results_type,

Line 1275: p_line_type_id_tbl IN po_tbl_number,

1271: p_id_tbl IN po_tbl_number,
1272: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1273: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1274: p_item_id_tbl IN po_tbl_number,
1275: p_line_type_id_tbl IN po_tbl_number,
1276: p_inventory_org_id IN NUMBER,
1277: x_result_set_id IN OUT NOCOPY NUMBER,
1278: x_results IN OUT NOCOPY po_validation_results_type,
1279: x_result_type OUT NOCOPY VARCHAR2)

Line 1509: p_id_tbl IN po_tbl_number,

1505: -- If order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
1506: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
1507: -------------------------------------------------------------------------
1508: PROCEDURE item_revision(
1509: p_id_tbl IN po_tbl_number,
1510: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1511: p_item_revision_tbl IN po_tbl_varchar5,
1512: p_item_id_tbl IN po_tbl_number,
1513: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1512: p_item_id_tbl IN po_tbl_number,

1508: PROCEDURE item_revision(
1509: p_id_tbl IN po_tbl_number,
1510: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1511: p_item_revision_tbl IN po_tbl_varchar5,
1512: p_item_id_tbl IN po_tbl_number,
1513: x_result_set_id IN OUT NOCOPY NUMBER,
1514: x_results IN OUT NOCOPY po_validation_results_type,
1515: x_result_type OUT NOCOPY VARCHAR2)
1516: IS

Line 1617: p_id_tbl IN po_tbl_number,

1613: -- 'Validate flag' ON. If Yes, we will validate the Category to exist in the 'Valid Category List'.
1614: -- If No, we will just validate if the category is Enable and Active.
1615: -------------------------------------------------------------------------
1616: PROCEDURE category_id(
1617: p_id_tbl IN po_tbl_number,
1618: p_category_id_tbl IN po_tbl_number,
1619: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1620: p_item_id_tbl IN po_tbl_number,
1621: p_inventory_org_id IN NUMBER,

Line 1618: p_category_id_tbl IN po_tbl_number,

1614: -- If No, we will just validate if the category is Enable and Active.
1615: -------------------------------------------------------------------------
1616: PROCEDURE category_id(
1617: p_id_tbl IN po_tbl_number,
1618: p_category_id_tbl IN po_tbl_number,
1619: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1620: p_item_id_tbl IN po_tbl_number,
1621: p_inventory_org_id IN NUMBER,
1622: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1620: p_item_id_tbl IN po_tbl_number,

1616: PROCEDURE category_id(
1617: p_id_tbl IN po_tbl_number,
1618: p_category_id_tbl IN po_tbl_number,
1619: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1620: p_item_id_tbl IN po_tbl_number,
1621: p_inventory_org_id IN NUMBER,
1622: x_result_set_id IN OUT NOCOPY NUMBER,
1623: x_results IN OUT NOCOPY po_validation_results_type,
1624: x_result_type OUT NOCOPY VARCHAR2)

Line 1813: p_id_tbl IN po_tbl_number,

1809: -- Validate ip_category_id is not empty for Blanket and Quotation;
1810: -- Validate ip_category_id is valid if not empty
1811: -------------------------------------------------------------------------
1812: PROCEDURE ip_category_id(
1813: p_id_tbl IN po_tbl_number,
1814: p_ip_category_id_tbl IN po_tbl_number,
1815: x_result_set_id IN OUT NOCOPY NUMBER,
1816: x_results IN OUT NOCOPY po_validation_results_type,
1817: x_result_type OUT NOCOPY VARCHAR2)

Line 1814: p_ip_category_id_tbl IN po_tbl_number,

1810: -- Validate ip_category_id is valid if not empty
1811: -------------------------------------------------------------------------
1812: PROCEDURE ip_category_id(
1813: p_id_tbl IN po_tbl_number,
1814: p_ip_category_id_tbl IN po_tbl_number,
1815: x_result_set_id IN OUT NOCOPY NUMBER,
1816: x_results IN OUT NOCOPY po_validation_results_type,
1817: x_result_type OUT NOCOPY VARCHAR2)
1818: IS

Line 1910: p_id_tbl IN po_tbl_number,

1906: -- unit_price should be the same as the one defined in the line_type.
1907: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
1908: -------------------------------------------------------------------------
1909: PROCEDURE unit_price(
1910: p_id_tbl IN po_tbl_number,
1911: p_unit_price_tbl IN po_tbl_number,
1912: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1913: p_line_type_id_tbl IN po_tbl_number,
1914: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1911: p_unit_price_tbl IN po_tbl_number,

1907: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
1908: -------------------------------------------------------------------------
1909: PROCEDURE unit_price(
1910: p_id_tbl IN po_tbl_number,
1911: p_unit_price_tbl IN po_tbl_number,
1912: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1913: p_line_type_id_tbl IN po_tbl_number,
1914: x_result_set_id IN OUT NOCOPY NUMBER,
1915: x_results IN OUT NOCOPY po_validation_results_type,

Line 1913: p_line_type_id_tbl IN po_tbl_number,

1909: PROCEDURE unit_price(
1910: p_id_tbl IN po_tbl_number,
1911: p_unit_price_tbl IN po_tbl_number,
1912: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1913: p_line_type_id_tbl IN po_tbl_number,
1914: x_result_set_id IN OUT NOCOPY NUMBER,
1915: x_results IN OUT NOCOPY po_validation_results_type,
1916: x_result_type OUT NOCOPY VARCHAR2)
1917: IS

Line 2095: p_id_tbl IN po_tbl_number,

2091: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero
2092: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
2093: -------------------------------------------------------------------------
2094: PROCEDURE quantity(
2095: p_id_tbl IN po_tbl_number,
2096: p_quantity_tbl IN po_tbl_number,
2097: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2098: x_results IN OUT NOCOPY po_validation_results_type,
2099: x_result_type OUT NOCOPY VARCHAR2)

Line 2096: p_quantity_tbl IN po_tbl_number,

2092: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
2093: -------------------------------------------------------------------------
2094: PROCEDURE quantity(
2095: p_id_tbl IN po_tbl_number,
2096: p_quantity_tbl IN po_tbl_number,
2097: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2098: x_results IN OUT NOCOPY po_validation_results_type,
2099: x_result_type OUT NOCOPY VARCHAR2)
2100: IS

Line 2164: p_id_tbl IN po_tbl_number,

2160: -------------------------------------------------------------------------
2161: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
2162: -------------------------------------------------------------------------
2163: PROCEDURE amount(
2164: p_id_tbl IN po_tbl_number,
2165: p_amount_tbl IN po_tbl_number,
2166: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2167: x_results IN OUT NOCOPY po_validation_results_type,
2168: x_result_type OUT NOCOPY VARCHAR2)

Line 2165: p_amount_tbl IN po_tbl_number,

2161: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
2162: -------------------------------------------------------------------------
2163: PROCEDURE amount(
2164: p_id_tbl IN po_tbl_number,
2165: p_amount_tbl IN po_tbl_number,
2166: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2167: x_results IN OUT NOCOPY po_validation_results_type,
2168: x_result_type OUT NOCOPY VARCHAR2)
2169: IS

Line 2217: p_id_tbl IN po_tbl_number,

2213: -------------------------------------------------------------------------
2214: -- For rate based temp labor line, the currency rate_type cannot be 'user'
2215: -------------------------------------------------------------------------
2216: PROCEDURE rate_type(
2217: p_id_tbl IN po_tbl_number,
2218: p_rate_type_tbl IN po_tbl_varchar30,
2219: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2220: x_results IN OUT NOCOPY po_validation_results_type,
2221: x_result_type OUT NOCOPY VARCHAR2)

Line 2269: p_id_tbl IN po_tbl_number,

2265: -- Line num must be populated and cannot be <= 0.
2266: -- Line num has to be unique in a requisition.
2267: -------------------------------------------------------------------------
2268: PROCEDURE line_num(
2269: p_id_tbl IN po_tbl_number,
2270: p_po_header_id_tbl IN po_tbl_number,
2271: p_line_num_tbl IN po_tbl_number,
2272: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752

Line 2270: p_po_header_id_tbl IN po_tbl_number,

2266: -- Line num has to be unique in a requisition.
2267: -------------------------------------------------------------------------
2268: PROCEDURE line_num(
2269: p_id_tbl IN po_tbl_number,
2270: p_po_header_id_tbl IN po_tbl_number,
2271: p_line_num_tbl IN po_tbl_number,
2272: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2274: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2271: p_line_num_tbl IN po_tbl_number,

2267: -------------------------------------------------------------------------
2268: PROCEDURE line_num(
2269: p_id_tbl IN po_tbl_number,
2270: p_po_header_id_tbl IN po_tbl_number,
2271: p_line_num_tbl IN po_tbl_number,
2272: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2274: x_result_set_id IN OUT NOCOPY NUMBER,
2275: x_results IN OUT NOCOPY po_validation_results_type,

Line 2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752

2269: p_id_tbl IN po_tbl_number,
2270: p_po_header_id_tbl IN po_tbl_number,
2271: p_line_num_tbl IN po_tbl_number,
2272: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2273: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2274: x_result_set_id IN OUT NOCOPY NUMBER,
2275: x_results IN OUT NOCOPY po_validation_results_type,
2276: x_result_type OUT NOCOPY VARCHAR2)
2277: IS

Line 2394: p_id_tbl IN po_tbl_number,

2390: -------------------------------------------------------------------------
2391: -- Po_line_id must be populated and unique.
2392: -------------------------------------------------------------------------
2393: PROCEDURE po_line_id(
2394: p_id_tbl IN po_tbl_number,
2395: p_po_line_id_tbl IN po_tbl_number,
2396: p_po_header_id_tbl IN po_tbl_number,
2397: x_result_set_id IN OUT NOCOPY NUMBER,
2398: x_result_type OUT NOCOPY VARCHAR2)

Line 2395: p_po_line_id_tbl IN po_tbl_number,

2391: -- Po_line_id must be populated and unique.
2392: -------------------------------------------------------------------------
2393: PROCEDURE po_line_id(
2394: p_id_tbl IN po_tbl_number,
2395: p_po_line_id_tbl IN po_tbl_number,
2396: p_po_header_id_tbl IN po_tbl_number,
2397: x_result_set_id IN OUT NOCOPY NUMBER,
2398: x_result_type OUT NOCOPY VARCHAR2)
2399: IS

Line 2396: p_po_header_id_tbl IN po_tbl_number,

2392: -------------------------------------------------------------------------
2393: PROCEDURE po_line_id(
2394: p_id_tbl IN po_tbl_number,
2395: p_po_line_id_tbl IN po_tbl_number,
2396: p_po_header_id_tbl IN po_tbl_number,
2397: x_result_set_id IN OUT NOCOPY NUMBER,
2398: x_result_type OUT NOCOPY VARCHAR2)
2399: IS
2400: d_mod CONSTANT VARCHAR2(100) := d_po_line_id;

Line 2471: p_id_tbl IN po_tbl_number,

2467: -------------------------------------------------------------------------
2468: -- Line type id must be populated and exist in po_line_types_val_v
2469: -------------------------------------------------------------------------
2470: PROCEDURE line_type_id(
2471: p_id_tbl IN po_tbl_number,
2472: p_line_type_id_tbl IN po_tbl_number,
2473: x_result_set_id IN OUT NOCOPY NUMBER,
2474: x_result_type OUT NOCOPY VARCHAR2)
2475: IS

Line 2472: p_line_type_id_tbl IN po_tbl_number,

2468: -- Line type id must be populated and exist in po_line_types_val_v
2469: -------------------------------------------------------------------------
2470: PROCEDURE line_type_id(
2471: p_id_tbl IN po_tbl_number,
2472: p_line_type_id_tbl IN po_tbl_number,
2473: x_result_set_id IN OUT NOCOPY NUMBER,
2474: x_result_type OUT NOCOPY VARCHAR2)
2475: IS
2476: d_mod CONSTANT VARCHAR2(100) := d_line_type_id;

Line 2544: p_id_tbl IN po_tbl_number,

2540: -------------------------------------------------------------------------
2541: -- Validate style_id related information.
2542: -------------------------------------------------------------------------
2543: PROCEDURE style_related_info(
2544: p_id_tbl IN po_tbl_number,
2545: p_style_id_tbl IN po_tbl_number,
2546: p_line_type_id_tbl IN po_tbl_number,
2547: p_purchase_basis_tbl IN po_tbl_varchar30,
2548: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2545: p_style_id_tbl IN po_tbl_number,

2541: -- Validate style_id related information.
2542: -------------------------------------------------------------------------
2543: PROCEDURE style_related_info(
2544: p_id_tbl IN po_tbl_number,
2545: p_style_id_tbl IN po_tbl_number,
2546: p_line_type_id_tbl IN po_tbl_number,
2547: p_purchase_basis_tbl IN po_tbl_varchar30,
2548: x_result_set_id IN OUT NOCOPY NUMBER,
2549: x_result_type OUT NOCOPY VARCHAR2)

Line 2546: p_line_type_id_tbl IN po_tbl_number,

2542: -------------------------------------------------------------------------
2543: PROCEDURE style_related_info(
2544: p_id_tbl IN po_tbl_number,
2545: p_style_id_tbl IN po_tbl_number,
2546: p_line_type_id_tbl IN po_tbl_number,
2547: p_purchase_basis_tbl IN po_tbl_varchar30,
2548: x_result_set_id IN OUT NOCOPY NUMBER,
2549: x_result_type OUT NOCOPY VARCHAR2)
2550: IS

Line 2666: p_id_tbl IN po_tbl_number,

2662: -------------------------------------------------------------------------
2663: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
2664: -------------------------------------------------------------------------
2665: PROCEDURE price_type_lookup_code(
2666: p_id_tbl IN po_tbl_number,
2667: p_price_type_lookup_code_tbl IN po_tbl_varchar30,
2668: x_result_set_id IN OUT NOCOPY NUMBER,
2669: x_result_type OUT NOCOPY VARCHAR2)
2670: IS

Line 2739: p_id_tbl IN po_tbl_number,

2735: --Expiration date if provided should be later than the start date
2736: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2737: -------------------------------------------------------------------------
2738: PROCEDURE start_date_standard(
2739: p_id_tbl IN po_tbl_number,
2740: p_start_date_tbl IN po_tbl_date,
2741: p_expiration_date_tbl IN po_tbl_date,
2742: p_purchase_basis_tbl IN po_tbl_varchar30,
2743: x_results IN OUT NOCOPY po_validation_results_type,

Line 2823: p_id_tbl IN po_tbl_number,

2819: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2820: -- then bom_item_type cannot be 1 or 2.
2821: -------------------------------------------------------------------------
2822: PROCEDURE item_id_standard(
2823: p_id_tbl IN po_tbl_number,
2824: p_item_id_tbl IN po_tbl_number,
2825: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2826: p_inventory_org_id IN NUMBER,
2827: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2824: p_item_id_tbl IN po_tbl_number,

2820: -- then bom_item_type cannot be 1 or 2.
2821: -------------------------------------------------------------------------
2822: PROCEDURE item_id_standard(
2823: p_id_tbl IN po_tbl_number,
2824: p_item_id_tbl IN po_tbl_number,
2825: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2826: p_inventory_org_id IN NUMBER,
2827: x_result_set_id IN OUT NOCOPY NUMBER,
2828: x_result_type OUT NOCOPY VARCHAR2)

Line 2897: p_id_tbl IN po_tbl_number,

2893: -------------------------------------------------------------------------
2894: -- Quantity cannot be zero for SPO
2895: -------------------------------------------------------------------------
2896: PROCEDURE quantity_standard(
2897: p_id_tbl IN po_tbl_number,
2898: p_quantity_tbl IN po_tbl_number,
2899: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2900: x_results IN OUT NOCOPY po_validation_results_type,
2901: x_result_type OUT NOCOPY VARCHAR2)

Line 2898: p_quantity_tbl IN po_tbl_number,

2894: -- Quantity cannot be zero for SPO
2895: -------------------------------------------------------------------------
2896: PROCEDURE quantity_standard(
2897: p_id_tbl IN po_tbl_number,
2898: p_quantity_tbl IN po_tbl_number,
2899: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2900: x_results IN OUT NOCOPY po_validation_results_type,
2901: x_result_type OUT NOCOPY VARCHAR2)
2902: IS

Line 2955: p_id_tbl IN po_tbl_number,

2951: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not
2952: -- empty, amount value must be greater than zero
2953: -------------------------------------------------------------------------
2954: PROCEDURE amount_standard(
2955: p_id_tbl IN po_tbl_number,
2956: p_amount_tbl IN po_tbl_number,
2957: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2958: x_results IN OUT NOCOPY po_validation_results_type,
2959: x_result_type OUT NOCOPY VARCHAR2)

Line 2956: p_amount_tbl IN po_tbl_number,

2952: -- empty, amount value must be greater than zero
2953: -------------------------------------------------------------------------
2954: PROCEDURE amount_standard(
2955: p_id_tbl IN po_tbl_number,
2956: p_amount_tbl IN po_tbl_number,
2957: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2958: x_results IN OUT NOCOPY po_validation_results_type,
2959: x_result_type OUT NOCOPY VARCHAR2)
2960: IS

Line 3020: p_id_tbl IN po_tbl_number,

3016: -- Price break lookup code should be valid
3017: -------------------------------------------------------------------------
3018: -- bug5016163 START
3019: PROCEDURE price_break_lookup_code(
3020: p_id_tbl IN po_tbl_number,
3021: p_price_break_lookup_code_tbl IN po_tbl_varchar30,
3022: p_global_agreement_flag_tbl IN po_tbl_varchar1,
3023: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3024: p_purchase_basis_tbl IN po_tbl_varchar30,

Line 3129: p_id_tbl IN po_tbl_number,

3125: -- If allow_price_override_flag is 'N', then not_to_exceed_price has to be null.
3126: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3127: -------------------------------------------------------------------------
3128: PROCEDURE not_to_exceed_price(
3129: p_id_tbl IN po_tbl_number,
3130: p_not_to_exceed_price_tbl IN po_tbl_number,
3131: p_allow_price_override_tbl IN po_tbl_varchar1,
3132: p_unit_price_tbl IN po_tbl_number,
3133: x_results IN OUT NOCOPY po_validation_results_type,

Line 3130: p_not_to_exceed_price_tbl IN po_tbl_number,

3126: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3127: -------------------------------------------------------------------------
3128: PROCEDURE not_to_exceed_price(
3129: p_id_tbl IN po_tbl_number,
3130: p_not_to_exceed_price_tbl IN po_tbl_number,
3131: p_allow_price_override_tbl IN po_tbl_varchar1,
3132: p_unit_price_tbl IN po_tbl_number,
3133: x_results IN OUT NOCOPY po_validation_results_type,
3134: x_result_type OUT NOCOPY VARCHAR2)

Line 3132: p_unit_price_tbl IN po_tbl_number,

3128: PROCEDURE not_to_exceed_price(
3129: p_id_tbl IN po_tbl_number,
3130: p_not_to_exceed_price_tbl IN po_tbl_number,
3131: p_allow_price_override_tbl IN po_tbl_varchar1,
3132: p_unit_price_tbl IN po_tbl_number,
3133: x_results IN OUT NOCOPY po_validation_results_type,
3134: x_result_type OUT NOCOPY VARCHAR2)
3135: IS
3136: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;

Line 3196: p_id_tbl IN po_tbl_number,

3192: -------------------------------------------------------------------------
3193: -- Validate ip_category_id is valid if not empty
3194: -------------------------------------------------------------------------
3195: PROCEDURE ip_category_id_update(
3196: p_id_tbl IN po_tbl_number,
3197: p_ip_category_id_tbl IN po_tbl_number,
3198: x_result_set_id IN OUT NOCOPY NUMBER,
3199: x_results IN OUT NOCOPY po_validation_results_type,
3200: x_result_type OUT NOCOPY VARCHAR2)

Line 3197: p_ip_category_id_tbl IN po_tbl_number,

3193: -- Validate ip_category_id is valid if not empty
3194: -------------------------------------------------------------------------
3195: PROCEDURE ip_category_id_update(
3196: p_id_tbl IN po_tbl_number,
3197: p_ip_category_id_tbl IN po_tbl_number,
3198: x_result_set_id IN OUT NOCOPY NUMBER,
3199: x_results IN OUT NOCOPY po_validation_results_type,
3200: x_result_type OUT NOCOPY VARCHAR2)
3201: IS

Line 3289: p_id_tbl IN po_tbl_number,

3285: -----------------------------------------------------------------------------
3286: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3287: -----------------------------------------------------------------------------
3288: PROCEDURE uom_update(
3289: p_id_tbl IN po_tbl_number,
3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3291: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3292: p_po_header_id_tbl IN po_tbl_number,
3293: p_po_line_id_tbl IN po_tbl_number,

Line 3292: p_po_header_id_tbl IN po_tbl_number,

3288: PROCEDURE uom_update(
3289: p_id_tbl IN po_tbl_number,
3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3291: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3292: p_po_header_id_tbl IN po_tbl_number,
3293: p_po_line_id_tbl IN po_tbl_number,
3294: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3295: x_result_type OUT NOCOPY VARCHAR2)
3296: IS

Line 3293: p_po_line_id_tbl IN po_tbl_number,

3289: p_id_tbl IN po_tbl_number,
3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3291: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3292: p_po_header_id_tbl IN po_tbl_number,
3293: p_po_line_id_tbl IN po_tbl_number,
3294: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3295: x_result_type OUT NOCOPY VARCHAR2)
3296: IS
3297: d_mod CONSTANT VARCHAR2(100) := d_uom_update;

Line 3397: p_id_tbl IN po_tbl_number,

3393: -- Would not allow item_description update if item attribute allow_item_desc_update_flag is N.
3394: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.
3395: -------------------------------------------------------------------------
3396: PROCEDURE item_desc_update(
3397: p_id_tbl IN po_tbl_number,
3398: p_item_description_tbl IN po_tbl_varchar2000,
3399: p_item_id_tbl IN po_tbl_number,
3400: p_inventory_org_id IN NUMBER,
3401: p_po_header_id_tbl IN po_tbl_number,

Line 3399: p_item_id_tbl IN po_tbl_number,

3395: -------------------------------------------------------------------------
3396: PROCEDURE item_desc_update(
3397: p_id_tbl IN po_tbl_number,
3398: p_item_description_tbl IN po_tbl_varchar2000,
3399: p_item_id_tbl IN po_tbl_number,
3400: p_inventory_org_id IN NUMBER,
3401: p_po_header_id_tbl IN po_tbl_number,
3402: p_po_line_id_tbl IN po_tbl_number,
3403: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,

Line 3401: p_po_header_id_tbl IN po_tbl_number,

3397: p_id_tbl IN po_tbl_number,
3398: p_item_description_tbl IN po_tbl_varchar2000,
3399: p_item_id_tbl IN po_tbl_number,
3400: p_inventory_org_id IN NUMBER,
3401: p_po_header_id_tbl IN po_tbl_number,
3402: p_po_line_id_tbl IN po_tbl_number,
3403: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3404: x_result_type OUT NOCOPY VARCHAR2)
3405: IS

Line 3402: p_po_line_id_tbl IN po_tbl_number,

3398: p_item_description_tbl IN po_tbl_varchar2000,
3399: p_item_id_tbl IN po_tbl_number,
3400: p_inventory_org_id IN NUMBER,
3401: p_po_header_id_tbl IN po_tbl_number,
3402: p_po_line_id_tbl IN po_tbl_number,
3403: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3404: x_result_type OUT NOCOPY VARCHAR2)
3405: IS
3406: d_mod CONSTANT VARCHAR2(100) := d_item_desc_update;

Line 3516: p_id_tbl IN po_tbl_number,

3512: ----------------------------------------------------------------------------------------
3513: -- Called in create case for Blanket AND SPO, negotiated_by_preparer must be 'Y' or 'N'.
3514: ----------------------------------------------------------------------------------------
3515: PROCEDURE negotiated_by_preparer(
3516: p_id_tbl IN po_tbl_number,
3517: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3518: x_results IN OUT NOCOPY po_validation_results_type,
3519: x_result_type OUT NOCOPY VARCHAR2)
3520: IS

Line 3565: p_id_tbl IN po_tbl_number,

3561: --------------------------------------------------------------------------------------
3562: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.
3563: --------------------------------------------------------------------------------------
3564: PROCEDURE negotiated_by_prep_update(
3565: p_id_tbl IN po_tbl_number,
3566: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3567: x_results IN OUT NOCOPY po_validation_results_type,
3568: x_result_type OUT NOCOPY VARCHAR2)
3569: IS

Line 3625: p_id_tbl IN po_tbl_number,

3621: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id
3622: -- If change is allowed, the new category_id must be valid.
3623: -------------------------------------------------------------------------
3624: PROCEDURE category_id_update(
3625: p_id_tbl IN po_tbl_number,
3626: p_category_id_tbl IN po_tbl_number,
3627: p_po_line_id_tbl IN po_tbl_number,
3628: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3629: p_item_id_tbl IN po_tbl_number,

Line 3626: p_category_id_tbl IN po_tbl_number,

3622: -- If change is allowed, the new category_id must be valid.
3623: -------------------------------------------------------------------------
3624: PROCEDURE category_id_update(
3625: p_id_tbl IN po_tbl_number,
3626: p_category_id_tbl IN po_tbl_number,
3627: p_po_line_id_tbl IN po_tbl_number,
3628: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3629: p_item_id_tbl IN po_tbl_number,
3630: p_job_id_tbl IN po_tbl_number,

Line 3627: p_po_line_id_tbl IN po_tbl_number,

3623: -------------------------------------------------------------------------
3624: PROCEDURE category_id_update(
3625: p_id_tbl IN po_tbl_number,
3626: p_category_id_tbl IN po_tbl_number,
3627: p_po_line_id_tbl IN po_tbl_number,
3628: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3629: p_item_id_tbl IN po_tbl_number,
3630: p_job_id_tbl IN po_tbl_number,
3631: p_inventory_org_id IN NUMBER,

Line 3629: p_item_id_tbl IN po_tbl_number,

3625: p_id_tbl IN po_tbl_number,
3626: p_category_id_tbl IN po_tbl_number,
3627: p_po_line_id_tbl IN po_tbl_number,
3628: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3629: p_item_id_tbl IN po_tbl_number,
3630: p_job_id_tbl IN po_tbl_number,
3631: p_inventory_org_id IN NUMBER,
3632: x_result_set_id IN OUT NOCOPY NUMBER,
3633: x_results IN OUT NOCOPY po_validation_results_type,

Line 3630: p_job_id_tbl IN po_tbl_number,

3626: p_category_id_tbl IN po_tbl_number,
3627: p_po_line_id_tbl IN po_tbl_number,
3628: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3629: p_item_id_tbl IN po_tbl_number,
3630: p_job_id_tbl IN po_tbl_number,
3631: p_inventory_org_id IN NUMBER,
3632: x_result_set_id IN OUT NOCOPY NUMBER,
3633: x_results IN OUT NOCOPY po_validation_results_type,
3634: x_result_type OUT NOCOPY VARCHAR2)

Line 3732: ( p_id_tbl IN po_tbl_number,

3728: -------------------------------------------------------------------------
3729: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3730: -------------------------------------------------------------------------
3731: PROCEDURE unit_price_update
3732: ( p_id_tbl IN po_tbl_number,
3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3734: p_draft_id_tbl IN po_tbl_number,
3735: p_unit_price_tbl IN po_tbl_number,
3736: x_results IN OUT NOCOPY po_validation_results_type,

Line 3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206

3729: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3730: -------------------------------------------------------------------------
3731: PROCEDURE unit_price_update
3732: ( p_id_tbl IN po_tbl_number,
3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3734: p_draft_id_tbl IN po_tbl_number,
3735: p_unit_price_tbl IN po_tbl_number,
3736: x_results IN OUT NOCOPY po_validation_results_type,
3737: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206

Line 3734: p_draft_id_tbl IN po_tbl_number,

3730: -------------------------------------------------------------------------
3731: PROCEDURE unit_price_update
3732: ( p_id_tbl IN po_tbl_number,
3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3734: p_draft_id_tbl IN po_tbl_number,
3735: p_unit_price_tbl IN po_tbl_number,
3736: x_results IN OUT NOCOPY po_validation_results_type,
3737: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3738: x_result_type OUT NOCOPY VARCHAR2

Line 3735: p_unit_price_tbl IN po_tbl_number,

3731: PROCEDURE unit_price_update
3732: ( p_id_tbl IN po_tbl_number,
3733: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3734: p_draft_id_tbl IN po_tbl_number,
3735: p_unit_price_tbl IN po_tbl_number,
3736: x_results IN OUT NOCOPY po_validation_results_type,
3737: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3738: x_result_type OUT NOCOPY VARCHAR2
3739: )

Line 3918: ( p_id_tbl IN po_tbl_number,

3914: -------------------------------------------------------------------------
3915: -- In the UPDATE case, amount should not be udpated if it's not 'FIXED PRICE'
3916: -------------------------------------------------------------------------
3917: PROCEDURE amount_update
3918: ( p_id_tbl IN po_tbl_number,
3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3920: p_draft_id_tbl IN po_tbl_number,
3921: p_amount_tbl IN po_tbl_number,
3922: x_results IN OUT NOCOPY po_validation_results_type,

Line 3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206

3915: -- In the UPDATE case, amount should not be udpated if it's not 'FIXED PRICE'
3916: -------------------------------------------------------------------------
3917: PROCEDURE amount_update
3918: ( p_id_tbl IN po_tbl_number,
3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3920: p_draft_id_tbl IN po_tbl_number,
3921: p_amount_tbl IN po_tbl_number,
3922: x_results IN OUT NOCOPY po_validation_results_type,
3923: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206

Line 3920: p_draft_id_tbl IN po_tbl_number,

3916: -------------------------------------------------------------------------
3917: PROCEDURE amount_update
3918: ( p_id_tbl IN po_tbl_number,
3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3920: p_draft_id_tbl IN po_tbl_number,
3921: p_amount_tbl IN po_tbl_number,
3922: x_results IN OUT NOCOPY po_validation_results_type,
3923: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3924: x_result_type OUT NOCOPY VARCHAR2

Line 3921: p_amount_tbl IN po_tbl_number,

3917: PROCEDURE amount_update
3918: ( p_id_tbl IN po_tbl_number,
3919: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3920: p_draft_id_tbl IN po_tbl_number,
3921: p_amount_tbl IN po_tbl_number,
3922: x_results IN OUT NOCOPY po_validation_results_type,
3923: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3924: x_result_type OUT NOCOPY VARCHAR2
3925: )

Line 4079: ( p_po_line_id_tbl IN po_tbl_number,

4075: -- Check valid category got selected or not for all the lines from the category LOV in BWC
4076: -- It is called when saving agreements/orders in BWC
4077: ------------------------------------------------------------------------------------------
4078: PROCEDURE category_combination_valid
4079: ( p_po_line_id_tbl IN po_tbl_number,
4080: p_category_id_tbl IN po_tbl_number,
4081: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1, --Bug 12768893
4082: x_results IN OUT NOCOPY po_validation_results_type,
4083: x_result_type OUT NOCOPY VARCHAR2

Line 4080: p_category_id_tbl IN po_tbl_number,

4076: -- It is called when saving agreements/orders in BWC
4077: ------------------------------------------------------------------------------------------
4078: PROCEDURE category_combination_valid
4079: ( p_po_line_id_tbl IN po_tbl_number,
4080: p_category_id_tbl IN po_tbl_number,
4081: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1, --Bug 12768893
4082: x_results IN OUT NOCOPY po_validation_results_type,
4083: x_result_type OUT NOCOPY VARCHAR2
4084: )

Line 4272: ( p_po_line_id_tbl IN po_tbl_number,

4268: -- Check valid item got selected or not for all the lines from the item LOV in BWC
4269: -- It is called when saving agreements/orders in BWC
4270: ------------------------------------------------------------------------------------------
4271: PROCEDURE item_combination_valid
4272: ( p_po_line_id_tbl IN po_tbl_number,
4273: p_item_id_tbl IN po_tbl_number,
4274: x_results IN OUT NOCOPY po_validation_results_type,
4275: x_result_type OUT NOCOPY VARCHAR2
4276: )

Line 4273: p_item_id_tbl IN po_tbl_number,

4269: -- It is called when saving agreements/orders in BWC
4270: ------------------------------------------------------------------------------------------
4271: PROCEDURE item_combination_valid
4272: ( p_po_line_id_tbl IN po_tbl_number,
4273: p_item_id_tbl IN po_tbl_number,
4274: x_results IN OUT NOCOPY po_validation_results_type,
4275: x_result_type OUT NOCOPY VARCHAR2
4276: )
4277: IS