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

Line 139: l_sqlCursor := DBMS_SQL.Open_Cursor;

135: l_schedule_date_low,
136: l_schedule_date_high
137: FROM DUAL;
138:
139: l_sqlCursor := DBMS_SQL.Open_Cursor;
140:
141: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
142:
143: -- Moac Start

Line 141: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);

137: FROM DUAL;
138:
139: l_sqlCursor := DBMS_SQL.Open_Cursor;
140:
141: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
142:
143: -- Moac Start
144: IF p_org_id IS NOT NULL THEN
145: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);

Line 145: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);

141: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
142:
143: -- Moac Start
144: IF p_org_id IS NOT NULL THEN
145: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);
146: END IF;
147: -- Moac End
148:
149: IF p_order_num_low IS NOT NULL THEN

Line 150: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);

146: END IF;
147: -- Moac End
148:
149: IF p_order_num_low IS NOT NULL THEN
150: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);
151: END IF;
152:
153: IF p_order_num_high IS NOT NULL THEN
154: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_num_high);

Line 154: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_num_high);

150: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);
151: END IF;
152:
153: IF p_order_num_high IS NOT NULL THEN
154: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_num_high);
155: END IF;
156:
157: IF p_inventory_item_id is NOT NULL THEN
158: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_inventory_item_id);

Line 158: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_inventory_item_id);

154: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_num_high);
155: END IF;
156:
157: IF p_inventory_item_id is NOT NULL THEN
158: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_inventory_item_id);
159: END IF;
160:
161: IF p_schedule_date_low is NOT NULL THEN
162: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',l_schedule_date_low);

Line 162: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',l_schedule_date_low);

158: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_inventory_item_id);
159: END IF;
160:
161: IF p_schedule_date_low is NOT NULL THEN
162: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',l_schedule_date_low);
163: END IF;
164:
165: IF p_schedule_date_high is NOT NULL THEN
166: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',l_schedule_date_high);

Line 166: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',l_schedule_date_high);

162: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',l_schedule_date_low);
163: END IF;
164:
165: IF p_schedule_date_high is NOT NULL THEN
166: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',l_schedule_date_high);
167: END IF;
168:
169: IF p_ship_set_id is NOT NULL THEN
170: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_ship_set_id);

Line 170: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_ship_set_id);

166: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',l_schedule_date_high);
167: END IF;
168:
169: IF p_ship_set_id is NOT NULL THEN
170: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_ship_set_id);
171: END IF;
172:
173: IF (p_schedule_date_low is NULL AND
174: p_schedule_date_high is NULL) AND

Line 176: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',sysdate);

172:
173: IF (p_schedule_date_low is NULL AND
174: p_schedule_date_high is NULL) AND
175: p_num_of_days is NOT NULL THEN
176: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',sysdate);
177: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',sysdate+p_num_of_days);
178: END IF;
179:
180: Oe_debug_pub.add('Sql Stmt: ' || l_sql_stmt,1);

Line 177: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',sysdate+p_num_of_days);

173: IF (p_schedule_date_low is NULL AND
174: p_schedule_date_high is NULL) AND
175: p_num_of_days is NOT NULL THEN
176: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',sysdate);
177: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',sysdate+p_num_of_days);
178: END IF;
179:
180: Oe_debug_pub.add('Sql Stmt: ' || l_sql_stmt,1);
181: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);

Line 181: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);

177: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',sysdate+p_num_of_days);
178: END IF;
179:
180: Oe_debug_pub.add('Sql Stmt: ' || l_sql_stmt,1);
181: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
182: -- Moac
183: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
184:
185: l_dummy := DBMS_SQL.execute(l_sqlCursor);

Line 183: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);

179:
180: Oe_debug_pub.add('Sql Stmt: ' || l_sql_stmt,1);
181: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
182: -- Moac
183: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
184:
185: l_dummy := DBMS_SQL.execute(l_sqlCursor);
186:
187: Oe_debug_pub.add('After Executing the Cusrsor',1);

Line 185: l_dummy := DBMS_SQL.execute(l_sqlCursor);

181: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
182: -- Moac
183: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
184:
185: l_dummy := DBMS_SQL.execute(l_sqlCursor);
186:
187: Oe_debug_pub.add('After Executing the Cusrsor',1);
188: LOOP
189:

Line 190: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN

186:
187: Oe_debug_pub.add('After Executing the Cusrsor',1);
188: LOOP
189:
190: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
191: EXIT;
192: END IF;
193:
194: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);

Line 194: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);

190: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
191: EXIT;
192: END IF;
193:
194: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);
195: -- Moac
196: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
197:
198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Line:'||l_line_id);

Line 196: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);

192: END IF;
193:
194: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);
195: -- Moac
196: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
197:
198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Line:'||l_line_id);
199:
200: -- MOAC Start

Line 228: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);

224: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
225: END LOOP;
226: END LOOP;
227:
228: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting Freeze Included Items Program:..');
231:
232: