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

Line 34: p_req_header_id IN PO_TBL_NUMBER,

30: --End of Comments
31: -------------------------------------------------------------------------------
32: PROCEDURE validate_status_check_inputs (
33: p_api_version IN NUMBER,
34: p_req_header_id IN PO_TBL_NUMBER,
35: p_req_line_id IN OUT NOCOPY PO_TBL_NUMBER,
36: p_req_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
37: p_mode IN VARCHAR2,
38: p_lock_flag IN VARCHAR2 := 'N',

Line 35: p_req_line_id IN OUT NOCOPY PO_TBL_NUMBER,

31: -------------------------------------------------------------------------------
32: PROCEDURE validate_status_check_inputs (
33: p_api_version IN NUMBER,
34: p_req_header_id IN PO_TBL_NUMBER,
35: p_req_line_id IN OUT NOCOPY PO_TBL_NUMBER,
36: p_req_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
37: p_mode IN VARCHAR2,
38: p_lock_flag IN VARCHAR2 := 'N',
39: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 36: p_req_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,

32: PROCEDURE validate_status_check_inputs (
33: p_api_version IN NUMBER,
34: p_req_header_id IN PO_TBL_NUMBER,
35: p_req_line_id IN OUT NOCOPY PO_TBL_NUMBER,
36: p_req_distribution_id IN OUT NOCOPY PO_TBL_NUMBER,
37: p_mode IN VARCHAR2,
38: p_lock_flag IN VARCHAR2 := 'N',
39: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
40: x_return_status OUT NOCOPY VARCHAR2,

Line 48: l_dummy_table_number po_tbl_number := po_tbl_number();

44:
45: l_api_name CONSTANT VARCHAR(30) := 'VALIDATE_STATUS_CHECK_INPUTS';
46: l_progress VARCHAR2(3) := '000';
47: l_count NUMBER := p_req_header_id.COUNT;
48: l_dummy_table_number po_tbl_number := po_tbl_number();
49:
50: BEGIN
51:
52: --Initialize any null Tables to a dummy table of null values with length of p_header_id.COUNT

Line 120: p_req_header_id IN PO_TBL_NUMBER,

116: --End of Comments
117: -------------------------------------------------------------------------------
118: PROCEDURE req_status_check (
119: p_api_version IN NUMBER,
120: p_req_header_id IN PO_TBL_NUMBER,
121: p_req_line_id IN PO_TBL_NUMBER,
122: p_req_distribution_id IN PO_TBL_NUMBER,
123: p_mode IN VARCHAR2,
124: p_lock_flag IN VARCHAR2 := 'N',

Line 121: p_req_line_id IN PO_TBL_NUMBER,

117: -------------------------------------------------------------------------------
118: PROCEDURE req_status_check (
119: p_api_version IN NUMBER,
120: p_req_header_id IN PO_TBL_NUMBER,
121: p_req_line_id IN PO_TBL_NUMBER,
122: p_req_distribution_id IN PO_TBL_NUMBER,
123: p_mode IN VARCHAR2,
124: p_lock_flag IN VARCHAR2 := 'N',
125: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 122: p_req_distribution_id IN PO_TBL_NUMBER,

118: PROCEDURE req_status_check (
119: p_api_version IN NUMBER,
120: p_req_header_id IN PO_TBL_NUMBER,
121: p_req_line_id IN PO_TBL_NUMBER,
122: p_req_distribution_id IN PO_TBL_NUMBER,
123: p_mode IN VARCHAR2,
124: p_lock_flag IN VARCHAR2 := 'N',
125: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
126: x_return_status OUT NOCOPY VARCHAR2,

Line 134: l_req_line_id PO_TBL_NUMBER := p_req_line_id;

130:
131: l_api_name CONSTANT VARCHAR(30) := 'req_status_check';
132: l_api_version CONSTANT NUMBER := 1.0;
133: l_progress VARCHAR2(3) := '000';
134: l_req_line_id PO_TBL_NUMBER := p_req_line_id;
135: l_req_distribution_id PO_TBL_NUMBER := p_req_distribution_id;
136:
137: BEGIN
138:

Line 135: l_req_distribution_id PO_TBL_NUMBER := p_req_distribution_id;

131: l_api_name CONSTANT VARCHAR(30) := 'req_status_check';
132: l_api_version CONSTANT NUMBER := 1.0;
133: l_progress VARCHAR2(3) := '000';
134: l_req_line_id PO_TBL_NUMBER := p_req_line_id;
135: l_req_distribution_id PO_TBL_NUMBER := p_req_distribution_id;
136:
137: BEGIN
138:
139: --Standard call to check for call compatibility

Line 234: p_req_header_id => PO_TBL_NUMBER(p_req_header_id),

230: -- creating size=1 Tables of IDs 1 with value of the scalar input IDs
231: l_progress := '010';
232: PO_REQ_DOCUMENT_CHECKS_GRP.req_status_check(
233: p_api_version => p_api_version,
234: p_req_header_id => PO_TBL_NUMBER(p_req_header_id),
235: p_req_line_id => PO_TBL_NUMBER(p_req_line_id),
236: p_req_distribution_id => PO_TBL_NUMBER(p_req_distribution_id),
237: p_mode => p_mode,
238: p_lock_flag => p_lock_flag,

Line 235: p_req_line_id => PO_TBL_NUMBER(p_req_line_id),

231: l_progress := '010';
232: PO_REQ_DOCUMENT_CHECKS_GRP.req_status_check(
233: p_api_version => p_api_version,
234: p_req_header_id => PO_TBL_NUMBER(p_req_header_id),
235: p_req_line_id => PO_TBL_NUMBER(p_req_line_id),
236: p_req_distribution_id => PO_TBL_NUMBER(p_req_distribution_id),
237: p_mode => p_mode,
238: p_lock_flag => p_lock_flag,
239: x_req_status_rec => x_req_status_rec,

Line 236: p_req_distribution_id => PO_TBL_NUMBER(p_req_distribution_id),

232: PO_REQ_DOCUMENT_CHECKS_GRP.req_status_check(
233: p_api_version => p_api_version,
234: p_req_header_id => PO_TBL_NUMBER(p_req_header_id),
235: p_req_line_id => PO_TBL_NUMBER(p_req_line_id),
236: p_req_distribution_id => PO_TBL_NUMBER(p_req_distribution_id),
237: p_mode => p_mode,
238: p_lock_flag => p_lock_flag,
239: x_req_status_rec => x_req_status_rec,
240: x_return_status => x_return_status,