DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on FND_GLOBAL

Line 163: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

159: j BINARY_INTEGER := 1;
160: l_order_by_clause VARCHAR2(2000) := NULL;
161: l_api_name CONSTANT VARCHAR2(30) := 'Translate_OrderBy';
162: l_api_version_number CONSTANT NUMBER := 1.0;
163: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
164: begin
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
167: p_api_version_number,

Line 6029: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

Line 6030: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

6026: l_to_insert NUMBER ;
6027: l_found_rec NUMBER ;
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

Line 6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');

6136: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6137: aso_debug_pub.add( '*******************************************',1, 'Y' );
6138: aso_debug_pub.add( ' ',1, 'Y' );
6139:
6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');

Line 6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');

6137: aso_debug_pub.add( '*******************************************',1, 'Y' );
6138: aso_debug_pub.add( ' ',1, 'Y' );
6139:
6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');

Line 6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');

6138: aso_debug_pub.add( ' ',1, 'Y' );
6139:
6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');

Line 6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');

6139:
6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6147:

Line 6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');

6140: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6147:
6148: aso_debug_pub.add( ' ',1, 'Y' );

Line 6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');

6141: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6147:
6148: aso_debug_pub.add( ' ',1, 'Y' );
6149:

Line 6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');

6142: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6143: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6144: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6145: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6146: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6147:
6148: aso_debug_pub.add( ' ',1, 'Y' );
6149:
6150: