APPS.CSL_JTF_NOTES_ACC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 123: CURSOR c_jtf_rs_resource_extns (b_user_id NUMBER) IS

119: /*** Public Function that returns the resource extn id ***/
120: FUNCTION Get_Resource_Extn_Id( p_user_id NUMBER)
121: RETURN NUMBER
122: IS
123: CURSOR c_jtf_rs_resource_extns (b_user_id NUMBER) IS
124: SELECT resource_id
125: FROM JTF_RS_RESOURCE_EXTNS
126: WHERE user_id = b_user_id;
127: r_jtf_rs_resource_extns c_jtf_rs_resource_extns%ROWTYPE;

Line 125: FROM JTF_RS_RESOURCE_EXTNS

121: RETURN NUMBER
122: IS
123: CURSOR c_jtf_rs_resource_extns (b_user_id NUMBER) IS
124: SELECT resource_id
125: FROM JTF_RS_RESOURCE_EXTNS
126: WHERE user_id = b_user_id;
127: r_jtf_rs_resource_extns c_jtf_rs_resource_extns%ROWTYPE;
128:
129: BEGIN

Line 127: r_jtf_rs_resource_extns c_jtf_rs_resource_extns%ROWTYPE;

123: CURSOR c_jtf_rs_resource_extns (b_user_id NUMBER) IS
124: SELECT resource_id
125: FROM JTF_RS_RESOURCE_EXTNS
126: WHERE user_id = b_user_id;
127: r_jtf_rs_resource_extns c_jtf_rs_resource_extns%ROWTYPE;
128:
129: BEGIN
130: /*** get debug level ***/
131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 141: OPEN c_jtf_rs_resource_extns( p_user_id );

137: , 'Entering Get_Resource_Extn_Id'
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
139: END IF;
140:
141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;

138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
139: END IF;
140:
141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
146: jtm_message_log_pkg.Log_Msg

Line 143: IF c_jtf_rs_resource_extns%NOTFOUND THEN

139: END IF;
140:
141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
146: jtm_message_log_pkg.Log_Msg
147: ( p_user_id

Line 144: /*** could not find jtf_rs_resource_extns record -> exit ***/

140:
141: OPEN c_jtf_rs_resource_extns( p_user_id );
142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
146: jtm_message_log_pkg.Log_Msg
147: ( p_user_id
148: , g_table_name

Line 153: CLOSE c_jtf_rs_resource_extns;

149: , 'Get_Resource_Extn_Id error: Could not find p_user_id ' || p_user_id
150: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
151: END IF;
152:
153: CLOSE c_jtf_rs_resource_extns;
154: RETURN -1;
155: END IF;
156: CLOSE c_jtf_rs_resource_extns;
157:

Line 156: CLOSE c_jtf_rs_resource_extns;

152:
153: CLOSE c_jtf_rs_resource_extns;
154: RETURN -1;
155: END IF;
156: CLOSE c_jtf_rs_resource_extns;
157:
158: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
159: jtm_message_log_pkg.Log_Msg
160: ( p_user_id

Line 167: return r_jtf_rs_resource_extns.resource_id;

163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
164: END IF;
165:
166: /** return the entered by id ***/
167: return r_jtf_rs_resource_extns.resource_id;
168: END Get_Resource_Extn_Id;
169:
170: /*** Private procedure that replicates given jtf_note related data for resource ***/
171: PROCEDURE Insert_ACC_Record