APPS.OTA_GENERAL dependencies on FND_USER

Line 25: 31 Aug 95 J Rhodes Added check_fnd_user

21: 07 Mar 95 J Rhodes Include correct messages
22: 24 Jul 95 J Rhodes Changed per_people_f to
23: per_all_people_f
24: 23 Aug 95 J Rhodes Dummy cursor get_default_values
25: 31 Aug 95 J Rhodes Added check_fnd_user
26: 31 Aug 95 J Rhodes Added get_fnd_user
27: 16 Feb 96 G Perry Added get_session_date
28: 10.18 29 Mar 96 S Shah Added check_par_child_dates_fun
29: 110.2 03 Dec 98 C Tredwin Added char_to_number

Line 26: 31 Aug 95 J Rhodes Added get_fnd_user

22: 24 Jul 95 J Rhodes Changed per_people_f to
23: per_all_people_f
24: 23 Aug 95 J Rhodes Dummy cursor get_default_values
25: 31 Aug 95 J Rhodes Added check_fnd_user
26: 31 Aug 95 J Rhodes Added get_fnd_user
27: 16 Feb 96 G Perry Added get_session_date
28: 10.18 29 Mar 96 S Shah Added check_par_child_dates_fun
29: 110.2 03 Dec 98 C Tredwin Added char_to_number
30: 115.4 11-OCT-99 R Raina Added function fnd_lang_desc

Line 463: -- |----------------------------< get_fnd_user >----------------------------|

459: --
460: End check_start_end_time;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |----------------------------< get_fnd_user >----------------------------|
464: -- ----------------------------------------------------------------------------
465: --
466: -- PUBLIC
467: -- Description: Get FND USer

Line 467: -- Description: Get FND USer

463: -- |----------------------------< get_fnd_user >----------------------------|
464: -- ----------------------------------------------------------------------------
465: --
466: -- PUBLIC
467: -- Description: Get FND USer
468: --
469: function get_fnd_user (p_user_id in number) return varchar2 is
470: --
471: l_username fnd_user.user_name%TYPE;

Line 469: function get_fnd_user (p_user_id in number) return varchar2 is

465: --
466: -- PUBLIC
467: -- Description: Get FND USer
468: --
469: function get_fnd_user (p_user_id in number) return varchar2 is
470: --
471: l_username fnd_user.user_name%TYPE;
472: --
473: cursor get_user is

Line 471: l_username fnd_user.user_name%TYPE;

467: -- Description: Get FND USer
468: --
469: function get_fnd_user (p_user_id in number) return varchar2 is
470: --
471: l_username fnd_user.user_name%TYPE;
472: --
473: cursor get_user is
474: select user_name
475: from fnd_user

Line 475: from fnd_user

471: l_username fnd_user.user_name%TYPE;
472: --
473: cursor get_user is
474: select user_name
475: from fnd_user
476: where user_id = p_user_id;
477: --
478: begin
479: open get_user;

Line 509: -- |----------------------------< check_fnd_user >----------------------------|

505: --
506: end get_session_date;
507: --
508: -- ----------------------------------------------------------------------------
509: -- |----------------------------< check_fnd_user >----------------------------|
510: -- ----------------------------------------------------------------------------
511: --
512: -- PUBLIC
513: -- Description: Check FND USer

Line 513: -- Description: Check FND USer

509: -- |----------------------------< check_fnd_user >----------------------------|
510: -- ----------------------------------------------------------------------------
511: --
512: -- PUBLIC
513: -- Description: Check FND USer
514: --
515: Function check_fnd_user (p_user_id in number) return boolean is
516: --
517: l_user varchar2(30);

Line 515: Function check_fnd_user (p_user_id in number) return boolean is

511: --
512: -- PUBLIC
513: -- Description: Check FND USer
514: --
515: Function check_fnd_user (p_user_id in number) return boolean is
516: --
517: l_user varchar2(30);
518: --
519: cursor get_user is

Line 521: from fnd_user

517: l_user varchar2(30);
518: --
519: cursor get_user is
520: select 'Y'
521: from fnd_user
522: where user_id = p_user_id;
523: --
524: begin
525: open get_user;