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_PALT_ASSIGNMENTS dependencies on PO_REQUISITION_LINES_ALL

Line 18: sql_stmt := 'SELECT REQUISITION_LINE_ID REQUISITION_ID FROM PO_REQUISITION_LINES_ALL WHERE '||pReqLines||' and 1 = 1 ';

14: l_Assignment_Number VARCHAR2(30);
15: l_Assignment_count NUMBER;
16:
17: BEGIN
18: sql_stmt := 'SELECT REQUISITION_LINE_ID REQUISITION_ID FROM PO_REQUISITION_LINES_ALL WHERE '||pReqLines||' and 1 = 1 ';
19:
20: OPEN ReqlinesCur FOR sql_stmt;
21: LOOP
22: FETCH ReqlinesCur INTO l_requisition_line_Id;

Line 157: UPDATE PO_REQUISITION_LINES_ALL

153: fnd_global.login_id);
154:
155: /* IF (pOldBuyerId <> pnewBuyerId) THEN
156:
157: UPDATE PO_REQUISITION_LINES_ALL
158: SET SUGGESTED_BUYER_ID = pnewBuyerId,
159: last_updated_by = fnd_global.user_id,
160: last_update_date = SYSDATE ,
161: last_update_login = fnd_global.login_id

Line 182: UPDATE PO_REQUISITION_LINES_ALL

178: IF (pNewStatus = 3) THEN
179:
180:
181:
182: UPDATE PO_REQUISITION_LINES_ALL
183: SET ASSIGNMENT_NUMBER = NULL,
184: last_updated_by = fnd_global.user_id,
185: last_update_date = SYSDATE ,
186: last_update_login = fnd_global.login_id

Line 246: FROM po_requisition_lines_all

242: --the associated clin-slin structure, whose any of the option lines has the base as the input clin line or its slins
243:
244: CURSOR C(reqHeaderId NUMBER) IS
245: SELECT requisition_line_id
246: FROM po_requisition_lines_all
247: WHERE requisition_header_id = reqHeaderId
248: and (group_line_id = pReqLineId OR (po_autocreate_util_pvt.is_crosslinked_child(requisition_line_id,pReqLineId) ='T') );
249:
250:

Line 254: FROM po_requisition_lines_all

250:
251:
252: BEGIN
253: SELECT requisition_header_id INTO l_req_header_id
254: FROM po_requisition_lines_all
255: WHERE requisition_line_id = pReqLineId;
256:
257:
258: OPEN C(l_req_header_id);

Line 317: l_query := ' UPDATE po_requisition_lines_all ' ||

313:
314: IF l_cnt = 0 THEN
315: --None of the milestones have been completed,
316: --safe to unassign the lines
317: l_query := ' UPDATE po_requisition_lines_all ' ||
318: ' SET assignment_number = NULL, suggested_buyer_id = NULL ' ||
319: ' WHERE assignment_number = ''' || pAssignmentNums(i) || '''' ||
320: ' and requisition_line_id in ('|| l_req_line_ids_str || ')';
321:

Line 330: ' FROM po_requisition_lines_all ' ||

326:
327: l_par_query := 'UPDATE po_lines_draft_all ' ||
328: ' SET draft_line_status = ''COMPLETED''' ||
329: ' WHERE (po_line_id, draft_id) IN (SELECT par_line_id, par_draft_id' ||
330: ' FROM po_requisition_lines_all ' ||
331: ' WHERE assignment_number = ''' || pAssignmentNums(i) || '''' ||
332: ' AND par_line_id IS NOT NULL)';
333:
334: EXECUTE IMMEDIATE l_par_query;

Line 390: FROM po_requisition_lines_all WHERE assignment_number = pAssignmentNum);

386: BEGIN
387: x_progress := '10';
388: SELECT Count(*) INTO x_currCodeCount FROM (
389: SELECT DISTINCT Nvl(CURRENCY_CODE,PO_PALT_ASSIGNMENTS.GetLineFuncCurrCode(ORG_ID))
390: FROM po_requisition_lines_all WHERE assignment_number = pAssignmentNum);
391:
392: x_progress := '20';
393:
394: IF x_currCodeCount > 1 THEN

Line 398: FROM po_requisition_lines_all WHERE assignment_number = pAssignmentNum;

394: IF x_currCodeCount > 1 THEN
395: x_currCode := 'Multiple';
396: ELSE
397: SELECT DISTINCT Nvl(CURRENCY_CODE,PO_PALT_ASSIGNMENTS.GetLineFuncCurrCode(ORG_ID)) INTO x_currCode
398: FROM po_requisition_lines_all WHERE assignment_number = pAssignmentNum;
399:
400: END IF;
401:
402: RETURN x_currCode;

Line 437: SELECT ORG_ID INTO x_org_id FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = p_line_id;

433: x_currCode VARCHAR2(12);
434: x_org_id NUMBER;
435: BEGIN
436:
437: SELECT ORG_ID INTO x_org_id FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = p_line_id;
438:
439: SELECT s.CURRENCY_CODE INTO x_currCode
440: FROM GL_SETS_OF_BOOKS s, FINANCIALS_SYSTEM_PARAMS_ALL f
441: WHERE s.SET_OF_BOOKS_ID = f.SET_OF_BOOKS_ID

Line 467: UPDATE PO_REQUISITION_LINES_ALL

463: INTO l_Assignment_Number
464: FROM PO_CLM_ASSIGNMENTS
465: WHERE ASSIGNMENT_ID = pAssignmentId;
466:
467: UPDATE PO_REQUISITION_LINES_ALL
468: SET SUGGESTED_BUYER_ID = pnewBuyerId,
469: last_updated_by = fnd_global.user_id,
470: last_update_date = SYSDATE ,
471: last_update_login = fnd_global.login_id

Line 497: sql_stmt := 'SELECT REQUISITION_LINE_ID REQUISITION_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID = ' || p_par_req_header_id;

493: l_requisition_line_Id NUMBER;
494: i PLS_INTEGER := 0;
495: l_Requisition_Details po_palt_assignments.Requisition_Details;
496: BEGIN
497: sql_stmt := 'SELECT REQUISITION_LINE_ID REQUISITION_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID = ' || p_par_req_header_id;
498: OPEN ReqlinesCur FOR sql_stmt;
499: LOOP
500: FETCH ReqlinesCur INTO l_requisition_line_Id;
501: i := i + 1;

Line 537: UPDATE po_requisition_lines_all

533: 1, --Satus is 'Assigned'
534: 'PAR');
535: END IF;
536:
537: UPDATE po_requisition_lines_all
538: SET assignment_number = l_assignment_number,
539: last_updated_by = fnd_global.user_id,
540: last_update_date = SYSDATE ,
541: last_update_login = fnd_global.login_id