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

Line 4: G_SEARCH_CURSOR NUMBER := dbms_sql.open_cursor;

1: PACKAGE BODY ego_item_associations_util AS
2: /* $Header: EGOVIAUB.pls 120.6 2011/06/01 09:24:33 erwu ship $ */
3:
4: G_SEARCH_CURSOR NUMBER := dbms_sql.open_cursor;
5: G_SEARCH_STMT LONG;
6: G_PKG_NAME VARCHAR2(30);
7: G_FILE_NAME VARCHAR2(12);
8: G_USER_ID fnd_user.user_id%TYPE;

Line 294: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );

290: ' AND evv.user_id = :b_user_id '||
291: ' )';
292:
293: END IF;
294: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );
295: -- Bind the batch id which is the first parameter
296: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
297: -- Bind the search criteria values
298: IF p_search_criteria.FIRST IS NOT NULL THEN

Line 296: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );

292:
293: END IF;
294: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );
295: -- Bind the batch id which is the first parameter
296: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
297: -- Bind the search criteria values
298: IF p_search_criteria.FIRST IS NOT NULL THEN
299: l_search_col_index := p_search_criteria.FIRST;
300: WHILE l_search_col_index IS NOT NULL

Line 304: dbms_sql.bind_variable( g_search_cursor, ':bv' || l_search_col_index, p_search_criteria(l_search_col_index) );

300: WHILE l_search_col_index IS NOT NULL
301: LOOP
302: IF p_search_criteria(l_search_col_index) IS NOT NULL THEN
303: --dbms_output.put_line(' Binding ' || ':bv' || l_search_col_index || ' value ' || p_search_criteria(l_search_col_index));
304: dbms_sql.bind_variable( g_search_cursor, ':bv' || l_search_col_index, p_search_criteria(l_search_col_index) );
305: l_search_col_index := p_search_criteria.NEXT(l_search_col_index);
306: END IF;
307: END LOOP;
308: END IF;

Line 311: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

307: END LOOP;
308: END IF;
309: -- If there is no supplier search criteria then bind item id for the criteria
310: IF l_existing_suppliers_only = fnd_api.G_TRUE AND p_search_sites = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
311: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
312: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
313: END IF;
314: IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
315: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

Line 312: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

308: END IF;
309: -- If there is no supplier search criteria then bind item id for the criteria
310: IF l_existing_suppliers_only = fnd_api.G_TRUE AND p_search_sites = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
311: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
312: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
313: END IF;
314: IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
315: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
316: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

Line 315: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

311: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
312: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
313: END IF;
314: IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
315: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
316: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
317: END IF;
318: -- Bind the value for filter criteria of supplier site
319: IF p_search_sites = fnd_api.G_TRUE AND p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN

Line 316: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

312: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
313: END IF;
314: IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
315: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
316: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
317: END IF;
318: -- Bind the value for filter criteria of supplier site
319: IF p_search_sites = fnd_api.G_TRUE AND p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
320: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

Line 320: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

316: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
317: END IF;
318: -- Bind the value for filter criteria of supplier site
319: IF p_search_sites = fnd_api.G_TRUE AND p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
320: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
321: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
322: END IF;
323: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
324: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );

Line 321: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

317: END IF;
318: -- Bind the value for filter criteria of supplier site
319: IF p_search_sites = fnd_api.G_TRUE AND p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
320: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
321: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
322: END IF;
323: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
324: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
325: END IF;

Line 324: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );

320: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
321: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
322: END IF;
323: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
324: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
325: END IF;
326:
327:
328: -- Bind the value for filter condition of item-site-org intersection

Line 331: -- dbms_sql.bind_variable( g_search_cursor, ':b_item_id' , p_inventory_item_id );

327:
328: -- Bind the value for filter condition of item-site-org intersection
329: -- This cannot be done, because the mass update org table is not populated.
330: --IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
331: -- dbms_sql.bind_variable( g_search_cursor, ':b_item_id' , p_inventory_item_id );
332: -- dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
333: --END IF;
334:
335: -- Execute the query which will insert the rows in ego_suppliersite_tmp

Line 332: -- dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );

328: -- Bind the value for filter condition of item-site-org intersection
329: -- This cannot be done, because the mass update org table is not populated.
330: --IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
331: -- dbms_sql.bind_variable( g_search_cursor, ':b_item_id' , p_inventory_item_id );
332: -- dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
333: --END IF;
334:
335: -- Execute the query which will insert the rows in ego_suppliersite_tmp
336: -- Execute only when search sites is TRUE

Line 338: l_rc := dbms_sql.execute( g_search_cursor );

334:
335: -- Execute the query which will insert the rows in ego_suppliersite_tmp
336: -- Execute only when search sites is TRUE
337: IF p_search_sites = fnd_api.G_TRUE THEN
338: l_rc := dbms_sql.execute( g_search_cursor );
339: END IF;
340:
341: IF p_filter_suppliers = fnd_api.G_FALSE THEN
342: l_suppl_where_clause := l_suppl_where_clause || ' AND EXISTS ( SELECT 1 FROM ap_supplier_sites_all assa WHERE assa.vendor_id = aas.vendor_id AND assa.org_id = fnd_profile.value(''ORG_ID'') and nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE ) ';

Line 362: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );

358: ' AND evv.user_id = :b_user_id '||
359: ' )';
360:
361: END IF;
362: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );
363: -- Bind the value for filter criteria of supplier
364: IF p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
365: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
366: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

Line 365: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);

361: END IF;
362: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );
363: -- Bind the value for filter criteria of supplier
364: IF p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
365: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
366: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
367: END IF;
368: -- Bind the batch id which is the first parameter
369: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );

Line 366: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

362: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );
363: -- Bind the value for filter criteria of supplier
364: IF p_filter_rows = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
365: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
366: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
367: END IF;
368: -- Bind the batch id which is the first parameter
369: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
370: IF p_search_cols.FIRST IS NOT NULL THEN

Line 369: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );

365: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
366: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
367: END IF;
368: -- Bind the batch id which is the first parameter
369: dbms_sql.bind_variable( g_search_cursor, ':batch_id' , p_batch_id );
370: IF p_search_cols.FIRST IS NOT NULL THEN
371: l_search_col_index := 1;
372: -- Add criteria with AND condition.
373: WHILE l_search_col_index IS NOT NULL

Line 383: dbms_sql.bind_variable( g_search_cursor, ':bv' || l_search_col_index, p_search_criteria(l_search_col_index) );

379: OR p_search_cols(l_search_col_index) = G_DUNS_NUMBER
380: OR p_search_cols(l_search_col_index) = G_TAX_PAYER_ID
381: OR p_search_cols(l_search_col_index) = G_TAX_REGISTRATION_NUMBER )
382: THEN
383: dbms_sql.bind_variable( g_search_cursor, ':bv' || l_search_col_index, p_search_criteria(l_search_col_index) );
384: END IF;
385: END IF;
386: l_search_col_index := p_search_cols.NEXT(l_search_col_index);
387: END LOOP;

Line 390: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );

386: l_search_col_index := p_search_cols.NEXT(l_search_col_index);
387: END LOOP;
388: END IF;
389: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
390: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
391: END IF;
392: l_rc := dbms_sql.execute( g_search_cursor );
393: END IF;
394: COMMIT; /*Added for bug 8240551*/

Line 392: l_rc := dbms_sql.execute( g_search_cursor );

388: END IF;
389: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
390: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
391: END IF;
392: l_rc := dbms_sql.execute( g_search_cursor );
393: END IF;
394: COMMIT; /*Added for bug 8240551*/
395: EXCEPTION
396: WHEN OTHERS THEN