APPS.JTM_ITEM_INSTANCE_VUHK dependencies on DBMS_SQL

Line 41: l_cursorid := DBMS_SQL.open_cursor;

37: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
38: (p_app_short_name => Csr1.PRODUCT_CODE);
39:
40: if (l_enable_flag = 'Y') then
41: l_cursorid := DBMS_SQL.open_cursor;
42: l_strBuffer :=
43: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
44: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
45: ' exception ' ||

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

45: ' exception ' ||
46: ' when others then ' ||
47: ' null; ' ||
48: ' end; ';
49: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

46: ' when others then ' ||
47: ' null; ' ||
48: ' end; ';
49: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

Line 51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

47: ' null; ' ||
48: ' end; ';
49: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

Line 52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

48: ' end; ';
49: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

49: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

50: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
58:

Line 55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

51: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
58:
59: begin

Line 56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

52: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
58:
59: begin
60: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

53: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
54: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
55: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
58:
59: begin
60: l_execute_status := DBMS_SQL.execute (l_cursorid);
61: exception

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

56: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
58:
59: begin
60: l_execute_status := DBMS_SQL.execute (l_cursorid);
61: exception
62: when others then
63: null;
64: end;

Line 65: DBMS_SQL.close_cursor (l_cursorid);

61: exception
62: when others then
63: null;
64: end;
65: DBMS_SQL.close_cursor (l_cursorid);
66: end if;
67: END LOOP;
68:
69: EXCEPTION WHEN OTHERS THEN

Line 102: l_cursorid := DBMS_SQL.open_cursor;

98: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
99: (p_app_short_name => Csr1.PRODUCT_CODE);
100:
101: if (l_enable_flag = 'Y') then
102: l_cursorid := DBMS_SQL.open_cursor;
103: l_strBuffer :=
104: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
105: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
106: ' exception ' ||

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

106: ' exception ' ||
107: ' when others then ' ||
108: ' null; ' ||
109: ' end; ';
110: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

107: ' when others then ' ||
108: ' null; ' ||
109: ' end; ';
110: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

Line 112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

108: ' null; ' ||
109: ' end; ';
110: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

Line 113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

109: ' end; ';
110: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

110: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

111: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
119:

Line 116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

112: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
119:
120: begin

Line 117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

113: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
119:
120: begin
121: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

114: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
115: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
116: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
119:
120: begin
121: l_execute_status := DBMS_SQL.execute (l_cursorid);
122: exception

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

117: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
118: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
119:
120: begin
121: l_execute_status := DBMS_SQL.execute (l_cursorid);
122: exception
123: when others then
124: null;
125: end;

Line 126: DBMS_SQL.close_cursor (l_cursorid);

122: exception
123: when others then
124: null;
125: end;
126: DBMS_SQL.close_cursor (l_cursorid);
127: end if;
128: END LOOP;
129:
130: EXCEPTION WHEN OTHERS THEN

Line 162: l_cursorid := DBMS_SQL.open_cursor;

158: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
159: (p_app_short_name => Csr1.PRODUCT_CODE);
160:
161: if (l_enable_flag = 'Y') then
162: l_cursorid := DBMS_SQL.open_cursor;
163: l_strBuffer :=
164: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
165: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
166: ' exception ' ||

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

166: ' exception ' ||
167: ' when others then ' ||
168: ' null; ' ||
169: ' end; ';
170: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

167: ' when others then ' ||
168: ' null; ' ||
169: ' end; ';
170: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

Line 172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);

168: ' null; ' ||
169: ' end; ';
170: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

Line 173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

169: ' end; ';
170: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

170: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);

171: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
179:

Line 176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

172: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
179:
180: begin

Line 177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

173: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
179:
180: begin
181: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

174: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
175: DBMS_SQL.bind_variable (l_cursorid, ':5', p_instance_id);
176: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
179:
180: begin
181: l_execute_status := DBMS_SQL.execute (l_cursorid);
182: exception

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

177: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
178: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
179:
180: begin
181: l_execute_status := DBMS_SQL.execute (l_cursorid);
182: exception
183: when others then
184: null;
185: end;

Line 186: DBMS_SQL.close_cursor (l_cursorid);

182: exception
183: when others then
184: null;
185: end;
186: DBMS_SQL.close_cursor (l_cursorid);
187: end if;
188: END LOOP;
189:
190: EXCEPTION WHEN OTHERS THEN