APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 331: l_request_status OZF_SD_REQUEST_HEADERS_ALL_B.USER_STATUS_ID%TYPE;

327: l_msg_data VARCHAR2(2000):='Data submitted is not valid :';
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 ;

Line 333: l_curr_code OZF_SD_REQUEST_HEADERS_ALL_B.REQUEST_CURRENCY_CODE%TYPE;

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 ;
337: l_line_status VARCHAR2(1) :='S' ;

Line 420: Select count(*) into l_req_number_count from OZF_SD_REQUEST_HEADERS_ALL_B

416: x_return_status := FND_API.G_RET_STS_SUCCESS ;
417: l_error_message := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR') ;
418:
419: -- Validate the SDR Request Number
420: Select count(*) into l_req_number_count from OZF_SD_REQUEST_HEADERS_ALL_B
421: where REQUEST_NUMBER = p_request_number ;
422: IF l_req_number_count = 0 THEN
423:
424: l_msg_data := l_msg_data ||','|| 'The request number '||p_request_number ||' is not valid.' ;

Line 444: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS

440: END IF ;
441:
442:
443: Select REQ.request_header_id,STATUS.SYSTEM_STATUS_CODE,REQ.request_currency_code into l_req_id,l_req_status,l_curr_code
444: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS
445: where REQ.REQUEST_NUMBER = p_request_number
446: AND REQ.USER_STATUS_ID=STATUS.USER_STATUS_ID ;
447:
448:

Line 570: -- UPDATE THE REQUEST STATUS IN HEADER TABLE : OZF_SD_REQUEST_HEADERS_ALL_B

566: END IF;
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:

Line 593: UPDATE OZF_SD_REQUEST_HEADERS_ALL_B SET user_status_id= l_request_status,AUTHORIZATION_NUMBER=l_authorization_number

589:
590: SELECT AUTH_NUMBER INTO l_authorization_number FROM OZF_SD_RES_HEADER_INTF WHERE request_number=p_request_number
591: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
592:
593: UPDATE OZF_SD_REQUEST_HEADERS_ALL_B SET user_status_id= l_request_status,AUTHORIZATION_NUMBER=l_authorization_number
594: WHERE REQUEST_HEADER_ID=l_req_id ;
595:
596:
597: ELSE