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.3 2007/06/07 04:59:58 grastogi noship $ */
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 293: dbms_sql.parse( g_search_cursor, g_search_stmt, dbms_sql.native );

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

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

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

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

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

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

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

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

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

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

310: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
311: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
312: END IF;
313: IF p_search_existing_site_only = fnd_api.G_TRUE AND p_inventory_item_id IS NOT NULL THEN
314: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
315: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
316: END IF;
317: -- Bind the value for filter criteria of supplier site
318: 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 315: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);

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

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

315: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
316: END IF;
317: -- Bind the value for filter criteria of supplier site
318: 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
319: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
320: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
321: END IF;
322: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
323: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );

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

316: END IF;
317: -- Bind the value for filter criteria of supplier site
318: 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
319: dbms_sql.bind_variable( g_search_cursor, ':b_item_id', p_inventory_item_id);
320: dbms_sql.bind_variable( g_search_cursor, ':b_master_org_id', p_master_org_id);
321: END IF;
322: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
323: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
324: END IF;

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

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

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

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

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

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

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

333:
334: -- Execute the query which will insert the rows in ego_suppliersite_tmp
335: -- Execute only when search sites is TRUE
336: IF p_search_sites = fnd_api.G_TRUE THEN
337: l_rc := dbms_sql.execute( g_search_cursor );
338: END IF;
339:
340: IF p_filter_suppliers = fnd_api.G_FALSE THEN
341: 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'')) ';

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

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

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

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

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

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

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

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

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

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

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

385: l_search_col_index := p_search_cols.NEXT(l_search_col_index);
386: END LOOP;
387: END IF;
388: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
389: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
390: END IF;
391: l_rc := dbms_sql.execute( g_search_cursor );
392: END IF;
393:

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

387: END IF;
388: IF is_supplier_contact(G_PARTY_ID) = FND_API.G_TRUE THEN
389: dbms_sql.bind_variable( g_search_cursor, ':b_user_id' , G_USER_ID );
390: END IF;
391: l_rc := dbms_sql.execute( g_search_cursor );
392: END IF;
393:
394: EXCEPTION
395: WHEN OTHERS THEN