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.

[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_RES_HEADER_INTF

Line 243: l_authorization_number OZF_SD_RES_HEADER_INTF.AUTH_NUMBER%TYPE ;

239: l_approved_lines NUMBER :=0;
240: l_error_count NUMBER := 0 ;
241: l_currency_count NUMBER :=0 ;
242: l_line_status VARCHAR2(1) :='S' ;
243: l_authorization_number OZF_SD_RES_HEADER_INTF.AUTH_NUMBER%TYPE ;
244: l_error_message FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE ;
245:
246: CURSOR FETCH_PROD_INTF_REC IS
247: SELECT PRODINTF.REQUEST_LINE_ID INF_REQUEST_LINE_ID,

Line 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) ;

306: x_msg_data := 'No Ship and Debit Request exists for : '||p_request_number;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308:
309: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
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) ;

Line 471: SELECT AUTH_NUMBER INTO l_authorization_number FROM OZF_SD_RES_HEADER_INTF WHERE request_number=p_request_number

467: and default_flag='Y'
468: and enabled_flag='Y' ;
469: END IF ;
470:
471: SELECT AUTH_NUMBER INTO l_authorization_number FROM OZF_SD_RES_HEADER_INTF WHERE request_number=p_request_number
472: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
473:
474: UPDATE OZF_SD_REQUEST_HEADERS_ALL_B SET user_status_id= l_request_status,AUTHORIZATION_NUMBER=l_authorization_number
475: WHERE REQUEST_HEADER_ID=l_req_id ;

Line 483: UPDATE OZF_SD_RES_HEADER_INTF SET ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number

479: l_msg_data := l_msg_data ||','|| 'The ststus is not pending suppler approval' ;
480: x_msg_data := 'Currently the request is not pending for supplier approval';
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: UPDATE OZF_SD_RES_HEADER_INTF SET ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number
484: and NVL(PROCESSED_FLAG,'N') <>'Y';
485:
486:
487: END IF ;

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

488:
489:
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 ;

Line 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';

498:
499: WHEN OTHERS then
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:

Line 599: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;

595: IS
596: l_req_number_count NUMBER :=0;
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 ;