APPS.JTM_RS_GROUP_MEMBER_VUHK dependencies on DBMS_SQL

Line 53: l_cursorid := DBMS_SQL.open_cursor;

49: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
50: (p_app_short_name => Csr1.PRODUCT_CODE);
51:
52: if (l_enable_flag = 'Y') then
53: l_cursorid := DBMS_SQL.open_cursor;
54: l_strBuffer :=
55: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
56: '(:1,:2,:3, :4); ' ||
57: ' exception ' ||

Line 61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

57: ' exception ' ||
58: ' when others then ' ||
59: ' null; ' ||
60: ' end; ';
61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);

Line 62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);

58: ' when others then ' ||
59: ' null; ' ||
60: ' end; ';
61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
66: begin

Line 63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);

59: ' null; ' ||
60: ' end; ';
61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
66: begin
67: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);

60: ' end; ';
61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
66: begin
67: l_execute_status := DBMS_SQL.execute (l_cursorid);
68: exception

Line 65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);

61: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
62: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_MEMBER_ID);
63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
66: begin
67: l_execute_status := DBMS_SQL.execute (l_cursorid);
68: exception
69: when others then

Line 67: l_execute_status := DBMS_SQL.execute (l_cursorid);

63: DBMS_SQL.bind_variable (l_cursorid, ':2', P_GROUP_ID);
64: DBMS_SQL.bind_variable (l_cursorid, ':3', P_RESOURCE_ID);
65: DBMS_SQL.bind_variable (l_cursorid, ':4', X_RETURN_STATUS);
66: begin
67: l_execute_status := DBMS_SQL.execute (l_cursorid);
68: exception
69: when others then
70: NULL;
71: end;

Line 72: DBMS_SQL.close_cursor (l_cursorid);

68: exception
69: when others then
70: NULL;
71: end;
72: DBMS_SQL.close_cursor (l_cursorid);
73: end if;
74: END LOOP;
75:
76: EXCEPTION WHEN OTHERS THEN

Line 131: l_cursorid := DBMS_SQL.open_cursor;

127: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
128: (p_app_short_name => Csr1.PRODUCT_CODE);
129:
130: if (l_enable_flag = 'Y') then
131: l_cursorid := DBMS_SQL.open_cursor;
132: l_strBuffer :=
133: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
134: '(:1,:2,:3); ' ||
135: ' exception ' ||

Line 139: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

135: ' exception ' ||
136: ' when others then ' ||
137: ' null; ' ||
138: ' end; ';
139: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
143: begin

Line 140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);

136: ' when others then ' ||
137: ' null; ' ||
138: ' end; ';
139: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
143: begin
144: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);

137: ' null; ' ||
138: ' end; ';
139: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
143: begin
144: l_execute_status := DBMS_SQL.execute (l_cursorid);
145: exception

Line 142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);

138: ' end; ';
139: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
143: begin
144: l_execute_status := DBMS_SQL.execute (l_cursorid);
145: exception
146: when others then

Line 144: l_execute_status := DBMS_SQL.execute (l_cursorid);

140: DBMS_SQL.bind_variable (l_cursorid, ':1', P_GROUP_ID);
141: DBMS_SQL.bind_variable (l_cursorid, ':2', P_RESOURCE_ID);
142: DBMS_SQL.bind_variable (l_cursorid, ':3', X_RETURN_STATUS);
143: begin
144: l_execute_status := DBMS_SQL.execute (l_cursorid);
145: exception
146: when others then
147: null;
148: end;

Line 149: DBMS_SQL.close_cursor (l_cursorid);

145: exception
146: when others then
147: null;
148: end;
149: DBMS_SQL.close_cursor (l_cursorid);
150: end if;
151: END LOOP;
152:
153: EXCEPTION WHEN OTHERS THEN