APPS.JTM_COUNTERS_VUHK dependencies on DBMS_SQL

Line 43: l_cursorid := DBMS_SQL.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

52: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
53: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
54: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
55: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );

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

53: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
54: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
55: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);

54: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
55: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
62:

Line 59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);

55: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
56: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
62:
63: begin

Line 60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );

56: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
62:
63: begin
64: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

57: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
58: DBMS_SQL.bind_variable (l_cursorid, ':7', p_source_object_cd);
59: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_id);
60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
62:
63: begin
64: l_execute_status := DBMS_SQL.execute (l_cursorid);
65: exception

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

60: DBMS_SQL.bind_variable (l_cursorid, ':9', x_ctr_grp_id );
61: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
62:
63: begin
64: l_execute_status := DBMS_SQL.execute (l_cursorid);
65: exception
66: when others then
67: /* to be integrate with message handler */
68: NULL;

Line 70: DBMS_SQL.close_cursor (l_cursorid);

66: when others then
67: /* to be integrate with message handler */
68: NULL;
69: end;
70: DBMS_SQL.close_cursor (l_cursorid);
71: end if;
72: END LOOP;
73:
74: EXCEPTION WHEN OTHERS THEN

Line 106: l_cursorid := DBMS_SQL.open_cursor;

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

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

110: ' exception ' ||
111: ' when others then ' ||
112: ' null; ' ||
113: ' end; ';
114: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

111: ' when others then ' ||
112: ' null; ' ||
113: ' end; ';
114: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

112: ' null; ' ||
113: ' end; ';
114: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

113: ' end; ';
114: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );

Line 118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

114: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

Line 119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

115: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
123:

Line 120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

116: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
123:
124: begin

Line 121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );

117: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

118: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
119: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
120: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);
126: exception

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

121: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_id );
122: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
123:
124: begin
125: l_execute_status := DBMS_SQL.execute (l_cursorid);
126: exception
127: when others then
128: /* to be integrate with message handler */
129: NULL;

Line 131: DBMS_SQL.close_cursor (l_cursorid);

127: when others then
128: /* to be integrate with message handler */
129: NULL;
130: end;
131: DBMS_SQL.close_cursor (l_cursorid);
132: end if;
133: END LOOP;
134:
135: EXCEPTION WHEN OTHERS THEN

Line 166: l_cursorid := DBMS_SQL.open_cursor;

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

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

170: ' exception ' ||
171: ' when others then ' ||
172: ' null; ' ||
173: ' end; ';
174: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

171: ' when others then ' ||
172: ' null; ' ||
173: ' end; ';
174: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

172: ' null; ' ||
173: ' end; ';
174: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

173: ' end; ';
174: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );

Line 178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

174: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

Line 179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

175: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
183:

Line 180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

176: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
183:
184: begin

Line 181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );

177: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
183:
184: begin
185: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);

178: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
179: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
180: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
183:
184: begin
185: l_execute_status := DBMS_SQL.execute (l_cursorid);
186: exception

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

181: DBMS_SQL.bind_variable (l_cursorid, ':7', x_ctr_prop_id );
182: DBMS_SQL.bind_variable (l_cursorid, ':8', x_object_version_number);
183:
184: begin
185: l_execute_status := DBMS_SQL.execute (l_cursorid);
186: exception
187: when others then
188: /* to be integrate with message handler */
189: NULL;

Line 191: DBMS_SQL.close_cursor (l_cursorid);

187: when others then
188: /* to be integrate with message handler */
189: NULL;
190: end;
191: DBMS_SQL.close_cursor (l_cursorid);
192: end if;
193: END LOOP;
194:
195: EXCEPTION WHEN OTHERS THEN

Line 229: l_cursorid := DBMS_SQL.open_cursor;

225: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
226: (p_app_short_name => Csr1.PRODUCT_CODE);
227:
228: if (l_enable_flag = 'Y') then
229: l_cursorid := DBMS_SQL.open_cursor;
230: l_strBuffer :=
231: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
232: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11); ' ||
233: ' exception ' ||

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

233: ' exception ' ||
234: ' when others then ' ||
235: ' null; ' ||
236: ' end; ';
237: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

234: ' when others then ' ||
235: ' null; ' ||
236: ' end; ';
237: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

235: ' null; ' ||
236: ' end; ';
237: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

236: ' end; ';
237: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );

Line 241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

237: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);

Line 242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

238: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);

Line 243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

239: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);

Line 244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );

240: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);

Line 245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);

241: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
249:

Line 246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);

242: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
249:
250: begin

Line 247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);

243: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
249:
250: begin
251: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);

244: DBMS_SQL.bind_variable (l_cursorid, ':7', p_counter_group_id_template );
245: DBMS_SQL.bind_variable (l_cursorid, ':8', p_source_object_code_instance);
246: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id_instance);
247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
249:
250: begin
251: l_execute_status := DBMS_SQL.execute (l_cursorid);
252: exception

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

247: DBMS_SQL.bind_variable (l_cursorid, ':10', x_ctr_grp_id_template);
248: DBMS_SQL.bind_variable (l_cursorid, ':11', x_ctr_grp_id_instance);
249:
250: begin
251: l_execute_status := DBMS_SQL.execute (l_cursorid);
252: exception
253: when others then
254: /* to be integrate with message handler */
255: NULL;

Line 257: DBMS_SQL.close_cursor (l_cursorid);

253: when others then
254: /* to be integrate with message handler */
255: NULL;
256: end;
257: DBMS_SQL.close_cursor (l_cursorid);
258: end if;
259: END LOOP;
260:
261: EXCEPTION WHEN OTHERS THEN

Line 294: l_cursorid := DBMS_SQL.open_cursor;

290: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
291: (p_app_short_name => Csr1.PRODUCT_CODE);
292:
293: if (l_enable_flag = 'Y') then
294: l_cursorid := DBMS_SQL.open_cursor;
295: l_strBuffer :=
296: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
297: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
298: ' exception ' ||

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

298: ' exception ' ||
299: ' when others then ' ||
300: ' null; ' ||
301: ' end; ';
302: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

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

299: ' when others then ' ||
300: ' null; ' ||
301: ' end; ';
302: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

300: ' null; ' ||
301: ' end; ';
302: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

301: ' end; ';
302: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

302: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

Line 307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

303: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

304: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

305: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

306: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
314:

Line 311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

307: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
314:
315: begin

Line 312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

308: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
314:
315: begin
316: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

309: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
310: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
311: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
314:
315: begin
316: l_execute_status := DBMS_SQL.execute (l_cursorid);
317: exception

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

312: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
313: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
314:
315: begin
316: l_execute_status := DBMS_SQL.execute (l_cursorid);
317: exception
318: when others then
319: /* to be integrate with message handler */
320: null;

Line 322: DBMS_SQL.close_cursor (l_cursorid);

318: when others then
319: /* to be integrate with message handler */
320: null;
321: end;
322: DBMS_SQL.close_cursor (l_cursorid);
323: end if;
324: END LOOP;
325:
326: EXCEPTION WHEN OTHERS THEN

Line 359: l_cursorid := DBMS_SQL.open_cursor;

355: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
356: (p_app_short_name => Csr1.PRODUCT_CODE);
357:
358: if (l_enable_flag = 'Y') then
359: l_cursorid := DBMS_SQL.open_cursor;
360: l_strBuffer :=
361: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
362: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
363: ' exception ' ||

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

363: ' exception ' ||
364: ' when others then ' ||
365: ' null; ' ||
366: ' end; ';
367: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);

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

364: ' when others then ' ||
365: ' null; ' ||
366: ' end; ';
367: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

365: ' null; ' ||
366: ' end; ';
367: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

366: ' end; ';
367: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

367: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

Line 372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

368: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

369: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

370: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );

371: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
379:

Line 376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

372: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
379:
380: begin

Line 377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

373: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
379:
380: begin
381: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

374: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
375: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_grp_id );
376: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
379:
380: begin
381: l_execute_status := DBMS_SQL.execute (l_cursorid);
382: exception

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

377: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
378: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
379:
380: begin
381: l_execute_status := DBMS_SQL.execute (l_cursorid);
382: exception
383: when others then
384: /* to be integrate with message handler */
385: null;

Line 387: DBMS_SQL.close_cursor (l_cursorid);

383: when others then
384: /* to be integrate with message handler */
385: null;
386: end;
387: DBMS_SQL.close_cursor (l_cursorid);
388: end if;
389: END LOOP;
390:
391: EXCEPTION WHEN OTHERS THEN

Line 424: l_cursorid := DBMS_SQL.open_cursor;

420: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
421: (p_app_short_name => Csr1.PRODUCT_CODE);
422:
423: if (l_enable_flag = 'Y') then
424: l_cursorid := DBMS_SQL.open_cursor;
425: l_strBuffer :=
426: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
427: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
428: ' exception ' ||

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

428: ' exception ' ||
429: ' when others then ' ||
430: ' null; ' ||
431: ' end; ';
432: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

429: ' when others then ' ||
430: ' null; ' ||
431: ' end; ';
432: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

430: ' null; ' ||
431: ' end; ';
432: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

431: ' end; ';
432: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

432: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

433: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

434: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

435: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
443:

Line 440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

436: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
443:
444: begin

Line 441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

437: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
443:
444: begin
445: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

438: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
439: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
440: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
443:
444: begin
445: l_execute_status := DBMS_SQL.execute (l_cursorid);
446: exception

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

441: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
442: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
443:
444: begin
445: l_execute_status := DBMS_SQL.execute (l_cursorid);
446: exception
447: when others then
448: /* to be integrate with message handler */
449: null;

Line 451: DBMS_SQL.close_cursor (l_cursorid);

447: when others then
448: /* to be integrate with message handler */
449: null;
450: end;
451: DBMS_SQL.close_cursor (l_cursorid);
452: end if;
453: END LOOP;
454:
455: EXCEPTION WHEN OTHERS THEN

Line 488: l_cursorid := DBMS_SQL.open_cursor;

484: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
485: (p_app_short_name => Csr1.PRODUCT_CODE);
486:
487: if (l_enable_flag = 'Y') then
488: l_cursorid := DBMS_SQL.open_cursor;
489: l_strBuffer :=
490: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
491: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
492: ' exception ' ||

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

492: ' exception ' ||
493: ' when others then ' ||
494: ' null; ' ||
495: ' end; ';
496: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

493: ' when others then ' ||
494: ' null; ' ||
495: ' end; ';
496: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

494: ' null; ' ||
495: ' end; ';
496: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

495: ' end; ';
496: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

496: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

497: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

498: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

499: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
507:

Line 504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

500: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
507:
508: begin

Line 505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

501: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
507:
508: begin
509: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

502: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
503: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
504: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
507:
508: begin
509: l_execute_status := DBMS_SQL.execute (l_cursorid);
510: exception

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

505: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
506: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
507:
508: begin
509: l_execute_status := DBMS_SQL.execute (l_cursorid);
510: exception
511: when others then
512: /* to be integrate with message handler */
513: null;

Line 515: DBMS_SQL.close_cursor (l_cursorid);

511: when others then
512: /* to be integrate with message handler */
513: null;
514: end;
515: DBMS_SQL.close_cursor (l_cursorid);
516: end if;
517: END LOOP;
518:
519: EXCEPTION WHEN OTHERS THEN

Line 552: l_cursorid := DBMS_SQL.open_cursor;

548: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
549: (p_app_short_name => Csr1.PRODUCT_CODE);
550:
551: if (l_enable_flag = 'Y') then
552: l_cursorid := DBMS_SQL.open_cursor;
553: l_strBuffer :=
554: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
555: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
556: ' exception ' ||

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

556: ' exception ' ||
557: ' when others then ' ||
558: ' null; ' ||
559: ' end; ';
560: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

557: ' when others then ' ||
558: ' null; ' ||
559: ' end; ';
560: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

558: ' null; ' ||
559: ' end; ';
560: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

559: ' end; ';
560: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

560: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

561: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

562: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

563: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
571:

Line 568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

564: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
571:
572: begin

Line 569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

565: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
571:
572: begin
573: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

566: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
567: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
568: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
571:
572: begin
573: l_execute_status := DBMS_SQL.execute (l_cursorid);
574: exception

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

569: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
570: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
571:
572: begin
573: l_execute_status := DBMS_SQL.execute (l_cursorid);
574: exception
575: when others then
576: /* to be integrate with message handler */
577: NULL;

Line 579: DBMS_SQL.close_cursor (l_cursorid);

575: when others then
576: /* to be integrate with message handler */
577: NULL;
578: end;
579: DBMS_SQL.close_cursor (l_cursorid);
580: end if;
581: END LOOP;
582:
583: EXCEPTION WHEN OTHERS THEN

Line 616: l_cursorid := DBMS_SQL.open_cursor;

612: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
613: (p_app_short_name => Csr1.PRODUCT_CODE);
614:
615: if (l_enable_flag = 'Y') then
616: l_cursorid := DBMS_SQL.open_cursor;
617: l_strBuffer :=
618: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
619: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||
620: ' exception ' ||

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

620: ' exception ' ||
621: ' when others then ' ||
622: ' null; ' ||
623: ' end; ';
624: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

621: ' when others then ' ||
622: ' null; ' ||
623: ' end; ';
624: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

622: ' null; ' ||
623: ' end; ';
624: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

623: ' end; ';
624: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

624: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

Line 629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

625: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

Line 630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

626: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

Line 631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

627: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
635:

Line 632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);

628: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
635:
636: begin

Line 633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);

629: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
635:
636: begin
637: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);

630: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
631: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
632: DBMS_SQL.bind_variable (l_cursorid, ':8', p_object_version_number);
633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
635:
636: begin
637: l_execute_status := DBMS_SQL.execute (l_cursorid);
638: exception

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

633: DBMS_SQL.bind_variable (l_cursorid, ':9', p_cascade_upd_to_instances);
634: DBMS_SQL.bind_variable (l_cursorid, ':10', x_object_version_number);
635:
636: begin
637: l_execute_status := DBMS_SQL.execute (l_cursorid);
638: exception
639: when others then
640: /* to be integrate with message handler */
641: NULL;

Line 643: DBMS_SQL.close_cursor (l_cursorid);

639: when others then
640: /* to be integrate with message handler */
641: NULL;
642: end;
643: DBMS_SQL.close_cursor (l_cursorid);
644: end if;
645: END LOOP;
646:
647: EXCEPTION WHEN OTHERS THEN

Line 677: l_cursorid := DBMS_SQL.open_cursor;

673: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
674: (p_app_short_name => Csr1.PRODUCT_CODE);
675:
676: if (l_enable_flag = 'Y') then
677: l_cursorid := DBMS_SQL.open_cursor;
678: l_strBuffer :=
679: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
680: '(:1,:2,:3,:4,:5,:6,:7); ' ||
681: ' exception ' ||

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

681: ' exception ' ||
682: ' when others then ' ||
683: ' null; ' ||
684: ' end; ';
685: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

682: ' when others then ' ||
683: ' null; ' ||
684: ' end; ';
685: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

683: ' null; ' ||
684: ' end; ';
685: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

684: ' end; ';
685: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

Line 689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

685: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
693:

Line 690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

686: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
693:
694: begin

Line 691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

687: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
693:
694: begin
695: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );

688: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
689: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
690: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
693:
694: begin
695: l_execute_status := DBMS_SQL.execute (l_cursorid);
696: exception

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

691: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
692: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_id );
693:
694: begin
695: l_execute_status := DBMS_SQL.execute (l_cursorid);
696: exception
697: when others then
698: /* to be integrate with message handler */
699: NULL;

Line 701: DBMS_SQL.close_cursor (l_cursorid);

697: when others then
698: /* to be integrate with message handler */
699: NULL;
700: end;
701: DBMS_SQL.close_cursor (l_cursorid);
702: end if;
703: END LOOP;
704:
705: EXCEPTION WHEN OTHERS THEN

Line 735: l_cursorid := DBMS_SQL.open_cursor;

731: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
732: (p_app_short_name => Csr1.PRODUCT_CODE);
733:
734: if (l_enable_flag = 'Y') then
735: l_cursorid := DBMS_SQL.open_cursor;
736: l_strBuffer :=
737: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
738: '(:1,:2,:3,:4,:5,:6,:7); ' ||
739: ' exception ' ||

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

739: ' exception ' ||
740: ' when others then ' ||
741: ' null; ' ||
742: ' end; ';
743: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

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

740: ' when others then ' ||
741: ' null; ' ||
742: ' end; ';
743: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

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

741: ' null; ' ||
742: ' end; ';
743: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

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

742: ' end; ';
743: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

Line 747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);

743: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
751:

Line 748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);

744: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
751:
752: begin

Line 749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);

745: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
751:
752: begin
753: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );

746: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
747: DBMS_SQL.bind_variable (l_cursorid, ':4', X_Return_Status);
748: DBMS_SQL.bind_variable (l_cursorid, ':5', X_Msg_Count);
749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
751:
752: begin
753: l_execute_status := DBMS_SQL.execute (l_cursorid);
754: exception

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

749: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Msg_Data);
750: DBMS_SQL.bind_variable (l_cursorid, ':7', p_ctr_prop_id );
751:
752: begin
753: l_execute_status := DBMS_SQL.execute (l_cursorid);
754: exception
755: when others then
756: /* to be integrate with message handler */
757: NULL;

Line 759: DBMS_SQL.close_cursor (l_cursorid);

755: when others then
756: /* to be integrate with message handler */
757: NULL;
758: end;
759: DBMS_SQL.close_cursor (l_cursorid);
760: end if;
761: END LOOP;
762:
763: EXCEPTION WHEN OTHERS THEN

Line 794: l_cursorid := DBMS_SQL.open_cursor;

790: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
791: (p_app_short_name => Csr1.PRODUCT_CODE);
792:
793: if (l_enable_flag = 'Y') then
794: l_cursorid := DBMS_SQL.open_cursor;
795: l_strBuffer :=
796: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
797: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
798: ' exception ' ||

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

798: ' exception ' ||
799: ' when others then ' ||
800: ' null; ' ||
801: ' end; ';
802: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );

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

799: ' when others then ' ||
800: ' null; ' ||
801: ' end; ';
802: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );

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

800: ' null; ' ||
801: ' end; ';
802: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

801: ' end; ';
802: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );

802: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );

803: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
811:

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

804: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
811:
812: begin

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

805: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
811:
812: begin
813: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

806: DBMS_SQL.bind_variable (l_cursorid, ':4', p_SOURCE_OBJECT_ID );
807: DBMS_SQL.bind_variable (l_cursorid, ':5', p_SOURCE_OBJECT_CODE );
808: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
811:
812: begin
813: l_execute_status := DBMS_SQL.execute (l_cursorid);
814: exception

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

809: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
810: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
811:
812: begin
813: l_execute_status := DBMS_SQL.execute (l_cursorid);
814: exception
815: when others then
816: /* to be integrate with message handler */
817: NULL;

Line 819: DBMS_SQL.close_cursor (l_cursorid);

815: when others then
816: /* to be integrate with message handler */
817: NULL;
818: end;
819: DBMS_SQL.close_cursor (l_cursorid);
820: end if;
821: END LOOP;
822:
823: EXCEPTION WHEN OTHERS THEN