935: PROCEDURE validate_status_check_inputs (
936: p_api_version IN NUMBER,
937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
936: p_api_version IN NUMBER,
937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
937: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
938: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,
939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,
940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,
941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,
942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,
943: p_line_id IN OUT NOCOPY PO_TBL_NUMBER,
944: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,
945: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
946: p_mode IN VARCHAR2,
952: l_api_name CONSTANT VARCHAR(30) := 'VALIDATE_STATUS_CHECK_INPUTS';
953: l_progress VARCHAR2(3) := '000';
954: l_count NUMBER;
955: l_dummy_table_number po_tbl_number := po_tbl_number();
956: l_dummy_table_varchar30 po_tbl_varchar30 := po_tbl_varchar30();
957:
958: BEGIN
959:
960: --Initialize l_count to length of first non-null Required Input Table
1075: PROCEDURE po_status_check (
1076: p_api_version IN NUMBER,
1077: p_header_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1076: p_api_version IN NUMBER,
1077: p_header_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1077: p_header_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1085: p_distribution_id IN PO_TBL_NUMBER,
1078: p_release_id IN PO_TBL_NUMBER,
1079: p_document_type IN PO_TBL_VARCHAR30,
1080: p_document_subtype IN PO_TBL_VARCHAR30,
1081: p_document_num IN PO_TBL_VARCHAR30,
1082: p_vendor_order_num IN PO_TBL_VARCHAR30,
1083: p_line_id IN PO_TBL_NUMBER,
1084: p_line_location_id IN PO_TBL_NUMBER,
1085: p_distribution_id IN PO_TBL_NUMBER,
1086: p_mode IN VARCHAR2,
1093: ) IS
1094:
1095: l_header_id PO_TBL_NUMBER := p_header_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1094:
1095: l_header_id PO_TBL_NUMBER := p_header_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1095: l_header_id PO_TBL_NUMBER := p_header_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1096: l_release_id PO_TBL_NUMBER := p_release_id;
1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;
1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;
1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;
1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;
1101: l_line_id PO_TBL_NUMBER := p_line_id;
1102: l_line_location_id PO_TBL_NUMBER := p_line_location_id;
1103: l_distribution_id PO_TBL_NUMBER := p_distribution_id;
1104:
1223: PO_DOCUMENT_CHECKS_GRP.po_status_check(
1224: p_api_version => p_api_version,
1225: p_header_id => PO_TBL_NUMBER(p_header_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1224: p_api_version => p_api_version,
1225: p_header_id => PO_TBL_NUMBER(p_header_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1225: p_header_id => PO_TBL_NUMBER(p_header_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1226: p_release_id => PO_TBL_NUMBER(p_release_id),
1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),
1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),
1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),
1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),
1231: p_line_id => PO_TBL_NUMBER(p_line_id),
1232: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),
1233: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),
1234: p_mode => p_mode,