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.XLA_CMP_PAD_PKG dependencies on DBMS_SQL

Line 1248: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

1244: ,p_package_name IN VARCHAR2
1245: --
1246: ,p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1247: ,p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1248: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
1249: RETURN BOOLEAN IS
1250: --
1251: l_IsCompiled BOOLEAN;
1252: l_IsGenerated BOOLEAN;

Line 1254: l_array_body DBMS_SQL.VARCHAR2S;

1250: --
1251: l_IsCompiled BOOLEAN;
1252: l_IsGenerated BOOLEAN;
1253: --
1254: l_array_body DBMS_SQL.VARCHAR2S;
1255: l_array_string DBMS_SQL.VARCHAR2S;
1256: l_log_module VARCHAR2(240);
1257: --
1258: BEGIN

Line 1255: l_array_string DBMS_SQL.VARCHAR2S;

1251: l_IsCompiled BOOLEAN;
1252: l_IsGenerated BOOLEAN;
1253: --
1254: l_array_body DBMS_SQL.VARCHAR2S;
1255: l_array_string DBMS_SQL.VARCHAR2S;
1256: l_log_module VARCHAR2(240);
1257: --
1258: BEGIN
1259: IF g_log_enabled THEN

Line 1531: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

1527: ,p_product_rule_name IN VARCHAR2
1528: ,p_product_rule_version IN VARCHAR2
1529: ,p_amb_context_code IN VARCHAR2
1530: ,p_package_name IN VARCHAR2
1531: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
1532: RETURN BOOLEAN IS
1533: --
1534: l_rec_aad_objects xla_cmp_source_pkg.t_rec_aad_objects;
1535: l_rec_sources xla_cmp_source_pkg.t_rec_sources;

Line 1627: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

1623: ,p_product_rule_code IN VARCHAR2
1624: ,p_product_rule_type_code IN VARCHAR2
1625: ,p_product_rule_version IN VARCHAR2
1626: ,p_amb_context_code IN VARCHAR2
1627: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
1628: RETURN BOOLEAN IS
1629:
1630: l_array_pkg DBMS_SQL.VARCHAR2S;
1631: l_BodyPkg VARCHAR2(32000);

Line 1630: l_array_pkg DBMS_SQL.VARCHAR2S;

1626: ,p_amb_context_code IN VARCHAR2
1627: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
1628: RETURN BOOLEAN IS
1629:
1630: l_array_pkg DBMS_SQL.VARCHAR2S;
1631: l_BodyPkg VARCHAR2(32000);
1632: l_array_body DBMS_SQL.VARCHAR2S;
1633: l_IsCompiled BOOLEAN;
1634: l_log_module VARCHAR2(240);

Line 1632: l_array_body DBMS_SQL.VARCHAR2S;

1628: RETURN BOOLEAN IS
1629:
1630: l_array_pkg DBMS_SQL.VARCHAR2S;
1631: l_BodyPkg VARCHAR2(32000);
1632: l_array_body DBMS_SQL.VARCHAR2S;
1633: l_IsCompiled BOOLEAN;
1634: l_log_module VARCHAR2(240);
1635:
1636: BEGIN

Line 1698: -- create the PL/SQL DBMS_SQL.VARCHAR2S array

1694: xla_cmp_string_pkg.ConcatTwoStrings
1695: (p_array_string_1 => l_array_pkg
1696: ,p_array_string_2 => l_array_body);
1697: --
1698: -- create the PL/SQL DBMS_SQL.VARCHAR2S array
1699: --
1700: l_BodyPkg := C_PACKAGE_BODY_2;
1701: --
1702: l_BodyPkg := REPLACE(l_BodyPkg,'$PRODUCT_RULE_CODE$' ,p_product_rule_code);

Line 1758: l_Package DBMS_SQL.VARCHAR2S;

1754: ,p_product_rule_version IN VARCHAR2
1755: ,p_amb_context_code IN VARCHAR2)
1756: RETURN BOOLEAN IS
1757: --
1758: l_Package DBMS_SQL.VARCHAR2S;
1759: l_PackageName VARCHAR2(30);
1760: l_ProductRuleName VARCHAR2(80);
1761: l_ProductRuleVersion VARCHAR2(30);
1762: --