DBA Data[Home] [Help]

APPS.CSR_RULES_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 10: g_rule_param_names_tbl jtf_varchar2_table_300;

6:
7: g_rules_ns CONSTANT VARCHAR2(100) := 'http://xmlns.oracle.com/CRM/Scheduler/Rules';
8:
9: -- Parameter Name and XPath Map
10: g_rule_param_names_tbl jtf_varchar2_table_300;
11:
12: TYPE node_tbl_type IS TABLE OF DBMS_XMLDOM.DOMNode;
13:
14: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS

Line 37: g_rule_param_names_tbl := jtf_varchar2_table_300();

33: *************************************************************************/
34:
35: PROCEDURE init_package IS
36: BEGIN
37: g_rule_param_names_tbl := jtf_varchar2_table_300();
38: g_rule_param_names_tbl.extend(57);
39:
40: g_rule_param_names_tbl(01) := 'spPlanScope';
41: g_rule_param_names_tbl(02) := 'spMaxPlanOptions';

Line 567: , p_window_names jtf_varchar2_table_300

563:
564: PROCEDURE handle_rule_windows(
565: p_new_rule_doc XMLTYPE
566: , p_old_rule_doc XMLTYPE
567: , p_window_names jtf_varchar2_table_300
568: , p_window_descriptions jtf_varchar2_table_1500
569: ) IS
570: l_rule_document DBMS_XMLDOM.DOMDocument;
571: l_root_element DBMS_XMLDOM.DOMElement;

Line 856: , p_window_names IN jtf_varchar2_table_300 DEFAULT NULL

852: , p_resource_type IN VARCHAR2 DEFAULT NULL
853: , p_resource_id IN NUMBER DEFAULT NULL
854: , p_enabled_flag IN VARCHAR2 DEFAULT NULL
855: , p_rule_doc IN XMLTYPE
856: , p_window_names IN jtf_varchar2_table_300 DEFAULT NULL
857: , p_window_descriptions IN jtf_varchar2_table_1500 DEFAULT NULL
858: , x_rule_id OUT NOCOPY NUMBER
859: , x_new_rule_doc OUT NOCOPY CLOB
860: ) IS

Line 1000: , p_window_names IN jtf_varchar2_table_300 DEFAULT NULL

996: , p_resource_type IN VARCHAR2 DEFAULT NULL
997: , p_resource_id IN NUMBER DEFAULT NULL
998: , p_enabled_flag IN VARCHAR2 DEFAULT NULL
999: , p_rule_doc IN XMLTYPE DEFAULT NULL
1000: , p_window_names IN jtf_varchar2_table_300 DEFAULT NULL
1001: , p_window_descriptions IN jtf_varchar2_table_1500 DEFAULT NULL
1002: , p_version_msgs IN jtf_varchar2_table_4000
1003: , p_force_propagation IN VARCHAR2 DEFAULT NULL
1004: , x_new_rule_doc OUT NOCOPY CLOB