eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTM_CTR_CAPTURE_READING_VUHK dependencies on DBMS_SQL

Line 40: l_cursorid := DBMS_SQL.open_cursor;

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

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

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

Line 49: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

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

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

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

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

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

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

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

Line 53: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

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

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

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

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

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

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

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

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

Line 64: DBMS_SQL.close_cursor (l_cursorid);

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

Line 100: l_cursorid := DBMS_SQL.open_cursor;

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

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

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

Line 109: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

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

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

106: ' null; ' ||
107: ' end; ';
108: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
109: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
110: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

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

107: ' end; ';
108: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
109: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
110: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

108: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
109: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
110: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

Line 113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

109: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
110: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

Line 114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

110: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
118:

Line 115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

111: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
118:
119: begin

Line 116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

112: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
118:
119: begin
120: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

113: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
114: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
115: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
116: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
117: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
118:
119: begin
120: l_execute_status := DBMS_SQL.execute (l_cursorid);
121: exception

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

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

Line 125: DBMS_SQL.close_cursor (l_cursorid);

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

Line 160: l_cursorid := DBMS_SQL.open_cursor;

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

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

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

Line 169: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

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

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

166: ' null; ' ||
167: ' end; ';
168: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
169: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
170: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

167: ' end; ';
168: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
169: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
170: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

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

168: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
169: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
170: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

Line 173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

169: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
170: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
177:

Line 174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

170: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
177:
178: begin

Line 175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

171: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
177:
178: begin
179: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

172: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
173: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
174: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
177:
178: begin
179: l_execute_status := DBMS_SQL.execute (l_cursorid);
180: exception

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

175: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
176: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
177:
178: begin
179: l_execute_status := DBMS_SQL.execute (l_cursorid);
180: exception
181: when others then
182: NULL;
183: end;

Line 184: DBMS_SQL.close_cursor (l_cursorid);

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

Line 221: l_cursorid := DBMS_SQL.open_cursor;

217: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
218: (p_app_short_name => Csr1.PRODUCT_CODE);
219:
220: if (l_enable_flag = 'Y') then
221: l_cursorid := DBMS_SQL.open_cursor;
222: l_strBuffer :=
223: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
224: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
225: ' exception ' ||

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

225: ' exception ' ||
226: ' when others then ' ||
227: ' null; ' ||
228: ' end; ';
229: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

226: ' when others then ' ||
227: ' null; ' ||
228: ' end; ';
229: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

227: ' null; ' ||
228: ' end; ';
229: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

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

228: ' end; ';
229: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

229: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

Line 234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

230: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

Line 235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

231: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
239:

Line 236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

232: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
239:
240: begin

Line 237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

233: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
239:
240: begin
241: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

234: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
235: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
236: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
239:
240: begin
241: l_execute_status := DBMS_SQL.execute (l_cursorid);
242: exception

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

237: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
238: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
239:
240: begin
241: l_execute_status := DBMS_SQL.execute (l_cursorid);
242: exception
243: when others then
244: NULL;
245: end;

Line 246: DBMS_SQL.close_cursor (l_cursorid);

242: exception
243: when others then
244: NULL;
245: end;
246: DBMS_SQL.close_cursor (l_cursorid);
247: end if;
248: END LOOP;
249:
250: EXCEPTION WHEN OTHERS THEN

Line 281: l_cursorid := DBMS_SQL.open_cursor;

277: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
278: (p_app_short_name => Csr1.PRODUCT_CODE);
279:
280: if (l_enable_flag = 'Y') then
281: l_cursorid := DBMS_SQL.open_cursor;
282: l_strBuffer :=
283: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
284: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
285: ' exception ' ||

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

285: ' exception ' ||
286: ' when others then ' ||
287: ' null; ' ||
288: ' end; ';
289: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

286: ' when others then ' ||
287: ' null; ' ||
288: ' end; ';
289: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

287: ' null; ' ||
288: ' end; ';
289: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

288: ' end; ';
289: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

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

289: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

Line 294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

290: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
298:

Line 295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

291: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
298:
299: begin

Line 296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

292: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
298:
299: begin
300: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

293: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
294: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
295: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
298:
299: begin
300: l_execute_status := DBMS_SQL.execute (l_cursorid);
301: exception

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

296: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
297: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
298:
299: begin
300: l_execute_status := DBMS_SQL.execute (l_cursorid);
301: exception
302: when others then
303: NULL;
304: end;

Line 305: DBMS_SQL.close_cursor (l_cursorid);

301: exception
302: when others then
303: NULL;
304: end;
305: DBMS_SQL.close_cursor (l_cursorid);
306: end if;
307: END LOOP;
308:
309: EXCEPTION WHEN OTHERS THEN

Line 341: l_cursorid := DBMS_SQL.open_cursor;

337: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
338: (p_app_short_name => Csr1.PRODUCT_CODE);
339:
340: if (l_enable_flag = 'Y') then
341: l_cursorid := DBMS_SQL.open_cursor;
342: l_strBuffer :=
343: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
344: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
345: ' exception ' ||

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

345: ' exception ' ||
346: ' when others then ' ||
347: ' null; ' ||
348: ' end; ';
349: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);

346: ' when others then ' ||
347: ' null; ' ||
348: ' end; ';
349: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

347: ' null; ' ||
348: ' end; ';
349: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

348: ' end; ';
349: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

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

349: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

350: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
358:

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

351: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
358:
359: begin

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

352: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
358:
359: begin
360: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

353: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
354: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
355: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
358:
359: begin
360: l_execute_status := DBMS_SQL.execute (l_cursorid);
361: exception

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

356: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
357: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
358:
359: begin
360: l_execute_status := DBMS_SQL.execute (l_cursorid);
361: exception
362: when others then
363: NULL;
364: end;

Line 365: DBMS_SQL.close_cursor (l_cursorid);

361: exception
362: when others then
363: NULL;
364: end;
365: DBMS_SQL.close_cursor (l_cursorid);
366: end if;
367: END LOOP;
368:
369: EXCEPTION WHEN OTHERS THEN