DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_TBL_VARCHAR30

Line 939: p_document_type IN OUT NOCOPY PO_TBL_VARCHAR30,

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,

Line 940: p_document_subtype IN OUT NOCOPY PO_TBL_VARCHAR30,

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,

Line 941: p_document_num IN OUT NOCOPY PO_TBL_VARCHAR30,

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,

Line 942: p_vendor_order_num IN OUT NOCOPY PO_TBL_VARCHAR30,

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,

Line 956: l_dummy_table_varchar30 po_tbl_varchar30 := po_tbl_varchar30();

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

Line 1079: p_document_type IN PO_TBL_VARCHAR30,

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,

Line 1080: p_document_subtype IN PO_TBL_VARCHAR30,

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,

Line 1081: p_document_num IN PO_TBL_VARCHAR30,

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,

Line 1082: p_vendor_order_num IN PO_TBL_VARCHAR30,

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,

Line 1097: l_document_type PO_TBL_VARCHAR30 := p_document_type;

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;

Line 1098: l_document_subtype PO_TBL_VARCHAR30 := p_document_subtype;

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;

Line 1099: l_document_num PO_TBL_VARCHAR30 := p_document_num;

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;

Line 1100: l_vendor_order_num PO_TBL_VARCHAR30 := p_vendor_order_num;

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:

Line 1227: p_document_type => PO_TBL_VARCHAR30(p_document_type),

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),

Line 1228: p_document_subtype => PO_TBL_VARCHAR30(p_document_subtype),

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),

Line 1229: p_document_num => PO_TBL_VARCHAR30(p_document_num),

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),

Line 1230: p_vendor_order_num => PO_TBL_VARCHAR30(p_vendor_order_num),

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,