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 68: p_id_tbl IN po_tbl_number,

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

Line 141: p_id_tbl IN po_tbl_number,

137: -- Expiration date on the line cannot be earlier than the header effective start date and
138: -- cannot be later than header effective end date
139: -------------------------------------------------------------------------
140: PROCEDURE expiration_date_blanket(
141: p_id_tbl IN po_tbl_number,
142: p_expiration_date_tbl IN po_tbl_date,
143: p_header_start_date_tbl IN po_tbl_date,
144: p_header_end_date_tbl IN po_tbl_date,
145: x_results IN OUT NOCOPY po_validation_results_type,

Line 207: p_id_tbl IN po_tbl_number,

203: -- flag has to be 'Y'. Global_agreement_flag and outside operation flag
204: -- cannot both be 'Y'
205: -------------------------------------------------------------------------
206: PROCEDURE global_agreement_flag(
207: p_id_tbl IN po_tbl_number,
208: p_global_agreement_flag_tbl IN po_tbl_varchar1,
209: p_purchase_basis_tbl IN po_tbl_varchar30,
210: p_line_type_id_tbl IN po_tbl_number,
211: x_result_set_id IN OUT NOCOPY NUMBER,

Line 210: p_line_type_id_tbl IN po_tbl_number,

206: PROCEDURE global_agreement_flag(
207: p_id_tbl IN po_tbl_number,
208: p_global_agreement_flag_tbl IN po_tbl_varchar1,
209: p_purchase_basis_tbl IN po_tbl_varchar30,
210: p_line_type_id_tbl IN po_tbl_number,
211: x_result_set_id IN OUT NOCOPY NUMBER,
212: x_results IN OUT NOCOPY po_validation_results_type,
213: x_result_type OUT NOCOPY VARCHAR2)
214: IS

Line 297: p_id_tbl IN po_tbl_number,

293: -- If order_type_lookup_code is 'FIXED PRICE',and amount is not empty,
294: -- then amount must be greater than or equal to zero
295: -------------------------------------------------------------------------
296: PROCEDURE amount_blanket(
297: p_id_tbl IN po_tbl_number,
298: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
299: p_amount_tbl IN po_tbl_number,
300: x_results IN OUT NOCOPY po_validation_results_type,
301: x_result_type OUT NOCOPY VARCHAR2)

Line 299: p_amount_tbl IN po_tbl_number,

295: -------------------------------------------------------------------------
296: PROCEDURE amount_blanket(
297: p_id_tbl IN po_tbl_number,
298: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
299: p_amount_tbl IN po_tbl_number,
300: x_results IN OUT NOCOPY po_validation_results_type,
301: x_result_type OUT NOCOPY VARCHAR2)
302: IS
303: d_mod CONSTANT VARCHAR2(100) := d_amount_blanket;

Line 363: p_id_tbl IN po_tbl_number,

359: -- If services procurement is not enabled, the order_type_lookup_code cannot
360: -- be 'FIXED PRICE' or 'RATE'.
361: -------------------------------------------------------------------------
362: PROCEDURE order_type_lookup_code(
363: p_id_tbl IN po_tbl_number,
364: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
365: x_results IN OUT NOCOPY po_validation_results_type,
366: x_result_type OUT NOCOPY VARCHAR2)
367: IS

Line 418: p_id_tbl IN po_tbl_number,

414: -- contractor first name and last name fields could be populated;
415: -- otherwise, they should be empty
416: -------------------------------------------------------------------------
417: PROCEDURE contractor_name(
418: p_id_tbl IN po_tbl_number,
419: p_doc_type IN VARCHAR2,
420: p_purchase_basis_tbl IN po_tbl_varchar30,
421: p_contractor_last_name_tbl IN po_tbl_varchar2000,
422: p_contractor_first_name_tbl IN po_tbl_varchar2000,

Line 474: p_id_tbl IN po_tbl_number,

470: -------------------------------------------------------------------------
471: -- If purchase basis is TEMP LABOR, then job id must not be null
472: -------------------------------------------------------------------------
473: PROCEDURE job_id(
474: p_id_tbl IN po_tbl_number,
475: p_job_id_tbl IN po_tbl_number,
476: p_job_business_group_id_tbl IN po_tbl_number,
477: p_purchase_basis_tbl IN po_tbl_varchar30,
478: p_category_id_tbl IN po_tbl_number,

Line 475: p_job_id_tbl IN po_tbl_number,

471: -- If purchase basis is TEMP LABOR, then job id must not be null
472: -------------------------------------------------------------------------
473: PROCEDURE job_id(
474: p_id_tbl IN po_tbl_number,
475: p_job_id_tbl IN po_tbl_number,
476: p_job_business_group_id_tbl IN po_tbl_number,
477: p_purchase_basis_tbl IN po_tbl_varchar30,
478: p_category_id_tbl IN po_tbl_number,
479: x_result_set_id IN OUT NOCOPY NUMBER,

Line 476: p_job_business_group_id_tbl IN po_tbl_number,

472: -------------------------------------------------------------------------
473: PROCEDURE job_id(
474: p_id_tbl IN po_tbl_number,
475: p_job_id_tbl IN po_tbl_number,
476: p_job_business_group_id_tbl IN po_tbl_number,
477: p_purchase_basis_tbl IN po_tbl_varchar30,
478: p_category_id_tbl IN po_tbl_number,
479: x_result_set_id IN OUT NOCOPY NUMBER,
480: x_results IN OUT NOCOPY po_validation_results_type,

Line 478: p_category_id_tbl IN po_tbl_number,

474: p_id_tbl IN po_tbl_number,
475: p_job_id_tbl IN po_tbl_number,
476: p_job_business_group_id_tbl IN po_tbl_number,
477: p_purchase_basis_tbl IN po_tbl_varchar30,
478: p_category_id_tbl IN po_tbl_number,
479: x_result_set_id IN OUT NOCOPY NUMBER,
480: x_results IN OUT NOCOPY po_validation_results_type,
481: x_result_type OUT NOCOPY VARCHAR2)
482: IS

Line 676: p_id_tbl IN po_tbl_number,

672: -- If services procurement not enabled, order_type_lookup_code cannot be
673: -- 'FIXED PRICE' or 'RATE'
674: -------------------------------------------------------------------------
675: PROCEDURE job_business_group_id(
676: p_id_tbl IN po_tbl_number,
677: p_job_id_tbl IN po_tbl_number,
678: p_job_business_group_id_tbl IN po_tbl_number,
679: p_purchase_basis_tbl IN po_tbl_varchar30,
680: x_result_set_id IN OUT NOCOPY NUMBER,

Line 677: p_job_id_tbl IN po_tbl_number,

673: -- 'FIXED PRICE' or 'RATE'
674: -------------------------------------------------------------------------
675: PROCEDURE job_business_group_id(
676: p_id_tbl IN po_tbl_number,
677: p_job_id_tbl IN po_tbl_number,
678: p_job_business_group_id_tbl IN po_tbl_number,
679: p_purchase_basis_tbl IN po_tbl_varchar30,
680: x_result_set_id IN OUT NOCOPY NUMBER,
681: x_result_type OUT NOCOPY VARCHAR2)

Line 678: p_job_business_group_id_tbl IN po_tbl_number,

674: -------------------------------------------------------------------------
675: PROCEDURE job_business_group_id(
676: p_id_tbl IN po_tbl_number,
677: p_job_id_tbl IN po_tbl_number,
678: p_job_business_group_id_tbl IN po_tbl_number,
679: p_purchase_basis_tbl IN po_tbl_varchar30,
680: x_result_set_id IN OUT NOCOPY NUMBER,
681: x_result_type OUT NOCOPY VARCHAR2)
682: IS

Line 782: p_id_tbl IN po_tbl_number,

778: -------------------------------------------------------------------------
779: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
780: -------------------------------------------------------------------------
781: PROCEDURE capital_expense_flag(
782: p_id_tbl IN po_tbl_number,
783: p_purchase_basis_tbl IN po_tbl_varchar30,
784: p_capital_expense_flag_tbl IN po_tbl_varchar1,
785: x_results IN OUT NOCOPY po_validation_results_type,
786: x_result_type OUT NOCOPY VARCHAR2)

Line 832: p_id_tbl IN po_tbl_number,

828: -------------------------------------------------------------------------
829: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
830: -------------------------------------------------------------------------
831: PROCEDURE un_number_id(
832: p_id_tbl IN po_tbl_number,
833: p_purchase_basis_tbl IN po_tbl_varchar30,
834: p_un_number_id_tbl IN po_tbl_number,
835: x_result_set_id IN OUT NOCOPY NUMBER,
836: x_results IN OUT NOCOPY po_validation_results_type,

Line 834: p_un_number_id_tbl IN po_tbl_number,

830: -------------------------------------------------------------------------
831: PROCEDURE un_number_id(
832: p_id_tbl IN po_tbl_number,
833: p_purchase_basis_tbl IN po_tbl_varchar30,
834: p_un_number_id_tbl IN po_tbl_number,
835: x_result_set_id IN OUT NOCOPY NUMBER,
836: x_results IN OUT NOCOPY po_validation_results_type,
837: x_result_type OUT NOCOPY VARCHAR2)
838: IS

Line 923: p_id_tbl IN po_tbl_number,

919: -------------------------------------------------------------------------
920: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
921: -------------------------------------------------------------------------
922: PROCEDURE hazard_class_id(
923: p_id_tbl IN po_tbl_number,
924: p_purchase_basis_tbl IN po_tbl_varchar30,
925: p_hazard_class_id_tbl IN po_tbl_number,
926: x_result_set_id IN OUT NOCOPY NUMBER,
927: x_results IN OUT NOCOPY po_validation_results_type,

Line 925: p_hazard_class_id_tbl IN po_tbl_number,

921: -------------------------------------------------------------------------
922: PROCEDURE hazard_class_id(
923: p_id_tbl IN po_tbl_number,
924: p_purchase_basis_tbl IN po_tbl_varchar30,
925: p_hazard_class_id_tbl IN po_tbl_number,
926: x_result_set_id IN OUT NOCOPY NUMBER,
927: x_results IN OUT NOCOPY po_validation_results_type,
928: x_result_type OUT NOCOPY VARCHAR2)
929: IS

Line 1014: p_id_tbl IN po_tbl_number,

1010: -------------------------------------------------------------------------
1011: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
1012: -------------------------------------------------------------------------
1013: PROCEDURE item_id(
1014: p_id_tbl IN po_tbl_number,
1015: p_item_id_tbl IN po_tbl_number,
1016: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1017: p_line_type_id_tbl IN po_tbl_number,
1018: p_inventory_org_id IN NUMBER,

Line 1015: p_item_id_tbl IN po_tbl_number,

1011: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
1012: -------------------------------------------------------------------------
1013: PROCEDURE item_id(
1014: p_id_tbl IN po_tbl_number,
1015: p_item_id_tbl IN po_tbl_number,
1016: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1017: p_line_type_id_tbl IN po_tbl_number,
1018: p_inventory_org_id IN NUMBER,
1019: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1017: p_line_type_id_tbl IN po_tbl_number,

1013: PROCEDURE item_id(
1014: p_id_tbl IN po_tbl_number,
1015: p_item_id_tbl IN po_tbl_number,
1016: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1017: p_line_type_id_tbl IN po_tbl_number,
1018: p_inventory_org_id IN NUMBER,
1019: x_result_set_id IN OUT NOCOPY NUMBER,
1020: x_results IN OUT NOCOPY po_validation_results_type,
1021: x_result_type OUT NOCOPY VARCHAR2)

Line 1170: p_id_tbl IN po_tbl_number,

1166: -- from what is setup for the item. Would not allow item_description update if item attribute
1167: -- allow_item_desc_update_flag is N.
1168: -------------------------------------------------------------------------
1169: PROCEDURE item_description(
1170: p_id_tbl IN po_tbl_number,
1171: p_item_description_tbl IN po_tbl_varchar2000,
1172: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1173: p_item_id_tbl IN po_tbl_number,
1174: p_create_or_update_item IN VARCHAR2,

Line 1173: p_item_id_tbl IN po_tbl_number,

1169: PROCEDURE item_description(
1170: p_id_tbl IN po_tbl_number,
1171: p_item_description_tbl IN po_tbl_varchar2000,
1172: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1173: p_item_id_tbl IN po_tbl_number,
1174: p_create_or_update_item IN VARCHAR2,
1175: p_inventory_org_id IN NUMBER,
1176: x_result_set_id IN OUT NOCOPY NUMBER,
1177: x_result_type OUT NOCOPY VARCHAR2)

Line 1262: p_id_tbl IN po_tbl_number,

1258: -------------------------------------------------------------------------
1259: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
1260: -------------------------------------------------------------------------
1261: PROCEDURE unit_meas_lookup_code(
1262: p_id_tbl IN po_tbl_number,
1263: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1264: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1265: p_item_id_tbl IN po_tbl_number,
1266: p_line_type_id_tbl IN po_tbl_number,

Line 1265: p_item_id_tbl IN po_tbl_number,

1261: PROCEDURE unit_meas_lookup_code(
1262: p_id_tbl IN po_tbl_number,
1263: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1264: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1265: p_item_id_tbl IN po_tbl_number,
1266: p_line_type_id_tbl IN po_tbl_number,
1267: p_inventory_org_id IN NUMBER,
1268: x_result_set_id IN OUT NOCOPY NUMBER,
1269: x_results IN OUT NOCOPY po_validation_results_type,

Line 1266: p_line_type_id_tbl IN po_tbl_number,

1262: p_id_tbl IN po_tbl_number,
1263: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
1264: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1265: p_item_id_tbl IN po_tbl_number,
1266: p_line_type_id_tbl IN po_tbl_number,
1267: p_inventory_org_id IN NUMBER,
1268: x_result_set_id IN OUT NOCOPY NUMBER,
1269: x_results IN OUT NOCOPY po_validation_results_type,
1270: x_result_type OUT NOCOPY VARCHAR2)

Line 1500: p_id_tbl IN po_tbl_number,

1496: -- If order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
1497: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
1498: -------------------------------------------------------------------------
1499: PROCEDURE item_revision(
1500: p_id_tbl IN po_tbl_number,
1501: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1502: p_item_revision_tbl IN po_tbl_varchar5,
1503: p_item_id_tbl IN po_tbl_number,
1504: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1503: p_item_id_tbl IN po_tbl_number,

1499: PROCEDURE item_revision(
1500: p_id_tbl IN po_tbl_number,
1501: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1502: p_item_revision_tbl IN po_tbl_varchar5,
1503: p_item_id_tbl IN po_tbl_number,
1504: x_result_set_id IN OUT NOCOPY NUMBER,
1505: x_results IN OUT NOCOPY po_validation_results_type,
1506: x_result_type OUT NOCOPY VARCHAR2)
1507: IS

Line 1608: p_id_tbl IN po_tbl_number,

1604: -- 'Validate flag' ON. If Yes, we will validate the Category to exist in the 'Valid Category List'.
1605: -- If No, we will just validate if the category is Enable and Active.
1606: -------------------------------------------------------------------------
1607: PROCEDURE category_id(
1608: p_id_tbl IN po_tbl_number,
1609: p_category_id_tbl IN po_tbl_number,
1610: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1611: p_item_id_tbl IN po_tbl_number,
1612: p_inventory_org_id IN NUMBER,

Line 1609: p_category_id_tbl IN po_tbl_number,

1605: -- If No, we will just validate if the category is Enable and Active.
1606: -------------------------------------------------------------------------
1607: PROCEDURE category_id(
1608: p_id_tbl IN po_tbl_number,
1609: p_category_id_tbl IN po_tbl_number,
1610: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1611: p_item_id_tbl IN po_tbl_number,
1612: p_inventory_org_id IN NUMBER,
1613: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1611: p_item_id_tbl IN po_tbl_number,

1607: PROCEDURE category_id(
1608: p_id_tbl IN po_tbl_number,
1609: p_category_id_tbl IN po_tbl_number,
1610: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1611: p_item_id_tbl IN po_tbl_number,
1612: p_inventory_org_id IN NUMBER,
1613: x_result_set_id IN OUT NOCOPY NUMBER,
1614: x_results IN OUT NOCOPY po_validation_results_type,
1615: x_result_type OUT NOCOPY VARCHAR2)

Line 1804: p_id_tbl IN po_tbl_number,

1800: -- Validate ip_category_id is not empty for Blanket and Quotation;
1801: -- Validate ip_category_id is valid if not empty
1802: -------------------------------------------------------------------------
1803: PROCEDURE ip_category_id(
1804: p_id_tbl IN po_tbl_number,
1805: p_ip_category_id_tbl IN po_tbl_number,
1806: x_result_set_id IN OUT NOCOPY NUMBER,
1807: x_results IN OUT NOCOPY po_validation_results_type,
1808: x_result_type OUT NOCOPY VARCHAR2)

Line 1805: p_ip_category_id_tbl IN po_tbl_number,

1801: -- Validate ip_category_id is valid if not empty
1802: -------------------------------------------------------------------------
1803: PROCEDURE ip_category_id(
1804: p_id_tbl IN po_tbl_number,
1805: p_ip_category_id_tbl IN po_tbl_number,
1806: x_result_set_id IN OUT NOCOPY NUMBER,
1807: x_results IN OUT NOCOPY po_validation_results_type,
1808: x_result_type OUT NOCOPY VARCHAR2)
1809: IS

Line 1901: p_id_tbl IN po_tbl_number,

1897: -- unit_price should be the same as the one defined in the line_type.
1898: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
1899: -------------------------------------------------------------------------
1900: PROCEDURE unit_price(
1901: p_id_tbl IN po_tbl_number,
1902: p_unit_price_tbl IN po_tbl_number,
1903: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1904: p_line_type_id_tbl IN po_tbl_number,
1905: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1902: p_unit_price_tbl IN po_tbl_number,

1898: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
1899: -------------------------------------------------------------------------
1900: PROCEDURE unit_price(
1901: p_id_tbl IN po_tbl_number,
1902: p_unit_price_tbl IN po_tbl_number,
1903: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1904: p_line_type_id_tbl IN po_tbl_number,
1905: x_result_set_id IN OUT NOCOPY NUMBER,
1906: x_results IN OUT NOCOPY po_validation_results_type,

Line 1904: p_line_type_id_tbl IN po_tbl_number,

1900: PROCEDURE unit_price(
1901: p_id_tbl IN po_tbl_number,
1902: p_unit_price_tbl IN po_tbl_number,
1903: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
1904: p_line_type_id_tbl IN po_tbl_number,
1905: x_result_set_id IN OUT NOCOPY NUMBER,
1906: x_results IN OUT NOCOPY po_validation_results_type,
1907: x_result_type OUT NOCOPY VARCHAR2)
1908: IS

Line 2034: p_id_tbl IN po_tbl_number,

2030: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero
2031: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
2032: -------------------------------------------------------------------------
2033: PROCEDURE quantity(
2034: p_id_tbl IN po_tbl_number,
2035: p_quantity_tbl IN po_tbl_number,
2036: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2037: x_results IN OUT NOCOPY po_validation_results_type,
2038: x_result_type OUT NOCOPY VARCHAR2)

Line 2035: p_quantity_tbl IN po_tbl_number,

2031: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
2032: -------------------------------------------------------------------------
2033: PROCEDURE quantity(
2034: p_id_tbl IN po_tbl_number,
2035: p_quantity_tbl IN po_tbl_number,
2036: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2037: x_results IN OUT NOCOPY po_validation_results_type,
2038: x_result_type OUT NOCOPY VARCHAR2)
2039: IS

Line 2103: p_id_tbl IN po_tbl_number,

2099: -------------------------------------------------------------------------
2100: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
2101: -------------------------------------------------------------------------
2102: PROCEDURE amount(
2103: p_id_tbl IN po_tbl_number,
2104: p_amount_tbl IN po_tbl_number,
2105: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2106: x_results IN OUT NOCOPY po_validation_results_type,
2107: x_result_type OUT NOCOPY VARCHAR2)

Line 2104: p_amount_tbl IN po_tbl_number,

2100: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
2101: -------------------------------------------------------------------------
2102: PROCEDURE amount(
2103: p_id_tbl IN po_tbl_number,
2104: p_amount_tbl IN po_tbl_number,
2105: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2106: x_results IN OUT NOCOPY po_validation_results_type,
2107: x_result_type OUT NOCOPY VARCHAR2)
2108: IS

Line 2156: p_id_tbl IN po_tbl_number,

2152: -------------------------------------------------------------------------
2153: -- For rate based temp labor line, the currency rate_type cannot be 'user'
2154: -------------------------------------------------------------------------
2155: PROCEDURE rate_type(
2156: p_id_tbl IN po_tbl_number,
2157: p_rate_type_tbl IN po_tbl_varchar30,
2158: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2159: x_results IN OUT NOCOPY po_validation_results_type,
2160: x_result_type OUT NOCOPY VARCHAR2)

Line 2208: p_id_tbl IN po_tbl_number,

2204: -- Line num must be populated and cannot be <= 0.
2205: -- Line num has to be unique in a requisition.
2206: -------------------------------------------------------------------------
2207: PROCEDURE line_num(
2208: p_id_tbl IN po_tbl_number,
2209: p_po_header_id_tbl IN po_tbl_number,
2210: p_line_num_tbl IN po_tbl_number,
2211: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752

Line 2209: p_po_header_id_tbl IN po_tbl_number,

2205: -- Line num has to be unique in a requisition.
2206: -------------------------------------------------------------------------
2207: PROCEDURE line_num(
2208: p_id_tbl IN po_tbl_number,
2209: p_po_header_id_tbl IN po_tbl_number,
2210: p_line_num_tbl IN po_tbl_number,
2211: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2213: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2210: p_line_num_tbl IN po_tbl_number,

2206: -------------------------------------------------------------------------
2207: PROCEDURE line_num(
2208: p_id_tbl IN po_tbl_number,
2209: p_po_header_id_tbl IN po_tbl_number,
2210: p_line_num_tbl IN po_tbl_number,
2211: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2213: x_result_set_id IN OUT NOCOPY NUMBER,
2214: x_results IN OUT NOCOPY po_validation_results_type,

Line 2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752

2208: p_id_tbl IN po_tbl_number,
2209: p_po_header_id_tbl IN po_tbl_number,
2210: p_line_num_tbl IN po_tbl_number,
2211: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2212: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
2213: x_result_set_id IN OUT NOCOPY NUMBER,
2214: x_results IN OUT NOCOPY po_validation_results_type,
2215: x_result_type OUT NOCOPY VARCHAR2)
2216: IS

Line 2333: p_id_tbl IN po_tbl_number,

2329: -------------------------------------------------------------------------
2330: -- Po_line_id must be populated and unique.
2331: -------------------------------------------------------------------------
2332: PROCEDURE po_line_id(
2333: p_id_tbl IN po_tbl_number,
2334: p_po_line_id_tbl IN po_tbl_number,
2335: p_po_header_id_tbl IN po_tbl_number,
2336: x_result_set_id IN OUT NOCOPY NUMBER,
2337: x_result_type OUT NOCOPY VARCHAR2)

Line 2334: p_po_line_id_tbl IN po_tbl_number,

2330: -- Po_line_id must be populated and unique.
2331: -------------------------------------------------------------------------
2332: PROCEDURE po_line_id(
2333: p_id_tbl IN po_tbl_number,
2334: p_po_line_id_tbl IN po_tbl_number,
2335: p_po_header_id_tbl IN po_tbl_number,
2336: x_result_set_id IN OUT NOCOPY NUMBER,
2337: x_result_type OUT NOCOPY VARCHAR2)
2338: IS

Line 2335: p_po_header_id_tbl IN po_tbl_number,

2331: -------------------------------------------------------------------------
2332: PROCEDURE po_line_id(
2333: p_id_tbl IN po_tbl_number,
2334: p_po_line_id_tbl IN po_tbl_number,
2335: p_po_header_id_tbl IN po_tbl_number,
2336: x_result_set_id IN OUT NOCOPY NUMBER,
2337: x_result_type OUT NOCOPY VARCHAR2)
2338: IS
2339: d_mod CONSTANT VARCHAR2(100) := d_po_line_id;

Line 2410: p_id_tbl IN po_tbl_number,

2406: -------------------------------------------------------------------------
2407: -- Line type id must be populated and exist in po_line_types_val_v
2408: -------------------------------------------------------------------------
2409: PROCEDURE line_type_id(
2410: p_id_tbl IN po_tbl_number,
2411: p_line_type_id_tbl IN po_tbl_number,
2412: x_result_set_id IN OUT NOCOPY NUMBER,
2413: x_result_type OUT NOCOPY VARCHAR2)
2414: IS

Line 2411: p_line_type_id_tbl IN po_tbl_number,

2407: -- Line type id must be populated and exist in po_line_types_val_v
2408: -------------------------------------------------------------------------
2409: PROCEDURE line_type_id(
2410: p_id_tbl IN po_tbl_number,
2411: p_line_type_id_tbl IN po_tbl_number,
2412: x_result_set_id IN OUT NOCOPY NUMBER,
2413: x_result_type OUT NOCOPY VARCHAR2)
2414: IS
2415: d_mod CONSTANT VARCHAR2(100) := d_line_type_id;

Line 2483: p_id_tbl IN po_tbl_number,

2479: -------------------------------------------------------------------------
2480: -- Validate style_id related information.
2481: -------------------------------------------------------------------------
2482: PROCEDURE style_related_info(
2483: p_id_tbl IN po_tbl_number,
2484: p_style_id_tbl IN po_tbl_number,
2485: p_line_type_id_tbl IN po_tbl_number,
2486: p_purchase_basis_tbl IN po_tbl_varchar30,
2487: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2484: p_style_id_tbl IN po_tbl_number,

2480: -- Validate style_id related information.
2481: -------------------------------------------------------------------------
2482: PROCEDURE style_related_info(
2483: p_id_tbl IN po_tbl_number,
2484: p_style_id_tbl IN po_tbl_number,
2485: p_line_type_id_tbl IN po_tbl_number,
2486: p_purchase_basis_tbl IN po_tbl_varchar30,
2487: x_result_set_id IN OUT NOCOPY NUMBER,
2488: x_result_type OUT NOCOPY VARCHAR2)

Line 2485: p_line_type_id_tbl IN po_tbl_number,

2481: -------------------------------------------------------------------------
2482: PROCEDURE style_related_info(
2483: p_id_tbl IN po_tbl_number,
2484: p_style_id_tbl IN po_tbl_number,
2485: p_line_type_id_tbl IN po_tbl_number,
2486: p_purchase_basis_tbl IN po_tbl_varchar30,
2487: x_result_set_id IN OUT NOCOPY NUMBER,
2488: x_result_type OUT NOCOPY VARCHAR2)
2489: IS

Line 2605: p_id_tbl IN po_tbl_number,

2601: -------------------------------------------------------------------------
2602: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
2603: -------------------------------------------------------------------------
2604: PROCEDURE price_type_lookup_code(
2605: p_id_tbl IN po_tbl_number,
2606: p_price_type_lookup_code_tbl IN po_tbl_varchar30,
2607: x_result_set_id IN OUT NOCOPY NUMBER,
2608: x_result_type OUT NOCOPY VARCHAR2)
2609: IS

Line 2678: p_id_tbl IN po_tbl_number,

2674: --Expiration date if provided should be later than the start date
2675: --If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2676: -------------------------------------------------------------------------
2677: PROCEDURE start_date_standard(
2678: p_id_tbl IN po_tbl_number,
2679: p_start_date_tbl IN po_tbl_date,
2680: p_expiration_date_tbl IN po_tbl_date,
2681: p_purchase_basis_tbl IN po_tbl_varchar30,
2682: x_results IN OUT NOCOPY po_validation_results_type,

Line 2762: p_id_tbl IN po_tbl_number,

2758: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null,
2759: -- then bom_item_type cannot be 1 or 2.
2760: -------------------------------------------------------------------------
2761: PROCEDURE item_id_standard(
2762: p_id_tbl IN po_tbl_number,
2763: p_item_id_tbl IN po_tbl_number,
2764: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2765: p_inventory_org_id IN NUMBER,
2766: x_result_set_id IN OUT NOCOPY NUMBER,

Line 2763: p_item_id_tbl IN po_tbl_number,

2759: -- then bom_item_type cannot be 1 or 2.
2760: -------------------------------------------------------------------------
2761: PROCEDURE item_id_standard(
2762: p_id_tbl IN po_tbl_number,
2763: p_item_id_tbl IN po_tbl_number,
2764: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2765: p_inventory_org_id IN NUMBER,
2766: x_result_set_id IN OUT NOCOPY NUMBER,
2767: x_result_type OUT NOCOPY VARCHAR2)

Line 2836: p_id_tbl IN po_tbl_number,

2832: -------------------------------------------------------------------------
2833: -- Quantity cannot be zero for SPO
2834: -------------------------------------------------------------------------
2835: PROCEDURE quantity_standard(
2836: p_id_tbl IN po_tbl_number,
2837: p_quantity_tbl IN po_tbl_number,
2838: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2839: x_results IN OUT NOCOPY po_validation_results_type,
2840: x_result_type OUT NOCOPY VARCHAR2)

Line 2837: p_quantity_tbl IN po_tbl_number,

2833: -- Quantity cannot be zero for SPO
2834: -------------------------------------------------------------------------
2835: PROCEDURE quantity_standard(
2836: p_id_tbl IN po_tbl_number,
2837: p_quantity_tbl IN po_tbl_number,
2838: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2839: x_results IN OUT NOCOPY po_validation_results_type,
2840: x_result_type OUT NOCOPY VARCHAR2)
2841: IS

Line 2894: p_id_tbl IN po_tbl_number,

2890: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE' and amount is not
2891: -- empty, amount value must be greater than zero
2892: -------------------------------------------------------------------------
2893: PROCEDURE amount_standard(
2894: p_id_tbl IN po_tbl_number,
2895: p_amount_tbl IN po_tbl_number,
2896: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2897: x_results IN OUT NOCOPY po_validation_results_type,
2898: x_result_type OUT NOCOPY VARCHAR2)

Line 2895: p_amount_tbl IN po_tbl_number,

2891: -- empty, amount value must be greater than zero
2892: -------------------------------------------------------------------------
2893: PROCEDURE amount_standard(
2894: p_id_tbl IN po_tbl_number,
2895: p_amount_tbl IN po_tbl_number,
2896: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2897: x_results IN OUT NOCOPY po_validation_results_type,
2898: x_result_type OUT NOCOPY VARCHAR2)
2899: IS

Line 2959: p_id_tbl IN po_tbl_number,

2955: -- Price break lookup code should be valid
2956: -------------------------------------------------------------------------
2957: -- bug5016163 START
2958: PROCEDURE price_break_lookup_code(
2959: p_id_tbl IN po_tbl_number,
2960: p_price_break_lookup_code_tbl IN po_tbl_varchar30,
2961: p_global_agreement_flag_tbl IN po_tbl_varchar1,
2962: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2963: p_purchase_basis_tbl IN po_tbl_varchar30,

Line 3068: p_id_tbl IN po_tbl_number,

3064: -- If allow_price_override_flag is 'N', then not_to_exceed_price has to be null.
3065: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3066: -------------------------------------------------------------------------
3067: PROCEDURE not_to_exceed_price(
3068: p_id_tbl IN po_tbl_number,
3069: p_not_to_exceed_price_tbl IN po_tbl_number,
3070: p_allow_price_override_tbl IN po_tbl_varchar1,
3071: p_unit_price_tbl IN po_tbl_number,
3072: x_results IN OUT NOCOPY po_validation_results_type,

Line 3069: p_not_to_exceed_price_tbl IN po_tbl_number,

3065: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3066: -------------------------------------------------------------------------
3067: PROCEDURE not_to_exceed_price(
3068: p_id_tbl IN po_tbl_number,
3069: p_not_to_exceed_price_tbl IN po_tbl_number,
3070: p_allow_price_override_tbl IN po_tbl_varchar1,
3071: p_unit_price_tbl IN po_tbl_number,
3072: x_results IN OUT NOCOPY po_validation_results_type,
3073: x_result_type OUT NOCOPY VARCHAR2)

Line 3071: p_unit_price_tbl IN po_tbl_number,

3067: PROCEDURE not_to_exceed_price(
3068: p_id_tbl IN po_tbl_number,
3069: p_not_to_exceed_price_tbl IN po_tbl_number,
3070: p_allow_price_override_tbl IN po_tbl_varchar1,
3071: p_unit_price_tbl IN po_tbl_number,
3072: x_results IN OUT NOCOPY po_validation_results_type,
3073: x_result_type OUT NOCOPY VARCHAR2)
3074: IS
3075: d_mod CONSTANT VARCHAR2(100) := d_not_to_exceed_price;

Line 3135: p_id_tbl IN po_tbl_number,

3131: -------------------------------------------------------------------------
3132: -- Validate ip_category_id is valid if not empty
3133: -------------------------------------------------------------------------
3134: PROCEDURE ip_category_id_update(
3135: p_id_tbl IN po_tbl_number,
3136: p_ip_category_id_tbl IN po_tbl_number,
3137: x_result_set_id IN OUT NOCOPY NUMBER,
3138: x_results IN OUT NOCOPY po_validation_results_type,
3139: x_result_type OUT NOCOPY VARCHAR2)

Line 3136: p_ip_category_id_tbl IN po_tbl_number,

3132: -- Validate ip_category_id is valid if not empty
3133: -------------------------------------------------------------------------
3134: PROCEDURE ip_category_id_update(
3135: p_id_tbl IN po_tbl_number,
3136: p_ip_category_id_tbl IN po_tbl_number,
3137: x_result_set_id IN OUT NOCOPY NUMBER,
3138: x_results IN OUT NOCOPY po_validation_results_type,
3139: x_result_type OUT NOCOPY VARCHAR2)
3140: IS

Line 3228: p_id_tbl IN po_tbl_number,

3224: -----------------------------------------------------------------------------
3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3226: -----------------------------------------------------------------------------
3227: PROCEDURE uom_update(
3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3230: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3231: p_po_header_id_tbl IN po_tbl_number,
3232: p_po_line_id_tbl IN po_tbl_number,

Line 3231: p_po_header_id_tbl IN po_tbl_number,

3227: PROCEDURE uom_update(
3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3230: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3231: p_po_header_id_tbl IN po_tbl_number,
3232: p_po_line_id_tbl IN po_tbl_number,
3233: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3234: x_result_type OUT NOCOPY VARCHAR2)
3235: IS

Line 3232: p_po_line_id_tbl IN po_tbl_number,

3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3230: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3231: p_po_header_id_tbl IN po_tbl_number,
3232: p_po_line_id_tbl IN po_tbl_number,
3233: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3234: x_result_type OUT NOCOPY VARCHAR2)
3235: IS
3236: d_mod CONSTANT VARCHAR2(100) := d_uom_update;

Line 3333: p_id_tbl IN po_tbl_number,

3329: -- Would not allow item_description update if item attribute allow_item_desc_update_flag is N.
3330: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.
3331: -------------------------------------------------------------------------
3332: PROCEDURE item_desc_update(
3333: p_id_tbl IN po_tbl_number,
3334: p_item_description_tbl IN po_tbl_varchar2000,
3335: p_item_id_tbl IN po_tbl_number,
3336: p_inventory_org_id IN NUMBER,
3337: p_po_header_id_tbl IN po_tbl_number,

Line 3335: p_item_id_tbl IN po_tbl_number,

3331: -------------------------------------------------------------------------
3332: PROCEDURE item_desc_update(
3333: p_id_tbl IN po_tbl_number,
3334: p_item_description_tbl IN po_tbl_varchar2000,
3335: p_item_id_tbl IN po_tbl_number,
3336: p_inventory_org_id IN NUMBER,
3337: p_po_header_id_tbl IN po_tbl_number,
3338: p_po_line_id_tbl IN po_tbl_number,
3339: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,

Line 3337: p_po_header_id_tbl IN po_tbl_number,

3333: p_id_tbl IN po_tbl_number,
3334: p_item_description_tbl IN po_tbl_varchar2000,
3335: p_item_id_tbl IN po_tbl_number,
3336: p_inventory_org_id IN NUMBER,
3337: p_po_header_id_tbl IN po_tbl_number,
3338: p_po_line_id_tbl IN po_tbl_number,
3339: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3340: x_result_type OUT NOCOPY VARCHAR2)
3341: IS

Line 3338: p_po_line_id_tbl IN po_tbl_number,

3334: p_item_description_tbl IN po_tbl_varchar2000,
3335: p_item_id_tbl IN po_tbl_number,
3336: p_inventory_org_id IN NUMBER,
3337: p_po_header_id_tbl IN po_tbl_number,
3338: p_po_line_id_tbl IN po_tbl_number,
3339: x_results IN OUT NOCOPY po_validation_results_type, x_result_set_id IN OUT NOCOPY NUMBER,
3340: x_result_type OUT NOCOPY VARCHAR2)
3341: IS
3342: d_mod CONSTANT VARCHAR2(100) := d_item_desc_update;

Line 3452: p_id_tbl IN po_tbl_number,

3448: ----------------------------------------------------------------------------------------
3449: -- Called in create case for Blanket AND SPO, negotiated_by_preparer must be 'Y' or 'N'.
3450: ----------------------------------------------------------------------------------------
3451: PROCEDURE negotiated_by_preparer(
3452: p_id_tbl IN po_tbl_number,
3453: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3454: x_results IN OUT NOCOPY po_validation_results_type,
3455: x_result_type OUT NOCOPY VARCHAR2)
3456: IS

Line 3501: p_id_tbl IN po_tbl_number,

3497: --------------------------------------------------------------------------------------
3498: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.
3499: --------------------------------------------------------------------------------------
3500: PROCEDURE negotiated_by_prep_update(
3501: p_id_tbl IN po_tbl_number,
3502: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
3503: x_results IN OUT NOCOPY po_validation_results_type,
3504: x_result_type OUT NOCOPY VARCHAR2)
3505: IS

Line 3561: p_id_tbl IN po_tbl_number,

3557: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id
3558: -- If change is allowed, the new category_id must be valid.
3559: -------------------------------------------------------------------------
3560: PROCEDURE category_id_update(
3561: p_id_tbl IN po_tbl_number,
3562: p_category_id_tbl IN po_tbl_number,
3563: p_po_line_id_tbl IN po_tbl_number,
3564: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3565: p_item_id_tbl IN po_tbl_number,

Line 3562: p_category_id_tbl IN po_tbl_number,

3558: -- If change is allowed, the new category_id must be valid.
3559: -------------------------------------------------------------------------
3560: PROCEDURE category_id_update(
3561: p_id_tbl IN po_tbl_number,
3562: p_category_id_tbl IN po_tbl_number,
3563: p_po_line_id_tbl IN po_tbl_number,
3564: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3565: p_item_id_tbl IN po_tbl_number,
3566: p_job_id_tbl IN po_tbl_number,

Line 3563: p_po_line_id_tbl IN po_tbl_number,

3559: -------------------------------------------------------------------------
3560: PROCEDURE category_id_update(
3561: p_id_tbl IN po_tbl_number,
3562: p_category_id_tbl IN po_tbl_number,
3563: p_po_line_id_tbl IN po_tbl_number,
3564: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3565: p_item_id_tbl IN po_tbl_number,
3566: p_job_id_tbl IN po_tbl_number,
3567: p_inventory_org_id IN NUMBER,

Line 3565: p_item_id_tbl IN po_tbl_number,

3561: p_id_tbl IN po_tbl_number,
3562: p_category_id_tbl IN po_tbl_number,
3563: p_po_line_id_tbl IN po_tbl_number,
3564: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3565: p_item_id_tbl IN po_tbl_number,
3566: p_job_id_tbl IN po_tbl_number,
3567: p_inventory_org_id IN NUMBER,
3568: x_result_set_id IN OUT NOCOPY NUMBER,
3569: x_results IN OUT NOCOPY po_validation_results_type,

Line 3566: p_job_id_tbl IN po_tbl_number,

3562: p_category_id_tbl IN po_tbl_number,
3563: p_po_line_id_tbl IN po_tbl_number,
3564: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
3565: p_item_id_tbl IN po_tbl_number,
3566: p_job_id_tbl IN po_tbl_number,
3567: p_inventory_org_id IN NUMBER,
3568: x_result_set_id IN OUT NOCOPY NUMBER,
3569: x_results IN OUT NOCOPY po_validation_results_type,
3570: x_result_type OUT NOCOPY VARCHAR2)

Line 3668: ( p_id_tbl IN po_tbl_number,

3664: -------------------------------------------------------------------------
3665: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3666: -------------------------------------------------------------------------
3667: PROCEDURE unit_price_update
3668: ( p_id_tbl IN po_tbl_number,
3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3670: p_draft_id_tbl IN po_tbl_number,
3671: p_unit_price_tbl IN po_tbl_number,
3672: x_results IN OUT NOCOPY po_validation_results_type,

Line 3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206

3665: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3666: -------------------------------------------------------------------------
3667: PROCEDURE unit_price_update
3668: ( p_id_tbl IN po_tbl_number,
3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3670: p_draft_id_tbl IN po_tbl_number,
3671: p_unit_price_tbl IN po_tbl_number,
3672: x_results IN OUT NOCOPY po_validation_results_type,
3673: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206

Line 3670: p_draft_id_tbl IN po_tbl_number,

3666: -------------------------------------------------------------------------
3667: PROCEDURE unit_price_update
3668: ( p_id_tbl IN po_tbl_number,
3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3670: p_draft_id_tbl IN po_tbl_number,
3671: p_unit_price_tbl IN po_tbl_number,
3672: x_results IN OUT NOCOPY po_validation_results_type,
3673: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3674: x_result_type OUT NOCOPY VARCHAR2

Line 3671: p_unit_price_tbl IN po_tbl_number,

3667: PROCEDURE unit_price_update
3668: ( p_id_tbl IN po_tbl_number,
3669: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3670: p_draft_id_tbl IN po_tbl_number,
3671: p_unit_price_tbl IN po_tbl_number,
3672: x_results IN OUT NOCOPY po_validation_results_type,
3673: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3674: x_result_type OUT NOCOPY VARCHAR2
3675: )

Line 3822: ( p_id_tbl IN po_tbl_number,

3818: -------------------------------------------------------------------------
3819: -- In the UPDATE case, amount should not be udpated if it's not 'FIXED PRICE'
3820: -------------------------------------------------------------------------
3821: PROCEDURE amount_update
3822: ( p_id_tbl IN po_tbl_number,
3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3824: p_draft_id_tbl IN po_tbl_number,
3825: p_amount_tbl IN po_tbl_number,
3826: x_results IN OUT NOCOPY po_validation_results_type,

Line 3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206

3819: -- In the UPDATE case, amount should not be udpated if it's not 'FIXED PRICE'
3820: -------------------------------------------------------------------------
3821: PROCEDURE amount_update
3822: ( p_id_tbl IN po_tbl_number,
3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3824: p_draft_id_tbl IN po_tbl_number,
3825: p_amount_tbl IN po_tbl_number,
3826: x_results IN OUT NOCOPY po_validation_results_type,
3827: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206

Line 3824: p_draft_id_tbl IN po_tbl_number,

3820: -------------------------------------------------------------------------
3821: PROCEDURE amount_update
3822: ( p_id_tbl IN po_tbl_number,
3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3824: p_draft_id_tbl IN po_tbl_number,
3825: p_amount_tbl IN po_tbl_number,
3826: x_results IN OUT NOCOPY po_validation_results_type,
3827: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3828: x_result_type OUT NOCOPY VARCHAR2

Line 3825: p_amount_tbl IN po_tbl_number,

3821: PROCEDURE amount_update
3822: ( p_id_tbl IN po_tbl_number,
3823: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
3824: p_draft_id_tbl IN po_tbl_number,
3825: p_amount_tbl IN po_tbl_number,
3826: x_results IN OUT NOCOPY po_validation_results_type,
3827: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
3828: x_result_type OUT NOCOPY VARCHAR2
3829: )