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_RES_PROD_INTF

Line 259: FROM OZF_SD_RES_PROD_INTF PRODINTF,

255: PRODLINES.REQUESTED_DISCOUNT_CURRENCY LINE_DISCOUNT_CUR,
256: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
257: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
258: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
259: FROM OZF_SD_RES_PROD_INTF PRODINTF,
260: OZF_SD_REQUEST_LINES_ALL PRODLINES,
261: mtl_system_items_b_kfv PROD
262: where NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
263: PRODINTF.REQUEST_NUMBER=p_request_number

Line 283: FROM OZF_SD_RES_PROD_INTF PRODINTF,

279: PRODLINES.REQUESTED_DISCOUNT_CURRENCY LINE_DISCOUNT_CUR,
280: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
281: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
282: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
283: FROM OZF_SD_RES_PROD_INTF PRODINTF,
284: OZF_SD_REQUEST_LINES_ALL PRODLINES,
285: ENI_PROD_DEN_HRCHY_PARENTS_V D
286: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
287: PRODINTF.REQUEST_NUMBER=p_request_number

Line 314: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;

310: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
311:
312: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
313:
314: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
315:
316: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
317:
318: COMMIT ;

Line 339: SELECT REQUEST_LINE_ID FROM OZF_SD_RES_PROD_INTF

335: WHERE REQUEST_HEADER_ID=request_header_id
336: AND REQUEST_LINE_ID IN ( SELECT REQUEST_LINE_ID FROM OZF_SD_REQUEST_LINES_ALL
337: WHERE REQUEST_HEADER_ID=request_header_id
338: MINUS
339: SELECT REQUEST_LINE_ID FROM OZF_SD_RES_PROD_INTF
340: WHERE REQUEST_NUMBER=p_request_number
341: AND NVL(PROCESSED_FLAG,'N') <>'Y') ;
342:
343:

Line 357: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data

353:
354:
355: l_msg_data := l_msg_data ||','|| 'Product context mismatch' ;
356:
357: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data
358: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
359: AND NVL(PROCESSED_FLAG,'N') <>'Y';
360:
361: l_error_count := l_error_count +1 ;

Line 374: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data

370:
371:
372: l_msg_data := l_msg_data ||','|| 'Product code mismatch' ;
373:
374: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data
375: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
376: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
377:
378: l_error_count := l_error_count +1 ;

Line 391: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Discount type mismatch'

387:
388:
389: l_msg_data := l_msg_data ||','|| 'Discount type mismatch' ;
390:
391: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Discount type mismatch'
392: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
393: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
394:
395: l_error_count := l_error_count +1 ;

Line 420: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Currency code mismatch'

416:
417:
418: l_msg_data := l_msg_data ||','|| 'Currency code mismatch' ;
419:
420: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Currency code mismatch'
421: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
422: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
423:
424: l_error_count := l_error_count +1 ;

Line 494: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';

490: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
491:
492: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
493: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
494: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
495: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
496: COMMIT ;
497: EXCEPTION
498:

Line 504: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';

500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
502: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
503: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
504: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
505: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
506:
507: COMMIT ;
508: RETURN;

Line 601: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;

597: BEGIN
598:
599: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
600: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
601: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
602: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
603: COMMIT ;
604:
605: END UPDATE_SD_REQ_STALE_DATA;