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_PVT dependencies on DUAL

Line 43: -- The implementation of updatable_flag involves a fake "update dual" statement to

39: -- The number of messages put into FND Message Stack by this API
40: --x_msg_data
41: -- First message put into FND Message Stack by this API
42: --Notes:
43: -- The implementation of updatable_flag involves a fake "update dual" statement to
44: -- optimize performance.
45: --End of Comments
46: -------------------------------------------------------------------------------
47:

Line 74: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause

70: || l_progress, 'Entering Procedure '||l_api_name);
71: END IF;
72: END IF;
73:
74: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
75: -- of the fake update statement checks if the current entity is updatable or not.
76: -- One dual row updated <==> where clause is true <==> current entity is updatable.
77: -- Later, Examine BULK_ROWCOUNT in a loop to determine updatable_flag
78: l_progress := '010';

Line 76: -- One dual row updated <==> where clause is true <==> current entity is updatable.

72: END IF;
73:
74: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
75: -- of the fake update statement checks if the current entity is updatable or not.
76: -- One dual row updated <==> where clause is true <==> current entity is updatable.
77: -- Later, Examine BULK_ROWCOUNT in a loop to determine updatable_flag
78: l_progress := '010';
79:
80: -- bug3606853 START

Line 81: -- The original approach was to do a fake UPDATE on DUAL table. However, this

77: -- Later, Examine BULK_ROWCOUNT in a loop to determine updatable_flag
78: l_progress := '010';
79:
80: -- bug3606853 START
81: -- The original approach was to do a fake UPDATE on DUAL table. However, this
82: -- is causing locking issue (and priviledge). Therefore, BULK INSERT is used
83: -- instead of BULK UPDATE
84:
85: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

Line 93: FROM DUAL

89: INSERT INTO PO_SESSION_GT
90: ( key
91: )
92: SELECT l_procedure_id
93: FROM DUAL
94: WHERE
95: EXISTS (select null from po_requisition_headers h
96: WHERE h.requisition_header_id = p_req_header_id(i)
97: AND (h.authorization_status is NULL

Line 122: -- Updateable Header/Line found in the fake "update dual" stmt

118: l_progress := '030';
119: FOR i IN 1..p_count LOOP
120:
121: IF SQL%BULK_ROWCOUNT(i) > 0 THEN
122: -- Updateable Header/Line found in the fake "update dual" stmt
123: x_req_status_rec.updatable_flag(i) := 'Y';
124:
125: -- This document is updatable, lock the document if p_lock_flag=Y
126: l_progress := '040';

Line 194: -- The implementation of reservable_flag involves a fake "update dual" statement to

190: -- The number of messages put into FND Message Stack by this API
191: --x_msg_data
192: -- First message put into FND Message Stack by this API
193: --Notes:
194: -- The implementation of reservable_flag involves a fake "update dual" statement to
195: -- optimize performance.
196: --End of Comments
197: -------------------------------------------------------------------------------
198:

Line 224: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause

220: || l_progress, 'Entering Procedure '||l_api_name);
221: END IF;
222: END IF;
223:
224: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
225: -- of the fake update statement checks if the current entity is reservable or not.
226: -- One dual row updated <==> where clause is true <==> current entity is reservable.
227: -- Later, Examine BULK_ROWCOUNT in a loop to determine reservable_flag
228: l_progress := '010';

Line 226: -- One dual row updated <==> where clause is true <==> current entity is reservable.

222: END IF;
223:
224: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
225: -- of the fake update statement checks if the current entity is reservable or not.
226: -- One dual row updated <==> where clause is true <==> current entity is reservable.
227: -- Later, Examine BULK_ROWCOUNT in a loop to determine reservable_flag
228: l_progress := '010';
229:
230: -- bug3606853 START

Line 231: -- The original approach was to do a fake UPDATE on DUAL table. However, this

227: -- Later, Examine BULK_ROWCOUNT in a loop to determine reservable_flag
228: l_progress := '010';
229:
230: -- bug3606853 START
231: -- The original approach was to do a fake UPDATE on DUAL table. However, this
232: -- is causing locking issue (and priviledge). Therefore, BULK INSERT is used
233: -- instead of BULK UPDATE
234:
235: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

Line 243: FROM DUAL

239: INSERT INTO PO_SESSION_GT
240: ( key
241: )
242: SELECT l_procedure_id
243: FROM DUAL
244: WHERE
245: EXISTS (select null from po_requisition_headers h
246: WHERE h.requisition_header_id = p_req_header_id(i)
247: AND (h.authorization_status is NULL

Line 267: -- Reservable Header/Line found in the fake "update dual" stmt

263: l_progress := '030';
264: FOR i IN 1..p_count LOOP
265:
266: IF SQL%BULK_ROWCOUNT(i) > 0 THEN
267: -- Reservable Header/Line found in the fake "update dual" stmt
268: x_req_status_rec.reservable_flag(i) := 'Y';
269: ELSE
270: x_req_status_rec.reservable_flag(i) := 'N';
271: END IF; --END of IF SQL%BULK_ROWCOUNT(i) > 0

Line 325: -- The implementation of unreservable_flag involves a fake "update dual" statement to

321: -- The number of messages put into FND Message Stack by this API
322: --x_msg_data
323: -- First message put into FND Message Stack by this API
324: --Notes:
325: -- The implementation of unreservable_flag involves a fake "update dual" statement to
326: -- optimize performance.
327: --End of Comments
328: -------------------------------------------------------------------------------
329:

Line 356: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause

352: || l_progress, 'Entering Procedure '||l_api_name);
353: END IF;
354: END IF;
355:
356: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
357: -- of the fake update statement checks if the current entity is unreservable or not.
358: -- One dual row updated <==> where clause is true <==> current entity is unreservable.
359: -- Later, Examine BULK_ROWCOUNT in a loop to determine unreservable_flag
360: l_progress := '010';

Line 358: -- One dual row updated <==> where clause is true <==> current entity is unreservable.

354: END IF;
355:
356: --To obtimize performance, Execute a fake "update dual" in BULK. The WHERE clause
357: -- of the fake update statement checks if the current entity is unreservable or not.
358: -- One dual row updated <==> where clause is true <==> current entity is unreservable.
359: -- Later, Examine BULK_ROWCOUNT in a loop to determine unreservable_flag
360: l_progress := '010';
361:
362: -- bug3606853 START

Line 363: -- The original approach was to do a fake UPDATE on DUAL table. However, this

359: -- Later, Examine BULK_ROWCOUNT in a loop to determine unreservable_flag
360: l_progress := '010';
361:
362: -- bug3606853 START
363: -- The original approach was to do a fake UPDATE on DUAL table. However, this
364: -- is causing locking issue (and priviledge). Therefore, BULK INSERT is used
365: -- instead of BULK UPDATE
366:
367: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

Line 375: FROM DUAL

371: INSERT INTO PO_SESSION_GT
372: ( key
373: )
374: SELECT l_procedure_id
375: FROM DUAL
376: WHERE
377: EXISTS (select null from po_requisition_headers h
378: WHERE h.requisition_header_id = p_req_header_id(i)
379: AND (h.closed_code is NULL or h.closed_code IN ('OPEN', 'CLOSED')))

Line 397: -- unreservable Header/Line found in the fake "update dual" stmt

393: l_progress := '030';
394: FOR i IN 1..p_count LOOP
395:
396: IF SQL%BULK_ROWCOUNT(i) > 0 THEN
397: -- unreservable Header/Line found in the fake "update dual" stmt
398: x_req_status_rec.unreservable_flag(i) := 'Y';
399: ELSE
400: x_req_status_rec.unreservable_flag(i) := 'N';
401: END IF; --END of IF SQL%BULK_ROWCOUNT(i) > 0