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.CS_CTR_CAPTURE_READING_VUHK dependencies on DBMS_SQL

Line 71: l_cursorid := DBMS_SQL.open_cursor;

67: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
68: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
69:
70: if (l_JTM_enable_prof_value = 'Y') then
71: l_cursorid := DBMS_SQL.open_cursor;
72: l_strBuffer :=
73: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'CAPTURE_COUNTER_READING_POST' ||
74: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
75: ' exception ' ||

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

75: ' exception ' ||
76: ' when others then ' ||
77: l_strLogBuffer ||
78: ' end; ';
79: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

76: ' when others then ' ||
77: l_strLogBuffer ||
78: ' end; ';
79: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);

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

77: l_strLogBuffer ||
78: ' end; ';
79: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

78: ' end; ';
79: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

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

79: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

Line 84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);

80: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
88:

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

81: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
88:
89: begin

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

82: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
88:
89: begin
90: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

83: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
84: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_Rec.counter_grp_log_id);
85: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
88:
89: begin
90: l_execute_status := DBMS_SQL.execute (l_cursorid);
91: exception

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

86: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
87: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
88:
89: begin
90: l_execute_status := DBMS_SQL.execute (l_cursorid);
91: exception
92: when others then
93: EXECUTE IMMEDIATE l_strLogBuffer;
94: end;

Line 95: DBMS_SQL.close_cursor (l_cursorid);

91: exception
92: when others then
93: EXECUTE IMMEDIATE l_strLogBuffer;
94: end;
95: DBMS_SQL.close_cursor (l_cursorid);
96: end if;
97:
98: /*
99: IF p_CTR_RDG_Tbl.count > 0 THEN

Line 103: l_cursorid := DBMS_SQL.open_cursor;

99: IF p_CTR_RDG_Tbl.count > 0 THEN
100: l_array_counter := p_CTR_RDG_Tbl.First;
101: WHILE p_CTR_RDG_Tbl.EXISTS(l_array_counter) LOOP
102: IF p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID <> FND_API.G_MISS_NUM THEN
103: l_cursorid := DBMS_SQL.open_cursor;
104: l_strBuffer :=
105: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.'
106: || 'CAPTURE_COUNTER_READING_POST' ||
107: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||

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

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

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

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

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

110: ' null; ' ||
111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);

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

111: ' end; ';
112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

112: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
113: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

Line 117: DBMS_SQL.bind_variable (l_cursorid, ':5',

113: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
114: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
121: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

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

115: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
121: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
122:
123: begin

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

116: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
121: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
122:
123: begin
124: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

117: DBMS_SQL.bind_variable (l_cursorid, ':5',
118: p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID);
119: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
121: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
122:
123: begin
124: l_execute_status := DBMS_SQL.execute (l_cursorid);
125: exception

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

120: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
121: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
122:
123: begin
124: l_execute_status := DBMS_SQL.execute (l_cursorid);
125: exception
126: when others then
127: NULL;
128: end;

Line 129: DBMS_SQL.close_cursor (l_cursorid);

125: exception
126: when others then
127: NULL;
128: end;
129: DBMS_SQL.close_cursor (l_cursorid);
130: END IF;
131: l_array_counter := p_CTR_RDG_Tbl.NEXT(l_array_counter);
132: END LOOP;
133: END IF;

Line 197: l_cursorid := DBMS_SQL.open_cursor;

193: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
194: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
195:
196: if (l_JTM_enable_prof_value = 'Y') then
197: l_cursorid := DBMS_SQL.open_cursor;
198: l_strBuffer :=
199: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
200: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
201: ' exception ' ||

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

201: ' exception ' ||
202: ' when others then ' ||
203: l_strLogBuffer ||
204: ' end; ';
205: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

202: ' when others then ' ||
203: l_strLogBuffer ||
204: ' end; ';
205: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);

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

203: l_strLogBuffer ||
204: ' end; ';
205: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

204: ' end; ';
205: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

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

205: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

Line 210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);

206: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
214:

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

207: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
214:
215: begin

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

208: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
214:
215: begin
216: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

209: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
210: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
211: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
214:
215: begin
216: l_execute_status := DBMS_SQL.execute (l_cursorid);
217: exception

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

212: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
213: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
214:
215: begin
216: l_execute_status := DBMS_SQL.execute (l_cursorid);
217: exception
218: when others then
219: EXECUTE IMMEDIATE l_strLogBuffer;
220: end;

Line 221: DBMS_SQL.close_cursor (l_cursorid);

217: exception
218: when others then
219: EXECUTE IMMEDIATE l_strLogBuffer;
220: end;
221: DBMS_SQL.close_cursor (l_cursorid);
222: end if;
223:
224: EXCEPTION
225: WHEN OTHERS THEN

Line 284: l_cursorid := DBMS_SQL.open_cursor;

280: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
281: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
282:
283: if (l_JTM_enable_prof_value = 'Y') then
284: l_cursorid := DBMS_SQL.open_cursor;
285: l_strBuffer :=
286: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
287: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
288: ' exception ' ||

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

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

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

289: ' when others then ' ||
290: l_strLogBuffer ||
291: ' end; ';
292: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
293: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
294: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
295: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);

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

290: l_strLogBuffer ||
291: ' end; ';
292: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
293: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
294: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
295: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
298: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

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

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

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

Line 297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);

293: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
294: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
295: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
298: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
299: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
300: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
301:

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

294: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
295: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
298: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
299: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
300: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
301:
302: begin

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

295: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
298: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
299: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
300: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
301:
302: begin
303: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

296: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
297: DBMS_SQL.bind_variable (l_cursorid, ':5', p_CTR_GRP_LOG_ID);
298: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
299: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
300: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
301:
302: begin
303: l_execute_status := DBMS_SQL.execute (l_cursorid);
304: exception

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

299: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
300: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
301:
302: begin
303: l_execute_status := DBMS_SQL.execute (l_cursorid);
304: exception
305: when others then
306: EXECUTE IMMEDIATE l_strLogBuffer;
307: end;

Line 308: DBMS_SQL.close_cursor (l_cursorid);

304: exception
305: when others then
306: EXECUTE IMMEDIATE l_strLogBuffer;
307: end;
308: DBMS_SQL.close_cursor (l_cursorid);
309: end if;
310:
311: EXCEPTION
312: WHEN OTHERS THEN

Line 387: l_cursorid := DBMS_SQL.open_cursor;

383: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
384: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
385:
386: if (l_JTM_enable_prof_value = 'Y') then
387: l_cursorid := DBMS_SQL.open_cursor;
388: l_strBuffer :=
389: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'CAPTURE_COUNTER_READING_POST' ||
390: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
391: ' exception ' ||

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

391: ' exception ' ||
392: ' when others then ' ||
393: l_strLogBuffer ||
394: ' end; ';
395: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

392: ' when others then ' ||
393: l_strLogBuffer ||
394: ' end; ';
395: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

393: l_strLogBuffer ||
394: ' end; ';
395: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

394: ' end; ';
395: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

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

395: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

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

396: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
404:

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

397: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
404:
405: begin

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

398: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
404:
405: begin
406: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

399: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
400: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
401: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
404:
405: begin
406: l_execute_status := DBMS_SQL.execute (l_cursorid);
407: exception

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

402: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
403: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
404:
405: begin
406: l_execute_status := DBMS_SQL.execute (l_cursorid);
407: exception
408: when others then
409: EXECUTE IMMEDIATE l_strLogBuffer;
410: end;

Line 411: DBMS_SQL.close_cursor (l_cursorid);

407: exception
408: when others then
409: EXECUTE IMMEDIATE l_strLogBuffer;
410: end;
411: DBMS_SQL.close_cursor (l_cursorid);
412: end if;
413:
414: EXCEPTION
415: WHEN OTHERS THEN

Line 475: l_cursorid := DBMS_SQL.open_cursor;

471: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
472: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
473:
474: if (l_JTM_enable_prof_value = 'Y') then
475: l_cursorid := DBMS_SQL.open_cursor;
476: l_strBuffer :=
477: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
478: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
479: ' exception ' ||

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

479: ' exception ' ||
480: ' when others then ' ||
481: l_strLogBuffer ||
482: ' end; ';
483: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

480: ' when others then ' ||
481: l_strLogBuffer ||
482: ' end; ';
483: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

481: l_strLogBuffer ||
482: ' end; ';
483: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

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

482: ' end; ';
483: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

483: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

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

484: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

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

485: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
493:

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

486: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
493:
494: begin

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

487: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
493:
494: begin
495: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

488: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
489: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
490: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
493:
494: begin
495: l_execute_status := DBMS_SQL.execute (l_cursorid);
496: exception

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

491: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
492: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
493:
494: begin
495: l_execute_status := DBMS_SQL.execute (l_cursorid);
496: exception
497: when others then
498: EXECUTE IMMEDIATE l_strLogBuffer;
499: end;

Line 500: DBMS_SQL.close_cursor (l_cursorid);

496: exception
497: when others then
498: EXECUTE IMMEDIATE l_strLogBuffer;
499: end;
500: DBMS_SQL.close_cursor (l_cursorid);
501: end if;
502:
503: EXCEPTION
504: WHEN OTHERS THEN

Line 563: l_cursorid := DBMS_SQL.open_cursor;

559: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
560: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
561:
562: if (l_JTM_enable_prof_value = 'Y') then
563: l_cursorid := DBMS_SQL.open_cursor;
564: l_strBuffer :=
565: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
566: '(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
567: ' exception ' ||

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

567: ' exception ' ||
568: ' when others then ' ||
569: l_strLogBuffer ||
570: ' end; ';
571: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

568: ' when others then ' ||
569: l_strLogBuffer ||
570: ' end; ';
571: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

569: l_strLogBuffer ||
570: ' end; ';
571: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);

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

570: ' end; ';
571: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);

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

571: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);

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

572: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);

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

573: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
581:

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

574: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
581:
582: begin

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

575: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
581:
582: begin
583: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

576: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
577: DBMS_SQL.bind_variable (l_cursorid, ':6', p_object_version_number);
578: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Return_Status);
579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
581:
582: begin
583: l_execute_status := DBMS_SQL.execute (l_cursorid);
584: exception

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

579: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Count);
580: DBMS_SQL.bind_variable (l_cursorid, ':9', X_Msg_Data);
581:
582: begin
583: l_execute_status := DBMS_SQL.execute (l_cursorid);
584: exception
585: when others then
586: EXECUTE IMMEDIATE l_strLogBuffer;
587: end;

Line 588: DBMS_SQL.close_cursor (l_cursorid);

584: exception
585: when others then
586: EXECUTE IMMEDIATE l_strLogBuffer;
587: end;
588: DBMS_SQL.close_cursor (l_cursorid);
589: end if;
590:
591: EXCEPTION
592: WHEN OTHERS THEN

Line 696: l_cursorid := DBMS_SQL.open_cursor;

692: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
693: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
694:
695: if (l_JTM_enable_prof_value = 'Y') then
696: l_cursorid := DBMS_SQL.open_cursor;
697: l_strBuffer :=
698: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'CAPTURE_CTR_PROP_READING_POST' ||
699: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
700: ' exception ' ||

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

700: ' exception ' ||
701: ' when others then ' ||
702: l_strLogBuffer ||
703: ' end; ';
704: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

701: ' when others then ' ||
702: l_strLogBuffer ||
703: ' end; ';
704: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);

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

702: l_strLogBuffer ||
703: ' end; ';
704: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);

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

703: ' end; ';
704: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);

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

704: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);

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

705: DBMS_SQL.bind_variable (l_cursorid, ':1', P_Api_Version_Number);
706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
713:

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

706: DBMS_SQL.bind_variable (l_cursorid, ':2', P_Init_Msg_List);
707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
713:
714: begin

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

707: DBMS_SQL.bind_variable (l_cursorid, ':3', P_Commit);
708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
713:
714: begin
715: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

708: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
709: DBMS_SQL.bind_variable (l_cursorid, ':5', p_COUNTER_GRP_LOG_ID);
710: DBMS_SQL.bind_variable (l_cursorid, ':6', X_Return_Status);
711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
713:
714: begin
715: l_execute_status := DBMS_SQL.execute (l_cursorid);
716: exception

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

711: DBMS_SQL.bind_variable (l_cursorid, ':7', X_Msg_Count);
712: DBMS_SQL.bind_variable (l_cursorid, ':8', X_Msg_Data);
713:
714: begin
715: l_execute_status := DBMS_SQL.execute (l_cursorid);
716: exception
717: when others then
718: EXECUTE IMMEDIATE l_strLogBuffer;
719: end;

Line 720: DBMS_SQL.close_cursor (l_cursorid);

716: exception
717: when others then
718: EXECUTE IMMEDIATE l_strLogBuffer;
719: end;
720: DBMS_SQL.close_cursor (l_cursorid);
721: end if;
722:
723: EXCEPTION
724: WHEN OTHERS THEN