DBA Data[Home] [Help]

APPS.OTA_TRNG_ENROLL_SS dependencies on FND_USER

Line 112: FND_USER

108: CURSOR csr_user(p_owner_id in number) IS
109: SELECT
110: USER_NAME
111: FROM
112: FND_USER
113: WHERE
114: Employee_id = p_owner_id ;
115:
116: CURSOR csr_activity(p_activity_version_id number )

Line 176: l_owner_username fnd_user.user_name%type;

172: l_course_end_date ota_events.course_end_date%type;
173: l_owner_id ota_events.owner_id%type;
174: l_activity_version_id ota_activity_versions.activity_version_id%type;
175: l_version_name ota_activity_versions.version_name%type;
176: l_owner_username fnd_user.user_name%type;
177: --Bug#2197997 commenting out completeactivity call.
178: -- l_return boolean;
179: l_offering_id ota_events.offering_id%type;
180: l_booking_status_used varchar2(20);

Line 1213: FND_USER

1209: CURSOR C_USER IS
1210: SELECT
1211: EMPLOYEE_ID
1212: FROM
1213: FND_USER
1214: WHERE
1215: user_id = l_current_user_id ;
1216:
1217: BEGIN

Line 1896: FND_USER USR

1892: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1893: SELECT usr.user_name,
1894: evt.offering_id
1895: FROM OTA_EVENTS evt,
1896: FND_USER USR
1897: WHERE evt.event_id = p_event_id and
1898: usr.employee_id = evt.owner_id;
1899:
1900:

Line 1913: l_user_name FND_USER.USER_NAME%TYPE;

1909: l_api_result VARCHAR2(4000);
1910: l_api_from VARCHAR2(4000);
1911: l_api_to VARCHAR2(4000);
1912: l_event_id NUMBER;
1913: l_user_name FND_USER.USER_NAME%TYPE;
1914: l_offering_id ota_events.offering_id%type;
1915: l_booking_id ota_delegate_bookings.booking_id%type;
1916: l_version_name ota_activity_versions.version_name%type;
1917: l_notification_text varchar2(2000);