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

Line 37: p_id_tbl IN po_tbl_number,

33: -- po_header_id cannot be null and must not exist in Transaction header table.
34: -- Called for the create case.
35: -------------------------------------------------------------------------
36: PROCEDURE po_header_id(
37: p_id_tbl IN po_tbl_number,
38: p_po_header_id_tbl IN po_tbl_number,
39: x_result_set_id IN OUT NOCOPY NUMBER,
40: x_result_type OUT NOCOPY VARCHAR2)
41: IS

Line 38: p_po_header_id_tbl IN po_tbl_number,

34: -- Called for the create case.
35: -------------------------------------------------------------------------
36: PROCEDURE po_header_id(
37: p_id_tbl IN po_tbl_number,
38: p_po_header_id_tbl IN po_tbl_number,
39: x_result_set_id IN OUT NOCOPY NUMBER,
40: x_result_type OUT NOCOPY VARCHAR2)
41: IS
42: d_mod CONSTANT VARCHAR2(100) := d_po_header_id;

Line 109: p_id_tbl IN po_tbl_number,

105: -----------------------------------------------------------------------------------------
106: -- document_num must not be null, must be unique, greater than or equal to zero and be of the correct type.
107: -----------------------------------------------------------------------------------------
108: PROCEDURE document_num(
109: p_id_tbl IN po_tbl_number,
110: p_po_header_id_tbl IN po_tbl_number,
111: p_document_num_tbl IN po_tbl_varchar30,
112: p_type_lookup_code_tbl IN po_tbl_varchar30,
113: p_manual_po_num_type IN VARCHAR2,

Line 110: p_po_header_id_tbl IN po_tbl_number,

106: -- document_num must not be null, must be unique, greater than or equal to zero and be of the correct type.
107: -----------------------------------------------------------------------------------------
108: PROCEDURE document_num(
109: p_id_tbl IN po_tbl_number,
110: p_po_header_id_tbl IN po_tbl_number,
111: p_document_num_tbl IN po_tbl_varchar30,
112: p_type_lookup_code_tbl IN po_tbl_varchar30,
113: p_manual_po_num_type IN VARCHAR2,
114: p_manual_quote_num_type IN VARCHAR2,

Line 261: p_id_tbl IN po_tbl_number,

257: -- type_lookup_code cannot be null and must be equal to
258: -- BLANKET, STANDARD or QUOTATION.
259: -------------------------------------------------------------------------
260: PROCEDURE type_lookup_code(
261: p_id_tbl IN po_tbl_number,
262: p_type_lookup_code_tbl IN po_tbl_varchar30,
263: x_results IN OUT NOCOPY po_validation_results_type,
264: x_result_type OUT NOCOPY VARCHAR2)
265: IS

Line 323: p_id_tbl IN po_tbl_number,

319: -------------------------------------------------------------------------
320: -- validate currency_code not null and against FND_CURRENCIES.
321: -------------------------------------------------------------------------
322: PROCEDURE currency_code(
323: p_id_tbl IN po_tbl_number,
324: p_currency_code_tbl IN po_tbl_varchar30,
325: x_result_set_id IN OUT NOCOPY NUMBER,
326: x_result_type OUT NOCOPY VARCHAR2)
327: IS

Line 404: p_id_tbl IN po_tbl_number,

400: -- validate rate_type against gl_daily_conversion_type_v, validate rate is not null and positive,
401: -- validate rate against g1_currency_api.get_rate().
402: -------------------------------------------------------------------------
403: PROCEDURE rate_info(
404: p_id_tbl IN po_tbl_number,
405: p_currency_code_tbl IN po_tbl_varchar30,
406: p_rate_type_tbl IN po_tbl_varchar30,
407: p_rate_tbl IN po_tbl_number,
408: p_rate_date_tbl IN po_tbl_date,

Line 407: p_rate_tbl IN po_tbl_number,

403: PROCEDURE rate_info(
404: p_id_tbl IN po_tbl_number,
405: p_currency_code_tbl IN po_tbl_varchar30,
406: p_rate_type_tbl IN po_tbl_varchar30,
407: p_rate_tbl IN po_tbl_number,
408: p_rate_date_tbl IN po_tbl_date,
409: p_func_currency_code IN VARCHAR2,
410: p_set_of_books_id IN NUMBER,
411: x_result_set_id IN OUT NOCOPY NUMBER,

Line 617: p_id_tbl IN po_tbl_number,

613: -------------------------------------------------------------------------
614: -- Agent Id must not be null and validate against PO_AGENTS.
615: -------------------------------------------------------------------------
616: PROCEDURE agent_id(
617: p_id_tbl IN po_tbl_number,
618: p_agent_id_tbl IN po_tbl_number,
619: x_result_set_id IN OUT NOCOPY NUMBER,
620: x_result_type OUT NOCOPY VARCHAR2)
621: IS

Line 618: p_agent_id_tbl IN po_tbl_number,

614: -- Agent Id must not be null and validate against PO_AGENTS.
615: -------------------------------------------------------------------------
616: PROCEDURE agent_id(
617: p_id_tbl IN po_tbl_number,
618: p_agent_id_tbl IN po_tbl_number,
619: x_result_set_id IN OUT NOCOPY NUMBER,
620: x_result_type OUT NOCOPY VARCHAR2)
621: IS
622: d_mod CONSTANT VARCHAR2(100) := d_agent_id;

Line 699: p_id_tbl IN po_tbl_number,

695: -- validate vendor_contact_id using po_vendor_contacts
696: -- validate vendor site CCR if approval status is APPROVED.
697: -------------------------------------------------------------------------
698: PROCEDURE vendor_info(
699: p_id_tbl IN po_tbl_number,
700: p_vendor_id_tbl IN po_tbl_number,
701: p_vendor_site_id_tbl IN po_tbl_number,
702: p_vendor_contact_id_tbl IN po_tbl_number,
703: p_federal_instance IN VARCHAR,

Line 700: p_vendor_id_tbl IN po_tbl_number,

696: -- validate vendor site CCR if approval status is APPROVED.
697: -------------------------------------------------------------------------
698: PROCEDURE vendor_info(
699: p_id_tbl IN po_tbl_number,
700: p_vendor_id_tbl IN po_tbl_number,
701: p_vendor_site_id_tbl IN po_tbl_number,
702: p_vendor_contact_id_tbl IN po_tbl_number,
703: p_federal_instance IN VARCHAR,
704: x_result_set_id IN OUT NOCOPY NUMBER,

Line 701: p_vendor_site_id_tbl IN po_tbl_number,

697: -------------------------------------------------------------------------
698: PROCEDURE vendor_info(
699: p_id_tbl IN po_tbl_number,
700: p_vendor_id_tbl IN po_tbl_number,
701: p_vendor_site_id_tbl IN po_tbl_number,
702: p_vendor_contact_id_tbl IN po_tbl_number,
703: p_federal_instance IN VARCHAR,
704: x_result_set_id IN OUT NOCOPY NUMBER,
705: x_results IN OUT NOCOPY po_validation_results_type,

Line 702: p_vendor_contact_id_tbl IN po_tbl_number,

698: PROCEDURE vendor_info(
699: p_id_tbl IN po_tbl_number,
700: p_vendor_id_tbl IN po_tbl_number,
701: p_vendor_site_id_tbl IN po_tbl_number,
702: p_vendor_contact_id_tbl IN po_tbl_number,
703: p_federal_instance IN VARCHAR,
704: x_result_set_id IN OUT NOCOPY NUMBER,
705: x_results IN OUT NOCOPY po_validation_results_type,
706: x_result_type OUT NOCOPY VARCHAR2)

Line 907: p_id_tbl IN po_tbl_number,

903: -------------------------------------------------------------------------
904: -- ShipToLocationId must not be null and valid in HR_LOCATIONS.
905: -------------------------------------------------------------------------
906: PROCEDURE ship_to_location_id(
907: p_id_tbl IN po_tbl_number,
908: p_ship_to_location_id_tbl IN po_tbl_number,
909: -- Bug 7007502: Added new param p_type_lookup_code_tbl
910: p_type_lookup_code_tbl IN po_tbl_varchar30,
911: x_result_set_id IN OUT NOCOPY NUMBER,

Line 908: p_ship_to_location_id_tbl IN po_tbl_number,

904: -- ShipToLocationId must not be null and valid in HR_LOCATIONS.
905: -------------------------------------------------------------------------
906: PROCEDURE ship_to_location_id(
907: p_id_tbl IN po_tbl_number,
908: p_ship_to_location_id_tbl IN po_tbl_number,
909: -- Bug 7007502: Added new param p_type_lookup_code_tbl
910: p_type_lookup_code_tbl IN po_tbl_varchar30,
911: x_result_set_id IN OUT NOCOPY NUMBER,
912: x_result_type OUT NOCOPY VARCHAR2)

Line 990: p_id_tbl IN po_tbl_number,

986: -------------------------------------------------------------------------
987: -- BillToLocationId must not be null and validate against HR_LOCATIONS.
988: -------------------------------------------------------------------------
989: PROCEDURE bill_to_location_id(
990: p_id_tbl IN po_tbl_number,
991: p_bill_to_location_id_tbl IN po_tbl_number,
992: -- Bug 7007502: Added new param p_type_lookup_code_tbl
993: p_type_lookup_code_tbl IN po_tbl_varchar30,
994: x_result_set_id IN OUT NOCOPY NUMBER,

Line 991: p_bill_to_location_id_tbl IN po_tbl_number,

987: -- BillToLocationId must not be null and validate against HR_LOCATIONS.
988: -------------------------------------------------------------------------
989: PROCEDURE bill_to_location_id(
990: p_id_tbl IN po_tbl_number,
991: p_bill_to_location_id_tbl IN po_tbl_number,
992: -- Bug 7007502: Added new param p_type_lookup_code_tbl
993: p_type_lookup_code_tbl IN po_tbl_varchar30,
994: x_result_set_id IN OUT NOCOPY NUMBER,
995: x_result_type OUT NOCOPY VARCHAR2)

Line 1073: p_id_tbl IN po_tbl_number,

1069: -------------------------------------------------------------------------
1070: -- validate ship_via_lookup_code against ORG_FREIGHT
1071: -------------------------------------------------------------------------
1072: PROCEDURE ship_via_lookup_code(
1073: p_id_tbl IN po_tbl_number,
1074: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,
1075: p_inventory_org_id IN NUMBER,
1076: x_result_set_id IN OUT NOCOPY NUMBER,
1077: x_result_type OUT NOCOPY VARCHAR2)

Line 1146: p_id_tbl IN po_tbl_number,

1142: -------------------------------------------------------------------------
1143: -- validate fob_lookup_code against PO_LOOKUP_CODES
1144: -------------------------------------------------------------------------
1145: PROCEDURE fob_lookup_code(
1146: p_id_tbl IN po_tbl_number,
1147: p_fob_lookup_code_tbl IN po_tbl_varchar30,
1148: x_result_set_id IN OUT NOCOPY NUMBER,
1149: x_result_type OUT NOCOPY VARCHAR2)
1150: IS

Line 1217: p_id_tbl IN po_tbl_number,

1213: -------------------------------------------------------------------------
1214: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES
1215: -------------------------------------------------------------------------
1216: PROCEDURE freight_terms_lookup_code(
1217: p_id_tbl IN po_tbl_number,
1218: p_freight_terms_lookup_tbl IN po_tbl_varchar30,
1219: x_result_set_id IN OUT NOCOPY NUMBER,
1220: x_result_type OUT NOCOPY VARCHAR2)
1221: IS

Line 1288: p_id_tbl IN po_tbl_number,

1284: -------------------------------------------------------------------------
1285: -- validate shipping_control against PO_LOOKUP_CODES
1286: -------------------------------------------------------------------------
1287: PROCEDURE shipping_control(
1288: p_id_tbl IN po_tbl_number,
1289: p_shipping_control_tbl IN po_tbl_varchar30,
1290: x_result_set_id IN OUT NOCOPY NUMBER,
1291: x_result_type OUT NOCOPY VARCHAR2)
1292: IS

Line 1360: p_id_tbl IN po_tbl_number,

1356: -- validate acceptance_due_date is not null if acceptance_required_flag = Y.
1357: -- Only called for Blanket and SPO.
1358: -------------------------------------------------------------------------
1359: PROCEDURE acceptance_due_date(
1360: p_id_tbl IN po_tbl_number,
1361: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1362: p_acceptance_due_date_tbl IN po_tbl_date,
1363: x_results IN OUT NOCOPY po_validation_results_type,
1364: x_result_type OUT NOCOPY VARCHAR2)

Line 1415: p_id_tbl IN po_tbl_number,

1411: -------------------------------------------------------------------------
1412: -- validate cancel_flag = N. Only called for Blanket and SPO.
1413: -------------------------------------------------------------------------
1414: PROCEDURE cancel_flag(
1415: p_id_tbl IN po_tbl_number,
1416: p_cancel_flag_tbl IN po_tbl_varchar1,
1417: x_results IN OUT NOCOPY po_validation_results_type,
1418: x_result_type OUT NOCOPY VARCHAR2)
1419: IS

Line 1468: p_id_tbl IN po_tbl_number,

1464: -------------------------------------------------------------------------
1465: -- validate closed_code = OPEN. Only called for Blanket and SPO.
1466: -------------------------------------------------------------------------
1467: PROCEDURE closed_code(
1468: p_id_tbl IN po_tbl_number,
1469: p_closed_code_tbl IN po_tbl_varchar30,
1470: p_acceptance_reqd_flag_tbl IN po_tbl_varchar1,
1471: x_results IN OUT NOCOPY po_validation_results_type,
1472: x_result_type OUT NOCOPY VARCHAR2)

Line 1523: p_id_tbl IN po_tbl_number,

1519: -------------------------------------------------------------------------
1520: -- validate print_count = 0. Only called for Blanket and SPO.
1521: -------------------------------------------------------------------------
1522: PROCEDURE print_count(
1523: p_id_tbl IN po_tbl_number,
1524: p_print_count_tbl IN po_tbl_number,
1525: p_approval_status_tbl IN po_tbl_varchar30,
1526: x_results IN OUT NOCOPY po_validation_results_type,
1527: x_result_type OUT NOCOPY VARCHAR2)

Line 1524: p_print_count_tbl IN po_tbl_number,

1520: -- validate print_count = 0. Only called for Blanket and SPO.
1521: -------------------------------------------------------------------------
1522: PROCEDURE print_count(
1523: p_id_tbl IN po_tbl_number,
1524: p_print_count_tbl IN po_tbl_number,
1525: p_approval_status_tbl IN po_tbl_varchar30,
1526: x_results IN OUT NOCOPY po_validation_results_type,
1527: x_result_type OUT NOCOPY VARCHAR2)
1528: IS

Line 1578: p_id_tbl IN po_tbl_number,

1574: -- validate approval_status = INCOMPLETE, APPROVED, INITIATE APPROVAL.
1575: -- Only called for Blanket and SPO.
1576: -------------------------------------------------------------------------
1577: PROCEDURE approval_status(
1578: p_id_tbl IN po_tbl_number,
1579: p_approval_status_tbl IN po_tbl_varchar30,
1580: x_results IN OUT NOCOPY po_validation_results_type,
1581: x_result_type OUT NOCOPY VARCHAR2)
1582: IS

Line 1626: p_id_tbl IN po_tbl_number,

1622: -------------------------------------------------------------------------
1623: -- validate amount_to_encumber > 0
1624: -------------------------------------------------------------------------
1625: PROCEDURE amount_to_encumber(
1626: p_id_tbl IN po_tbl_number,
1627: p_amount_to_encumber_tbl IN po_tbl_number,
1628: x_results IN OUT NOCOPY po_validation_results_type,
1629: x_result_type OUT NOCOPY VARCHAR2)
1630: IS

Line 1627: p_amount_to_encumber_tbl IN po_tbl_number,

1623: -- validate amount_to_encumber > 0
1624: -------------------------------------------------------------------------
1625: PROCEDURE amount_to_encumber(
1626: p_id_tbl IN po_tbl_number,
1627: p_amount_to_encumber_tbl IN po_tbl_number,
1628: x_results IN OUT NOCOPY po_validation_results_type,
1629: x_result_type OUT NOCOPY VARCHAR2)
1630: IS
1631: d_mod CONSTANT VARCHAR2(100) := d_amount_to_encumber;

Line 1678: p_id_tbl IN po_tbl_number,

1674: -------------------------------------------------------------------------------------
1675: -- Validate style_id exists in system, is active and is not enabled for complex work.
1676: -------------------------------------------------------------------------------------
1677: PROCEDURE style_id(
1678: p_id_tbl IN po_tbl_number,
1679: p_style_id_tbl IN po_tbl_number,
1680: x_result_set_id IN OUT NOCOPY NUMBER,
1681: x_result_type OUT NOCOPY VARCHAR2)
1682: IS

Line 1679: p_style_id_tbl IN po_tbl_number,

1675: -- Validate style_id exists in system, is active and is not enabled for complex work.
1676: -------------------------------------------------------------------------------------
1677: PROCEDURE style_id(
1678: p_id_tbl IN po_tbl_number,
1679: p_style_id_tbl IN po_tbl_number,
1680: x_result_set_id IN OUT NOCOPY NUMBER,
1681: x_result_type OUT NOCOPY VARCHAR2)
1682: IS
1683: d_mod CONSTANT VARCHAR2(100) := d_style_id;

Line 1784: ( p_id_tbl IN PO_TBL_NUMBER,

1780: -------------------------------------------------------------------------
1781: -- validate that acceptance_reuqired_flag has correct value
1782: -------------------------------------------------------------------------
1783: PROCEDURE acceptance_required_flag
1784: ( p_id_tbl IN PO_TBL_NUMBER,
1785: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
1786: p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
1787: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1788: x_result_type OUT NOCOPY VARCHAR2

Line 1865: ( p_id_tbl IN PO_TBL_NUMBER,

1861: -------------------------------------------------------------------------
1862: -- validate that amount limit is valid
1863: -------------------------------------------------------------------------
1864: PROCEDURE amount_limit
1865: ( p_id_tbl IN PO_TBL_NUMBER,
1866: p_amount_limit_tbl IN PO_TBL_NUMBER,
1867: p_amount_agreed_tbl IN PO_TBL_NUMBER,
1868: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1869: x_result_type OUT NOCOPY VARCHAR2

Line 1866: p_amount_limit_tbl IN PO_TBL_NUMBER,

1862: -- validate that amount limit is valid
1863: -------------------------------------------------------------------------
1864: PROCEDURE amount_limit
1865: ( p_id_tbl IN PO_TBL_NUMBER,
1866: p_amount_limit_tbl IN PO_TBL_NUMBER,
1867: p_amount_agreed_tbl IN PO_TBL_NUMBER,
1868: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1869: x_result_type OUT NOCOPY VARCHAR2
1870: ) IS

Line 1867: p_amount_agreed_tbl IN PO_TBL_NUMBER,

1863: -------------------------------------------------------------------------
1864: PROCEDURE amount_limit
1865: ( p_id_tbl IN PO_TBL_NUMBER,
1866: p_amount_limit_tbl IN PO_TBL_NUMBER,
1867: p_amount_agreed_tbl IN PO_TBL_NUMBER,
1868: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1869: x_result_type OUT NOCOPY VARCHAR2
1870: ) IS
1871: d_mod CONSTANT VARCHAR2(100) := d_amount_limit;