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.OZF_SD_UTIL_PVT dependencies on OZF_SD_REQUEST_LINES_ALL

Line 332: l_curr_prod_context OZF_SD_REQUEST_LINES_ALL.PRODUCT_CONTEXT%TYPE ;

328: l_req_id NUMBER :=0 ;
329: l_req_number_count NUMBER ;
330: l_req_status AMS_USER_STATUSES_B.SYSTEM_STATUS_CODE%TYPE;
331: l_request_status OZF_SD_REQUEST_HEADERS_ALL_B.USER_STATUS_ID%TYPE;
332: l_curr_prod_context OZF_SD_REQUEST_LINES_ALL.PRODUCT_CONTEXT%TYPE ;
333: l_curr_code OZF_SD_REQUEST_HEADERS_ALL_B.REQUEST_CURRENCY_CODE%TYPE;
334: l_approved_lines NUMBER :=0;
335: l_error_count NUMBER := 0 ;
336: l_currency_count NUMBER :=0 ;

Line 355: OZF_SD_REQUEST_LINES_ALL PRODLINES,

351: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
352: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
353: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
354: FROM OZF_SD_RES_PROD_INTF PRODINTF,
355: OZF_SD_REQUEST_LINES_ALL PRODLINES,
356: mtl_system_items_b_kfv PROD
357: where NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
358: PRODINTF.REQUEST_NUMBER=p_request_number
359: AND PRODLINES.REQUEST_HEADER_ID=request_header_id

Line 379: OZF_SD_REQUEST_LINES_ALL PRODLINES,

375: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
376: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
377: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
378: FROM OZF_SD_RES_PROD_INTF PRODINTF,
379: OZF_SD_REQUEST_LINES_ALL PRODLINES,
380: ENI_PROD_DEN_HRCHY_PARENTS_V D
381: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
382: PRODINTF.REQUEST_NUMBER=p_request_number
383: AND PRODLINES.REQUEST_HEADER_ID=request_header_id

Line 403: OZF_SD_REQUEST_LINES_ALL PRODLINES

399: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
400: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
401: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
402: FROM OZF_SD_RES_PROD_INTF PRODINTF,
403: OZF_SD_REQUEST_LINES_ALL PRODLINES
404: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
405: PRODINTF.REQUEST_NUMBER=p_request_number
406: AND PRODLINES.REQUEST_HEADER_ID=request_header_id
407: AND PRODINTF.REQUEST_LINE_ID = PRODLINES.REQUEST_LINE_ID

Line 453: UPDATE OZF_SD_REQUEST_LINES_ALL SET VENDOR_APPROVED_FLAG='N',REJECTION_CODE='OZF_SD_NO_RESPONSE'

449: -- If the request status is "PENDING_SUPPLIER_APPROVAL" then process the product lines in loop
450: IF l_req_status='PENDING_SUPPLIER_APPROVAL' THEN
451:
452: -- Update the non responded lines as 'rejected' and rejection code as ' No response from vendor'
453: UPDATE OZF_SD_REQUEST_LINES_ALL SET VENDOR_APPROVED_FLAG='N',REJECTION_CODE='OZF_SD_NO_RESPONSE'
454: WHERE REQUEST_HEADER_ID=request_header_id
455: AND REQUEST_LINE_ID IN ( SELECT REQUEST_LINE_ID FROM OZF_SD_REQUEST_LINES_ALL
456: WHERE REQUEST_HEADER_ID=request_header_id
457: MINUS

Line 455: AND REQUEST_LINE_ID IN ( SELECT REQUEST_LINE_ID FROM OZF_SD_REQUEST_LINES_ALL

451:
452: -- Update the non responded lines as 'rejected' and rejection code as ' No response from vendor'
453: UPDATE OZF_SD_REQUEST_LINES_ALL SET VENDOR_APPROVED_FLAG='N',REJECTION_CODE='OZF_SD_NO_RESPONSE'
454: WHERE REQUEST_HEADER_ID=request_header_id
455: AND REQUEST_LINE_ID IN ( SELECT REQUEST_LINE_ID FROM OZF_SD_REQUEST_LINES_ALL
456: WHERE REQUEST_HEADER_ID=request_header_id
457: MINUS
458: SELECT REQUEST_LINE_ID FROM OZF_SD_RES_PROD_INTF
459: WHERE REQUEST_NUMBER=p_request_number

Line 554: UPDATE OZF_SD_REQUEST_LINES_ALL SET REJECTION_CODE=PROD_REC.INF_REJ_CODE,VENDOR_APPROVED_FLAG='N'

550: -- Check the validation status of line : If an valid line then update the base table data
551: IF l_line_status <> 'E' THEN
552: -- Update the status for product line as 'Rejected'
553: IF PROD_REC.INF_REJ_CODE IS NOT NULL THEN
554: UPDATE OZF_SD_REQUEST_LINES_ALL SET REJECTION_CODE=PROD_REC.INF_REJ_CODE,VENDOR_APPROVED_FLAG='N'
555: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID;
556:
557: END IF;
558: -- Update the approved amount,approved currency and type in the base line table

Line 559: UPDATE OZF_SD_REQUEST_LINES_ALL SET APPROVED_DISCOUNT_TYPE=PROD_REC.LINE_DISCOUNT_TYPE,

555: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID;
556:
557: END IF;
558: -- Update the approved amount,approved currency and type in the base line table
559: UPDATE OZF_SD_REQUEST_LINES_ALL SET APPROVED_DISCOUNT_TYPE=PROD_REC.LINE_DISCOUNT_TYPE,
560: APPROVED_DISCOUNT_VALUE=PROD_REC.INTF_APPROVED_DISCOUNT_VALUE,
561: APPROVED_MAX_QTY=PROD_REC.INTF_APPROVED_QUANTITY,
562: APPROVED_DISCOUNT_CURRENCY=l_curr_code
563: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID;

Line 571: SELECT COUNT(*) INTO l_approved_lines FROM OZF_SD_REQUEST_LINES_ALL

567: END LOOP;
568:
569:
570: -- UPDATE THE REQUEST STATUS IN HEADER TABLE : OZF_SD_REQUEST_HEADERS_ALL_B
571: SELECT COUNT(*) INTO l_approved_lines FROM OZF_SD_REQUEST_LINES_ALL
572: WHERE REQUEST_HEADER_ID=l_req_id
573: AND VENDOR_APPROVED_FLAG = 'Y' ;
574:
575: