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_NUMBER

Line 117: l_document_id_tbl po_tbl_number;

113: l_api_version CONSTANT NUMBER := 1.1;
114: l_progress VARCHAR2(3);
115:
116: l_document_id NUMBER;
117: l_document_id_tbl po_tbl_number;
118:
119: l_doc_id NUMBER;
120:
121: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;

Line 148: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )

144:
145: PO_CORE_S.get_document_ids(
146: p_doc_type => p_document_type
147: , p_doc_level => p_document_level
148: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )
149: , x_doc_id_tbl => l_document_id_tbl
150: );
151:
152: l_document_id := l_document_id_tbl(1);

Line 947: p_header_id IN OUT NOCOPY PO_TBL_NUMBER,

943: --End of Comments
944: -------------------------------------------------------------------------------
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,

Line 948: p_release_id IN OUT NOCOPY PO_TBL_NUMBER,

944: -------------------------------------------------------------------------------
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,

Line 953: p_line_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,
957: p_lock_flag IN VARCHAR2 := 'N',

Line 954: p_line_location_id IN OUT NOCOPY PO_TBL_NUMBER,

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,
957: p_lock_flag IN VARCHAR2 := 'N',
958: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 955: p_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,

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,
957: p_lock_flag IN VARCHAR2 := 'N',
958: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
959: x_return_status OUT NOCOPY VARCHAR2

Line 965: l_dummy_table_number po_tbl_number := po_tbl_number();

961:
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:

Line 1087: p_header_id IN PO_TBL_NUMBER,

1083: --End of Comments
1084: -------------------------------------------------------------------------------
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,

Line 1088: p_release_id IN PO_TBL_NUMBER,

1084: -------------------------------------------------------------------------------
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,

Line 1093: p_line_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,
1097: p_lock_flag IN VARCHAR2 := 'N',

Line 1094: p_line_location_id IN PO_TBL_NUMBER,

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,
1097: p_lock_flag IN VARCHAR2 := 'N',
1098: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 1095: p_distribution_id IN PO_TBL_NUMBER,

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,
1097: p_lock_flag IN VARCHAR2 := 'N',
1098: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
1099: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 1105: l_header_id PO_TBL_NUMBER := p_header_id;

1101: x_po_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
1102: x_return_status OUT NOCOPY VARCHAR2
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;

Line 1106: l_release_id PO_TBL_NUMBER := p_release_id;

1102: x_return_status OUT NOCOPY VARCHAR2
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;

Line 1111: l_line_id PO_TBL_NUMBER := p_line_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:
1115: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';

Line 1112: l_line_location_id PO_TBL_NUMBER := p_line_location_id;

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:
1115: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';
1116: l_api_version CONSTANT NUMBER := 1.0;

Line 1113: l_distribution_id PO_TBL_NUMBER := p_distribution_id;

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:
1115: l_api_name CONSTANT VARCHAR(30) := 'PO_STATUS_CHECK';
1116: l_api_version CONSTANT NUMBER := 1.0;
1117: l_progress VARCHAR2(3) := '000';

Line 1235: p_header_id => PO_TBL_NUMBER(p_header_id),

1231: -- creating size=1 Tables of IDs 1 with value of the scalar input IDs
1232: l_progress := '010';
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),

Line 1236: p_release_id => PO_TBL_NUMBER(p_release_id),

1232: l_progress := '010';
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),

Line 1241: p_line_id => PO_TBL_NUMBER(p_line_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,
1245: p_lock_flag => p_lock_flag,

Line 1242: p_line_location_id => PO_TBL_NUMBER(p_line_location_id),

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,
1245: p_lock_flag => p_lock_flag,
1246: p_calling_module => p_calling_module, -- PDOI Rewrite R12

Line 1243: p_distribution_id => PO_TBL_NUMBER(p_distribution_id),

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,
1245: p_lock_flag => p_lock_flag,
1246: p_calling_module => p_calling_module, -- PDOI Rewrite R12
1247: p_role => p_role, -- PDOI Rewrite R12

Line 1836: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2

1832: d_module VARCHAR2(70) :=
1833: 'po.plsql.PO_DOCUMENT_CHECKS_GRP.merge_online_report_id';
1834: d_progress NUMBER;
1835: l_id1_max_seq NUMBER; -- max sequence number value for the first online report
1836: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2
1837:
1838: BEGIN
1839: d_progress := 0;
1840: IF (PO_LOG.d_proc) THEN