APPS.CN_CLASSIFICATION_GEN dependencies on CN_SOURCE

Line 611: -- Delete module source code from cn_source

607: create_object(module_id, package_name, 'PKB',package_body_id, package_body_desc,x_org_id);
608: delete_flag := 'N';
609: END IF;
610:
611: -- Delete module source code from cn_source
612: -- Delete module object dependencies for this module
613: IF (delete_flag = 'Y') THEN
614: cn_utils.delete_module(module_id, package_spec_id, package_body_id,x_org_id);
615: END IF;

Line 1988: FROM cn_source cs

1984: l_paired_quotes BOOLEAN;
1985:
1986: CURSOR pkg_spec_start (p_object_id NUMBER) IS
1987: SELECT cs.line_no
1988: FROM cn_source cs
1989: WHERE cs.object_id = p_object_id
1990: AND substr(cs.text, 1, 25) = 'CREATE OR REPLACE PACKAGE'
1991: AND instr(cs.text, '--START-OF-PKS') <> 0
1992: ORDER BY line_no;

Line 1996: FROM cn_source cs

1992: ORDER BY line_no;
1993:
1994: CURSOR pkg_spec_end (p_object_id NUMBER) IS
1995: SELECT cs.line_no
1996: FROM cn_source cs
1997: WHERE cs.object_id = p_object_id
1998: AND cs.text like 'END%'
1999: ORDER BY line_no;
2000:

Line 2003: FROM cn_source cs

1999: ORDER BY line_no;
2000:
2001: CURSOR pkg_body_start (p_object_id NUMBER) IS
2002: SELECT cs.line_no
2003: FROM cn_source cs
2004: WHERE cs.object_id = p_object_id
2005: AND substr(cs.text, 1, 30) = 'CREATE OR REPLACE PACKAGE BODY'
2006: AND instr(cs.text, '--START-OF-PKB') <> 0
2007: ORDER BY line_no;

Line 2011: FROM cn_source cs

2007: ORDER BY line_no;
2008:
2009: CURSOR pkg_body_end (p_object_id NUMBER) IS
2010: SELECT cs.line_no
2011: FROM cn_source cs
2012: WHERE cs.object_id = p_object_id
2013: AND cs.text like 'END%'
2014: ORDER BY line_no;
2015:

Line 2020: FROM cn_source cs

2016: CURSOR fetch_code (p_pks_start NUMBER,
2017: p_pks_end NUMBER,
2018: p_pks_object_id NUMBER) IS
2019: SELECT cs.text
2020: FROM cn_source cs
2021: WHERE cs.object_id = p_pks_object_id
2022: AND cs.line_no between p_pks_start and (p_pks_end - 1)
2023: ORDER BY cs.line_no;
2024:

Line 2069: FROM cn_source

2065: SELECT substr(text, instr(text, 'cn_clsfn'),
2066: instr(substr(text, instr(text, 'cn_clsfn'), length(text)),
2067: ' AS --START-OF'))
2068: INTO l_pkg_name
2069: FROM cn_source
2070: WHERE line_no = l_pks_start
2071: AND object_id = l_pks_object_id;
2072:
2073: l_pkg_name := RTRIM(UPPER(l_pkg_name));

Line 2119: FROM cn_source

2115: SELECT substr(text, instr(text, 'cn_clsfn_'),
2116: instr(substr(text, instr(text, 'cn_clsfn_'), length(text)),
2117: ' AS --START-OF'))
2118: INTO l_pkg_name
2119: FROM cn_source
2120: WHERE line_no = l_pkb_start
2121: AND object_id = l_pkb_object_id;
2122:
2123: l_pkg_name := RTRIM(UPPER(l_pkg_name));