APPS.ASO_UTILITY_PVT dependencies on ASO_CHANGED_QUOTES

Line 6013: -- Comments : Procedure to add entry in ASO_CHANGED_QUOTES

6009:
6010: -- Change START
6011: -- Release 12
6012: -- Changes Done by : Girish
6013: -- Comments : Procedure to add entry in ASO_CHANGED_QUOTES
6014:
6015: PROCEDURE UPDATE_CHANGED_QUOTES (
6016: p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
6017: )

Line 6016: p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE

6012: -- Changes Done by : Girish
6013: -- Comments : Procedure to add entry in ASO_CHANGED_QUOTES
6014:
6015: PROCEDURE UPDATE_CHANGED_QUOTES (
6016: p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE
6017: )
6018: IS
6019:
6020: l_module_name VARCHAR2(30) := 'ASO';

Line 6024: l_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE;

6020: l_module_name VARCHAR2(30) := 'ASO';
6021: l_source_name VARCHAR2(50) := 'asovutlb.pls';
6022: l_error_text VARCHAR2(2000);
6023:
6024: l_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE;
6025: l_conc_request_id ASO_CHANGED_QUOTES.CONC_REQUEST_ID%TYPE;
6026: l_to_insert NUMBER ;
6027: l_found_rec NUMBER ;
6028:

Line 6025: l_conc_request_id ASO_CHANGED_QUOTES.CONC_REQUEST_ID%TYPE;

6021: l_source_name VARCHAR2(50) := 'asovutlb.pls';
6022: l_error_text VARCHAR2(2000);
6023:
6024: l_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE;
6025: l_conc_request_id ASO_CHANGED_QUOTES.CONC_REQUEST_ID%TYPE;
6026: l_to_insert NUMBER ;
6027: l_found_rec NUMBER ;
6028:
6029: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 6032: CURSOR cur_find_rec(p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE) IS

6028:
6029: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6030: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6031:
6032: CURSOR cur_find_rec(p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE) IS
6033: SELECT quote_number, conc_request_id
6034: FROM aso_changed_quotes
6035: WHERE quote_number = p_quote_number;
6036: BEGIN

Line 6034: FROM aso_changed_quotes

6030: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6031:
6032: CURSOR cur_find_rec(p_quote_number ASO_CHANGED_QUOTES.QUOTE_NUMBER%TYPE) IS
6033: SELECT quote_number, conc_request_id
6034: FROM aso_changed_quotes
6035: WHERE quote_number = p_quote_number;
6036: BEGIN
6037:
6038: l_to_insert := 0;

Line 6088: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');

6084:
6085: IF (l_to_insert = 1) THEN
6086:
6087: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6088: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6089: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6090: END IF;
6091:
6092: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(

Line 6092: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(

6088: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6089: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6090: END IF;
6091:
6092: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6093: P_QUOTE_NUMBER => p_quote_number,
6094: P_LAST_UPDATE_DATE => SYSDATE,
6095: P_LAST_UPDATED_BY => G_USER_ID,
6096: P_CREATION_DATE => SYSDATE,