DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on USER_OBJECTS

Line 2519: FROM user_objects

2515: IS
2516: CURSOR csr_package_names
2517: IS
2518: SELECT object_name
2519: FROM user_objects
2520: WHERE object_name LIKE 'FFP' || TO_CHAR(p_formula_id) || '_%'
2521: AND object_type = 'PACKAGE';
2522:
2523: l_package_name user_objects.object_name%TYPE;

Line 2523: l_package_name user_objects.object_name%TYPE;

2519: FROM user_objects
2520: WHERE object_name LIKE 'FFP' || TO_CHAR(p_formula_id) || '_%'
2521: AND object_type = 'PACKAGE';
2522:
2523: l_package_name user_objects.object_name%TYPE;
2524: l_proc_name VARCHAR2(61)
2525: := g_package_name || 'delete_formula';
2526: l_formula_rowid ROWID;
2527: l_return_code NUMBER := 0;