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_DIST_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 20: from po_req_distributions

16: x_progress := '001';
17:
18: select 'that line number exists'
19: into dummy
20: from po_req_distributions
21: where requisition_line_id = x_requisition_line_id
22: and distribution_num = x_distribution_num
23: AND (rowid <> x_row_id
24: OR x_row_id IS NULL);

Line 58: from po_req_distributions

54: into dummy
55: from dual
56: where not exists (
57: select 'that line number exists'
58: from po_req_distributions
59: where requisition_line_id = x_requisition_line_id
60: and distribution_num = x_distribution_num
61: AND (rowid <> x_row_id
62: OR x_row_id IS NULL));

Line 89: from po_req_distributions

85: max_dist_num NUMBER;
86:
87: cursor C1 is
88: select nvl(max(distribution_num),0)
89: from po_req_distributions
90: where requisition_line_id = x_requisition_line_id;
91:
92: BEGIN
93: x_progress := '001';

Line 121: from po_req_distributions

117:
118: BEGIN
119: select nvl(sum(req_line_quantity),0)
120: into x_total
121: from po_req_distributions
122: where requisition_line_id = x_requisition_line_id;
123:
124:
125: EXCEPTION

Line 148: X_gl_cancelled_date PO_REQ_DISTRIBUTIONS.gl_cancelled_date%TYPE := NULL;

144: X_req_action_date IN DATE,
145: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
146:
147: X_progress VARCHAR2(3) := NULL;
148: X_gl_cancelled_date PO_REQ_DISTRIBUTIONS.gl_cancelled_date%TYPE := NULL;
149: X_gl_closed_date PO_REQ_DISTRIBUTIONS.gl_closed_date%TYPE := NULL;
150:
151: BEGIN
152:

Line 149: X_gl_closed_date PO_REQ_DISTRIBUTIONS.gl_closed_date%TYPE := NULL;

145: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
146:
147: X_progress VARCHAR2(3) := NULL;
148: X_gl_cancelled_date PO_REQ_DISTRIBUTIONS.gl_cancelled_date%TYPE := NULL;
149: X_gl_closed_date PO_REQ_DISTRIBUTIONS.gl_closed_date%TYPE := NULL;
150:
151: BEGIN
152:
153: -- dbms_output.put_line('Enter update_reqs_distributions');

Line 178: UPDATE PO_REQ_DISTRIBUTIONS

174: ** 1. all document lines - if header_id is passed or,
175: ** 2. one document line - if both header_id and line_id are passed.
176: */
177: X_progress := '010';
178: UPDATE PO_REQ_DISTRIBUTIONS
179: SET gl_cancelled_date = nvl(X_gl_cancelled_date, gl_cancelled_date),
180: gl_closed_date = nvl(X_gl_closed_date, gl_closed_date)
181: WHERE requisition_line_id IN
182: (SELECT requisition_line_id

Line 249: dist_rec po_req_distributions%rowtype;

245: x_new_dist_quantity NUMBER;
246: x_orig_line_quantity NUMBER;
247: x_total_dist_qty NUMBER;
248:
249: dist_rec po_req_distributions%rowtype;
250: x_rowid VARCHAR2(30);
251:
252: -- JFMIP, support for Req Modify when encumbrance is enabled START
253: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;

Line 256: l_prorated_rec_tax PO_REQ_DISTRIBUTIONS.recoverable_tax%type;

252: -- JFMIP, support for Req Modify when encumbrance is enabled START
253: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
254: /*Bug4421065 TCA Impact: Removed the obsolete column ap_tax_rounding_rule in po_vendors_sites_all table */
255:
256: l_prorated_rec_tax PO_REQ_DISTRIBUTIONS.recoverable_tax%type;
257: l_prorated_nonrec_tax PO_REQ_DISTRIBUTIONS.nonrecoverable_tax%type;
258: -- JFMIP, support for Req Modify when encumbrance is enabled END
259:
260: CURSOR C IS

Line 257: l_prorated_nonrec_tax PO_REQ_DISTRIBUTIONS.nonrecoverable_tax%type;

253: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
254: /*Bug4421065 TCA Impact: Removed the obsolete column ap_tax_rounding_rule in po_vendors_sites_all table */
255:
256: l_prorated_rec_tax PO_REQ_DISTRIBUTIONS.recoverable_tax%type;
257: l_prorated_nonrec_tax PO_REQ_DISTRIBUTIONS.nonrecoverable_tax%type;
258: -- JFMIP, support for Req Modify when encumbrance is enabled END
259:
260: CURSOR C IS
261: SELECT distribution_id

Line 262: FROM po_req_distributions

258: -- JFMIP, support for Req Modify when encumbrance is enabled END
259:
260: CURSOR C IS
261: SELECT distribution_id
262: FROM po_req_distributions
263: WHERE requisition_line_id = x_orig_req_line_id;
264:
265: BEGIN
266:

Line 300: FROM po_req_distributions

296: x_progress := '020';
297:
298: SELECT *
299: INTO dist_rec
300: FROM po_req_distributions
301: WHERE distribution_id = CREC.distribution_id;
302:
303:
304: /*

Line 332: po_req_distributions_pkg1.insert_row (x_rowid,

328: --bug1555260 x_new_dist_quantity);
329:
330: x_progress := '030';
331:
332: po_req_distributions_pkg1.insert_row (x_rowid,
333: x_distribution_id,
334: dist_rec.last_update_date,
335: dist_rec.last_updated_by,
336: x_new_req_line_id,

Line 417: FROM po_req_distributions

413: x_progress := '040';
414:
415: SELECT sum (req_line_quantity)
416: INTO x_total_dist_qty
417: FROM po_req_distributions
418: WHERE requisition_line_id = x_new_req_line_id;
419:
420: IF (x_total_dist_qty = x_new_line_quantity) THEN
421: return;

Line 427: UPDATE po_req_distributions

423: ELSE
424:
425: x_progress := '050';
426:
427: UPDATE po_req_distributions
428: SET req_line_quantity = req_line_quantity + (x_new_line_quantity -
429: x_total_dist_qty)
430: WHERE distribution_id = (SELECT min(distribution_id)
431: FROM po_req_distributions

Line 431: FROM po_req_distributions

427: UPDATE po_req_distributions
428: SET req_line_quantity = req_line_quantity + (x_new_line_quantity -
429: x_total_dist_qty)
430: WHERE distribution_id = (SELECT min(distribution_id)
431: FROM po_req_distributions
432: WHERE requisition_line_id = x_new_req_line_id);
433:
434: END IF;
435: