DBA Data[Home] [Help]

APPS.ZPB_BISM dependencies on BISM_SUBJECTS

Line 32: -- OUT: l_subject_id - bism_subjects.subject_id, raw

28: -- GET_BISM_SUBJECT_ID - Given a user_id eg. 1008187, returns the
29: -- bism subject id
30: --
31: -- IN: p_user_id - FND User id, integer
32: -- OUT: l_subject_id - bism_subjects.subject_id, raw
33: -------------------------------------------------------------------------------
34:
35: FUNCTION get_bism_subject_id (
36: p_user_id IN fnd_user.user_id%TYPE)

Line 37: return bism_subjects.subject_id%TYPE;

33: -------------------------------------------------------------------------------
34:
35: FUNCTION get_bism_subject_id (
36: p_user_id IN fnd_user.user_id%TYPE)
37: return bism_subjects.subject_id%TYPE;
38:
39: -------------------------------------------------------------------------------
40: -- GET_BISM_SUBJECT_ID - Given a varchar2 user_id eg. '1008187',
41: -- returns the raw bism subject id.

Line 45: -- OUT: l_subject_id - bism_subjects.subject_id, raw

41: -- returns the raw bism subject id.
42: -- calls.
43: --
44: -- IN: p_user_id - FND User id, varchar2
45: -- OUT: l_subject_id - bism_subjects.subject_id, raw
46: -------------------------------------------------------------------------------
47:
48: FUNCTION get_bism_subject_id (
49: p_user_id IN varchar2)

Line 50: return bism_subjects.subject_id%TYPE;

46: -------------------------------------------------------------------------------
47:
48: FUNCTION get_bism_subject_id (
49: p_user_id IN varchar2)
50: return bism_subjects.subject_id%TYPE;
51:
52: -------------------------------------------------------------------------------
53: -- GET_BISM_SUBJECT_ID_FROM_NAME - Given a user_name eg. 'JSMITH', returns the
54: -- bism subject id

Line 57: -- OUT: l_subject_id - bism_subjects.subject_id, raw

53: -- GET_BISM_SUBJECT_ID_FROM_NAME - Given a user_name eg. 'JSMITH', returns the
54: -- bism subject id
55: --
56: -- IN: p_user_name - FND User name e.g. JSMITH
57: -- OUT: l_subject_id - bism_subjects.subject_id, raw
58: -------------------------------------------------------------------------------
59:
60: FUNCTION get_bism_subject_id_from_name (
61: p_user_name IN fnd_user.user_name%TYPE)

Line 62: return bism_subjects.subject_id%TYPE;

58: -------------------------------------------------------------------------------
59:
60: FUNCTION get_bism_subject_id_from_name (
61: p_user_name IN fnd_user.user_name%TYPE)
62: return bism_subjects.subject_id%TYPE;
63:
64: -------------------------------------------------------------------------------
65: -- GET_BISM_SUBJECT_ID_FROM_RESP - Given a responsibility key eg. 'ZPB_MANAGER_RESP',
66: -- returns the bism subject id

Line 69: -- OUT: l_subject_id - bism_subjects.subject_id, raw

65: -- GET_BISM_SUBJECT_ID_FROM_RESP - Given a responsibility key eg. 'ZPB_MANAGER_RESP',
66: -- returns the bism subject id
67: --
68: -- IN: p_resp_key - FND responsibility key e.g. ZPB_MANAGER_RESP, varchar2
69: -- OUT: l_subject_id - bism_subjects.subject_id, raw
70: -------------------------------------------------------------------------------
71:
72: FUNCTION get_bism_subject_id_from_resp (
73: p_resp_key IN fnd_responsibility.responsibility_key%TYPE)

Line 74: return bism_subjects.subject_id%TYPE;

70: -------------------------------------------------------------------------------
71:
72: FUNCTION get_bism_subject_id_from_resp (
73: p_resp_key IN fnd_responsibility.responsibility_key%TYPE)
74: return bism_subjects.subject_id%TYPE;
75:
76: -------------------------------------------------------------------------------
77: -- GET_BISM_OBJECT_ID - Given an object path, returns the bism object id
78: --

Line 81: -- OUT: l_folder_id - bism_subjects.folder_id, raw

77: -- GET_BISM_OBJECT_ID - Given an object path, returns the bism object id
78: --
79: -- IN: p_object_path - path 'oracle/apps/zpb/BusArea...'
80: -- IN: p_bism_subject_id - raw subject_id
81: -- OUT: l_folder_id - bism_subjects.folder_id, raw
82: -------------------------------------------------------------------------------
83:
84: FUNCTION get_bism_object_id (
85: p_object_path IN varchar2,

Line 86: p_bism_subject_id IN bism_subjects.subject_id%TYPE)

82: -------------------------------------------------------------------------------
83:
84: FUNCTION get_bism_object_id (
85: p_object_path IN varchar2,
86: p_bism_subject_id IN bism_subjects.subject_id%TYPE)
87: return bism_objects.folder_id%TYPE;
88:
89: -------------------------------------------------------------------------------
90: -- GET_BISM_OBJECT_DESC - Given an object path, and apps numeric, returns the