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_DOCUMENT_CHECKS_GRP dependencies on PO_TBL_VARCHAR30

Line 949: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,

945: PROCEDURE validate_status_check_inputs (
946: p_api_version IN NUMBER,
947: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
948: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
949: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
950: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
951: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
952: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
953: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,

Line 950: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,

946: p_api_version IN NUMBER,
947: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
948: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
949: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
950: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
951: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
952: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
953: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
954: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,

Line 951: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,

947: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
948: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
949: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
950: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
951: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
952: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
953: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
954: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
955: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,

Line 952: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,

948: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
949: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
950: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
951: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
952: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
953: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
954: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
955: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
956: p_mode IN VARCHAR2,

Line 966: l_dummy_table_varchar30 po_tbl_varchar30 := po_tbl_varchar30();

962: l_api_name CONSTANT VARCHAR(30) := 'VALIDATE_STATUS_CHECK_INPUTS';
963: l_progress VARCHAR2(3) := '000';
964: l_count NUMBER;
965: l_dummy_table_number po_tbl_number := po_tbl_number();
966: l_dummy_table_varchar30 po_tbl_varchar30 := po_tbl_varchar30();
967:
968: BEGIN
969:
970: --Initialize l_count to length of first non-null Required Input Table

Line 1089: p_document_type IN PO_TBL_VARCHAR30,

1085: PROCEDURE po_status_check (
1086: p_api_version IN NUMBER,
1087: p_header_id IN PO_TBL_NUMBER,
1088: p_release_id IN PO_TBL_NUMBER,
1089: p_document_type IN PO_TBL_VARCHAR30,
1090: p_document_subtype IN PO_TBL_VARCHAR30,
1091: p_document_num IN PO_TBL_VARCHAR30,
1092: p_vendor_order_num IN PO_TBL_VARCHAR30,
1093: p_line_id IN PO_TBL_NUMBER,

Line 1090: p_document_subtype IN PO_TBL_VARCHAR30,

1086: p_api_version IN NUMBER,
1087: p_header_id IN PO_TBL_NUMBER,
1088: p_release_id IN PO_TBL_NUMBER,
1089: p_document_type IN PO_TBL_VARCHAR30,
1090: p_document_subtype IN PO_TBL_VARCHAR30,
1091: p_document_num IN PO_TBL_VARCHAR30,
1092: p_vendor_order_num IN PO_TBL_VARCHAR30,
1093: p_line_id IN PO_TBL_NUMBER,
1094: p_line_location_id IN PO_TBL_NUMBER,

Line 1091: p_document_num IN PO_TBL_VARCHAR30,

1087: p_header_id IN PO_TBL_NUMBER,
1088: p_release_id IN PO_TBL_NUMBER,
1089: p_document_type IN PO_TBL_VARCHAR30,
1090: p_document_subtype IN PO_TBL_VARCHAR30,
1091: p_document_num IN PO_TBL_VARCHAR30,
1092: p_vendor_order_num IN PO_TBL_VARCHAR30,
1093: p_line_id IN PO_TBL_NUMBER,
1094: p_line_location_id IN PO_TBL_NUMBER,
1095: p_distribution_id IN PO_TBL_NUMBER,

Line 1092: p_vendor_order_num IN PO_TBL_VARCHAR30,

1088: p_release_id IN PO_TBL_NUMBER,
1089: p_document_type IN PO_TBL_VARCHAR30,
1090: p_document_subtype IN PO_TBL_VARCHAR30,
1091: p_document_num IN PO_TBL_VARCHAR30,
1092: p_vendor_order_num IN PO_TBL_VARCHAR30,
1093: p_line_id IN PO_TBL_NUMBER,
1094: p_line_location_id IN PO_TBL_NUMBER,
1095: p_distribution_id IN PO_TBL_NUMBER,
1096: p_mode IN VARCHAR2,

Line 1107: l_document_type PO_TBL_VARCHAR30 := p_document_type;

1103: ) IS
1104:
1105: l_header_id PO_TBL_NUMBER := p_header_id;
1106: l_release_id PO_TBL_NUMBER := p_release_id;
1107: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1108: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1109: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1110: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1111: l_line_id PO_TBL_NUMBER := p_line_id;

Line 1108: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;

1104:
1105: l_header_id PO_TBL_NUMBER := p_header_id;
1106: l_release_id PO_TBL_NUMBER := p_release_id;
1107: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1108: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1109: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1110: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1111: l_line_id PO_TBL_NUMBER := p_line_id;
1112: l_line_location_id PO_TBL_NUMBER := p_line_location_id;

Line 1109: l_document_num PO_TBL_VARCHAR30 := p_document_num;

1105: l_header_id PO_TBL_NUMBER := p_header_id;
1106: l_release_id PO_TBL_NUMBER := p_release_id;
1107: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1108: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1109: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1110: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1111: l_line_id PO_TBL_NUMBER := p_line_id;
1112: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1113: l_distribution_id PO_TBL_NUMBER := p_distribution_id;

Line 1110: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;

1106: l_release_id PO_TBL_NUMBER := p_release_id;
1107: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1108: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1109: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1110: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1111: l_line_id PO_TBL_NUMBER := p_line_id;
1112: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1113: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1114:

Line 1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),

1233: PO_DOCUMENT_CHECKS_GRP.po_status_check(
1234: p_api_version => p_api_version,
1235: p_header_id => PO_TBL_NUMBER(p_header_id),
1236: p_release_id => PO_TBL_NUMBER(p_release_id),
1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1238: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1239: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1240: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1241: p_line_id => PO_TBL_NUMBER(p_line_id),

Line 1238: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),

1234: p_api_version => p_api_version,
1235: p_header_id => PO_TBL_NUMBER(p_header_id),
1236: p_release_id => PO_TBL_NUMBER(p_release_id),
1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1238: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1239: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1240: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1241: p_line_id => PO_TBL_NUMBER(p_line_id),
1242: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),

Line 1239: p_document_num => PO_TBL_VARCHAR30(p_document_num),

1235: p_header_id => PO_TBL_NUMBER(p_header_id),
1236: p_release_id => PO_TBL_NUMBER(p_release_id),
1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1238: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1239: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1240: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1241: p_line_id => PO_TBL_NUMBER(p_line_id),
1242: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1243: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),

Line 1240: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),

1236: p_release_id => PO_TBL_NUMBER(p_release_id),
1237: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1238: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1239: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1240: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1241: p_line_id => PO_TBL_NUMBER(p_line_id),
1242: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1243: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1244: p_mode => p_mode,