APPS.CN_UTILS dependencies on CN_MODULES

Line 65: PROCEDURE delete_module (x_module_id cn_modules.module_id%TYPE,

61: BEGIN
62: g_org_id := null;
63: END;
64:
65: PROCEDURE delete_module (x_module_id cn_modules.module_id%TYPE,
66: x_package_spec_id cn_objects.object_id%TYPE,
67: x_package_body_id cn_objects.object_id%TYPE,
68: p_org_id IN NUMBER) IS
69: BEGIN

Line 679: module_id cn_modules.module_id%TYPE,

675: END pkg_end_boilerplate;
676: --end clob
677:
678: PROCEDURE pkg_init (
679: module_id cn_modules.module_id%TYPE,
680: package_name cn_obj_packages_v.name%TYPE,
681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

Line 836: module_id cn_modules.module_id%TYPE,

832: --end clob
833:
834: -- overloaded for use in formula generation, adding package_flag = 'FORMULA'
835: PROCEDURE pkg_init (
836: module_id cn_modules.module_id%TYPE,
837: package_name cn_obj_packages_v.name%TYPE,
838: package_org_append VARCHAR2,
839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,

Line 879: module_id cn_modules.module_id%TYPE,

875:
876: --for clob
877: -- overloaded for use in formula generation, adding package_flag = 'FORMULA'
878: PROCEDURE pkg_init (
879: module_id cn_modules.module_id%TYPE,
880: package_name cn_obj_packages_v.name%TYPE,
881: package_org_append VARCHAR2,
882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,

Line 1625: FUNCTION get_repository (X_module_id cn_modules.module_id%TYPE, p_org_id IN NUMBER)

1621: RETURN X_name;
1622: END get_object_name;
1623:
1624:
1625: FUNCTION get_repository (X_module_id cn_modules.module_id%TYPE, p_org_id IN NUMBER)
1626: RETURN cn_repositories.repository_id%TYPE IS
1627: X_repository_id cn_repositories.repository_id%TYPE;
1628: BEGIN
1629: SELECT repository_id INTO X_repository_id

Line 1630: FROM cn_modules

1626: RETURN cn_repositories.repository_id%TYPE IS
1627: X_repository_id cn_repositories.repository_id%TYPE;
1628: BEGIN
1629: SELECT repository_id INTO X_repository_id
1630: FROM cn_modules
1631: WHERE module_id = X_module_id
1632: AND org_id = p_org_id;
1633: RETURN X_repository_id;
1634: END get_repository;

Line 1638: FUNCTION get_event (X_module_id cn_modules.module_id%TYPE, p_org_id IN NUMBER)

1634: END get_repository;
1635:
1636:
1637:
1638: FUNCTION get_event (X_module_id cn_modules.module_id%TYPE, p_org_id IN NUMBER)
1639: RETURN cn_events.event_id%TYPE IS
1640: X_event_id cn_events.event_id%TYPE;
1641: BEGIN
1642: SELECT event_id INTO X_event_id

Line 1643: FROM cn_modules

1639: RETURN cn_events.event_id%TYPE IS
1640: X_event_id cn_events.event_id%TYPE;
1641: BEGIN
1642: SELECT event_id INTO X_event_id
1643: FROM cn_modules
1644: WHERE module_id = X_module_id
1645: AND org_id = p_org_id;
1646: RETURN X_event_id;
1647: END get_event;