6460:
6461: -- Change START
6462: -- Release 12
6463: -- Changes Done by : Girish
6464: -- Comments : Procedure to add entry in ASO_CHANGED_QUOTES
6465:
6466: PROCEDURE UPDATE_CHANGED_QUOTES (
6467: p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
6468: )
6463: -- Changes Done by : Girish
6464: -- Comments : Procedure to add entry in ASO_CHANGED_QUOTES
6465:
6466: PROCEDURE UPDATE_CHANGED_QUOTES (
6467: p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
6468: )
6469: IS
6470:
6471: l_module_name VARCHAR2(30) := 'ASO';
6471: l_module_name VARCHAR2(30) := 'ASO';
6472: l_source_name VARCHAR2(50) := 'asovutlb.pls';
6473: l_error_text VARCHAR2(2000);
6474:
6475: l_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE;
6476: l_conc_request_id ASO_CHANGED_QUOTES.CONC_REQUEST_ID%TYPE;
6477: l_to_insert NUMBER ;
6478: l_found_rec NUMBER ;
6479:
6472: l_source_name VARCHAR2(50) := 'asovutlb.pls';
6473: l_error_text VARCHAR2(2000);
6474:
6475: l_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE;
6476: l_conc_request_id ASO_CHANGED_QUOTES.CONC_REQUEST_ID%TYPE;
6477: l_to_insert NUMBER ;
6478: l_found_rec NUMBER ;
6479:
6480: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6479:
6480: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6481: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6482:
6483: CURSOR cur_find_rec(p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE) IS
6484: SELECT quote_number, conc_request_id
6485: FROM aso_changed_quotes
6486: WHERE quote_number = p_quote_number;
6487: BEGIN
6481: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6482:
6483: CURSOR cur_find_rec(p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE) IS
6484: SELECT quote_number, conc_request_id
6485: FROM aso_changed_quotes
6486: WHERE quote_number = p_quote_number;
6487: BEGIN
6488:
6489: l_to_insert := 0;
6535:
6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6544: P_QUOTE_NUMBER => p_quote_number,
6545: P_LAST_UPDATE_DATE => SYSDATE,
6546: P_LAST_UPDATED_BY => G_USER_ID,
6547: P_CREATION_DATE => SYSDATE,