APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 236: l_request_status OZF_SD_REQUEST_HEADERS_ALL_B.USER_STATUS_ID%TYPE;

232: l_msg_data VARCHAR2(2000):='Data submitted is not valid :';
233: l_req_id NUMBER :=0 ;
234: l_req_number_count NUMBER ;
235: l_req_status AMS_USER_STATUSES_B.SYSTEM_STATUS_CODE%TYPE;
236: l_request_status OZF_SD_REQUEST_HEADERS_ALL_B.USER_STATUS_ID%TYPE;
237: l_curr_prod_context OZF_SD_REQUEST_LINES_ALL.PRODUCT_CONTEXT%TYPE ;
238: l_curr_code OZF_SD_REQUEST_HEADERS_ALL_B.REQUEST_CURRENCY_CODE%TYPE;
239: l_approved_lines NUMBER :=0;
240: l_error_count NUMBER := 0 ;

Line 238: l_curr_code OZF_SD_REQUEST_HEADERS_ALL_B.REQUEST_CURRENCY_CODE%TYPE;

234: l_req_number_count NUMBER ;
235: l_req_status AMS_USER_STATUSES_B.SYSTEM_STATUS_CODE%TYPE;
236: l_request_status OZF_SD_REQUEST_HEADERS_ALL_B.USER_STATUS_ID%TYPE;
237: l_curr_prod_context OZF_SD_REQUEST_LINES_ALL.PRODUCT_CONTEXT%TYPE ;
238: l_curr_code OZF_SD_REQUEST_HEADERS_ALL_B.REQUEST_CURRENCY_CODE%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' ;

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

297: x_return_status := FND_API.G_RET_STS_SUCCESS ;
298: l_error_message := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR') ;
299:
300: -- Validate the SDR Request Number
301: Select count(*) into l_req_number_count from OZF_SD_REQUEST_HEADERS_ALL_B
302: where REQUEST_NUMBER = p_request_number ;
303: IF l_req_number_count = 0 THEN
304:
305: l_msg_data := l_msg_data ||','|| 'The request number '||p_request_number ||' is not valid.' ;

Line 325: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS

321: END IF ;
322:
323:
324: Select REQ.request_header_id,STATUS.SYSTEM_STATUS_CODE,REQ.request_currency_code into l_req_id,l_req_status,l_curr_code
325: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS
326: where REQ.REQUEST_NUMBER = p_request_number
327: AND REQ.USER_STATUS_ID=STATUS.USER_STATUS_ID ;
328:
329:

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

447: END IF;
448: END LOOP;
449:
450:
451: -- UPDATE THE REQUEST STATUS IN HEADER TABLE : OZF_SD_REQUEST_HEADERS_ALL_B
452: SELECT COUNT(*) INTO l_approved_lines FROM OZF_SD_REQUEST_LINES_ALL
453: WHERE REQUEST_HEADER_ID=l_req_id
454: AND VENDOR_APPROVED_FLAG = 'Y' ;
455:

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

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 ;
476:
477:
478: ELSE