APPS.FF_WRAPPER_SUP_PKG dependencies on USER_OBJECTS

Line 403: from user_objects o

399: -- Cursor to check the status of the package body.
400: --
401: cursor csr_pkg_status(p_package_name in varchar2) is
402: select status
403: from user_objects o
404: where o.object_name = p_package_name
405: and o.object_type = c_package_body
406: ;
407: begin

Line 469: from user_objects o

465: --
466: cursor csr_pkg_status(p_package_name in varchar2) is
467: select o.status
468: , o.object_type
469: from user_objects o
470: where o.object_name = p_package_name
471: ;
472: --
473: -- Cursor to check if the package body exists.

Line 477: from user_objects o

473: -- Cursor to check if the package body exists.
474: --
475: cursor csr_body_exists(p_package_name in varchar2) is
476: select null
477: from user_objects o
478: where o.object_name = p_package_name
479: and o.object_type = c_package_body
480: ;
481: begin

Line 643: from user_objects o

639: l_status varchar2(32);
640: --
641: cursor csr_pkg_status(p_package_name in varchar2) is
642: select status
643: from user_objects o
644: where o.object_name = p_package_name
645: and o.object_type = c_package_body
646: ;
647: begin

Line 667: from user_objects uo

663: cursor csr_check_compile
664: (p_package_name in varchar2
665: ) is
666: select status
667: from user_objects uo
668: where uo.object_name = p_package_name
669: and uo.object_type = c_package_body;
670: l_status varchar2(64);
671: begin

Line 988: from user_objects uo

984: -- Confirm that a package exists and is valid.
985: --
986: cursor csr_package_exists(p_package_name in varchar2) is
987: select null
988: from user_objects uo
989: where uo.object_name = p_package_name
990: and uo.object_type = c_package
991: and uo.status = c_object_valid
992: ;

Line 998: from user_objects uo

994: -- Cursor to get the name of the wrapper packages.
995: --
996: cursor csr_wrap_pkgs(p_wrapper_name in varchar2) is
997: select uo.object_name
998: from user_objects uo
999: where uo.object_name like p_wrapper_name
1000: and uo.object_type = c_package
1001: ;
1002: begin

Line 1316: from user_objects uo

1312: l_start_date date;
1313: --
1314: cursor csr_ff_package_names(p_prefix in varchar2) is
1315: select uo.object_name
1316: from user_objects uo
1317: where uo.object_name like p_prefix
1318: and uo.object_type = c_package
1319: order by uo.object_name;
1320: begin