DBA Data[Home] [Help]

APPS.IBW_OE_PVT dependencies on FND_PROFILE

Line 136: --FND_PROFILE.GET ('GUEST_USER_PWD', l_guest_user_pwd);

132:
133: --Bug 6727218
134: -- get guest party AND user ids
135: printLog('Getting Guest user name/Password');
136: --FND_PROFILE.GET ('GUEST_USER_PWD', l_guest_user_pwd);
137: l_guest_user_pwd:=FND_WEB_SEC.get_guest_username_pwd;
138:
139: -- Get the user name out from the profile value which is in the format USERNAME/PASSWORD
140: l_guest_username := substr(l_guest_user_pwd,1,instr(l_guest_user_pwd,'/',1,1)-1);

Line 173: ,SYSDATE,fnd_profile.VALUE('LOGIN_ID'));

169: ,l_guest_person_id
170: ,fnd_global.user_id
171: ,SYSDATE
172: ,fnd_global.user_id
173: ,SYSDATE,fnd_profile.VALUE('LOGIN_ID'));
174:
175: ELSE
176: UPDATE ibw_guest_party
177: SET customer_id = l_guest_party_id

Line 2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);

2202: FROM ibw_context_interface_vl
2203: WHERE context_instance_value = -999;
2204:
2205: BEGIN
2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);
2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);
2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);
2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);
2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);

Line 2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);

2203: WHERE context_instance_value = -999;
2204:
2205: BEGIN
2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);
2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);
2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);
2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);
2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);
2211:

Line 2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);

2204:
2205: BEGIN
2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);
2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);
2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);
2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);
2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);
2211:
2212: begin

Line 2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);

2205: BEGIN
2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);
2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);
2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);
2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);
2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);
2211:
2212: begin
2213:

Line 2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);

2206: FND_PROFILE.GET('LOGIN_ID', l_last_update_login);
2207: FND_PROFILE.GET('CONC_PROGRAM_ID', l_program_id);
2208: FND_PROFILE.GET('CONC_LOGIN_ID', l_program_login_id);
2209: FND_PROFILE.GET('CONC_PROGRAM_APPLICATION_ID', l_program_app_id);
2210: FND_PROFILE.GET('CONC_REQUEST_ID', l_request_id);
2211:
2212: begin
2213:
2214: OPEN bus_ctx_cur;