APPS.OE_INC_ITEMS_FREEZE_CONC dependencies on OE_DEBUG_PUB

Line 180: Oe_debug_pub.add('Sql Stmt: ' || l_sql_stmt,1);

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);
182: -- Moac
183: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
184:

Line 187: Oe_debug_pub.add('After Executing the Cusrsor',1);

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:
190: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
191: EXIT;

Line 207: Oe_debug_pub.add('Processing Line : ' || to_char(l_line_id),1);

203: MO_GLOBAL.set_policy_context(p_access_mode => 'S', p_org_id => l_org_id);
204: END IF;
205: -- MOAC End
206:
207: Oe_debug_pub.add('Processing Line : ' || to_char(l_line_id),1);
208:
209: WF_ENGINE.CompleteActivityInternalName(
210: itemtype => 'OEOL',
211: itemkey => to_char(l_line_id),