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.CSR_RULES_PVT dependencies on XMLTYPE

Line 191: , p_rule_doc XMLTYPE

187: , p_resource_type VARCHAR2
188: , p_resource_id NUMBER
189: , p_rule_rank NUMBER
190: , p_enabled_flag VARCHAR2
191: , p_rule_doc XMLTYPE
192: )
193: RETURN NUMBER IS
194: l_new_rule_id NUMBER;
195: --

Line 283: FUNCTION get_parent_territory_rule(p_terr_id NUMBER, p_rule_doc XMLTYPE) RETURN NUMBER IS

279:
280: RETURN l_new_rule_id;
281: END insert_rule;
282:
283: FUNCTION get_parent_territory_rule(p_terr_id NUMBER, p_rule_doc XMLTYPE) RETURN NUMBER IS
284: CURSOR c_terr_hier IS
285: SELECT DISTINCT t.terr_id, LEVEL terr_level, r.rule_id
286: FROM jtf_terr_all t, csr_rules_b r
287: WHERE t.terr_id = r.terr_id (+)

Line 332: , p_rule_doc XMLTYPE

328: FUNCTION create_system_gen_base_rule(
329: p_rule_eligibility_type VARCHAR2
330: , p_eligibility_val1 NUMBER
331: , p_eligibility_val2 VARCHAR2
332: , p_rule_doc XMLTYPE
333: ) RETURN NUMBER IS
334: l_appl_id NUMBER;
335: l_resp_id NUMBER;
336: l_user_id NUMBER;

Line 393: , p_rule_doc IN XMLTYPE

389: , p_terr_id IN NUMBER DEFAULT NULL
390: , p_resource_type IN VARCHAR2 DEFAULT NULL
391: , p_resource_id IN NUMBER DEFAULT NULL
392: , p_rule_rank IN NUMBER DEFAULT NULL
393: , p_rule_doc IN XMLTYPE
394: ) IS
395: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RULE';
396: l_debug CONSTANT VARCHAR2(1) := fnd_profile.value('AFLOG_ENABLED');
397: --

Line 565: p_new_rule_doc XMLTYPE

561: RETURN FALSE;
562: END check_Element;
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

Line 566: , p_old_rule_doc XMLTYPE

562: END check_Element;
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;

Line 669: p_base_doc IN XMLTYPE

665: END IF;
666: END handle_rule_windows;
667:
668: FUNCTION propagate(
669: p_base_doc IN XMLTYPE
670: , p_child_doc IN OUT NOCOPY XMLTYPE
671: , p_child_rule_id IN NUMBER
672: , p_force IN VARCHAR2
673: ) RETURN BOOLEAN IS

Line 670: , p_child_doc IN OUT NOCOPY XMLTYPE

666: END handle_rule_windows;
667:
668: FUNCTION propagate(
669: p_base_doc IN XMLTYPE
670: , p_child_doc IN OUT NOCOPY XMLTYPE
671: , p_child_rule_id IN NUMBER
672: , p_force IN VARCHAR2
673: ) RETURN BOOLEAN IS
674:

Line 675: l_baserule_doc XMLTYPE;

671: , p_child_rule_id IN NUMBER
672: , p_force IN VARCHAR2
673: ) RETURN BOOLEAN IS
674:
675: l_baserule_doc XMLTYPE;
676: l_baserule_dom DBMS_XMLDOM.DOMDocument;
677: l_childrule_dom DBMS_XMLDOM.DOMDocument;
678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:

Line 799: , p_base_doc XMLType

795: * p_force is 'Y' then the Child Rule is updated irrespective of inheritance.
796: */
797: PROCEDURE propagate_to_child_rules(
798: p_rule_id NUMBER
799: , p_base_doc XMLType
800: , p_child_doc XMLTYPE
801: , p_force VARCHAR2
802: ) IS
803: CURSOR c_child_rules IS

Line 800: , p_child_doc XMLTYPE

796: */
797: PROCEDURE propagate_to_child_rules(
798: p_rule_id NUMBER
799: , p_base_doc XMLType
800: , p_child_doc XMLTYPE
801: , p_force VARCHAR2
802: ) IS
803: CURSOR c_child_rules IS
804: SELECT rule_id, rule_doc

Line 808: l_child_doc XMLTYPE;

804: SELECT rule_id, rule_doc
805: FROM csr_rules_b
806: WHERE base_rule_id = p_rule_id;
807:
808: l_child_doc XMLTYPE;
809: l_debug CONSTANT VARCHAR2(1) := fnd_profile.value('AFLOG_ENABLED');
810: l_api_name CONSTANT VARCHAR2(30) := 'PROPAGATE_TO_CHILD_RULES';
811: BEGIN
812:

Line 855: , p_rule_doc IN XMLTYPE

851: , p_terr_id IN NUMBER 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

Line 866: l_rule_doc XMLTYPE;

862: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RULE';
863: l_debug CONSTANT VARCHAR2(1) := fnd_profile.value('AFLOG_ENABLED');
864: --
865: l_rule_rank PLS_INTEGER;
866: l_rule_doc XMLTYPE;
867: l_note_id NUMBER;
868: l_base_rule_id NUMBER;
869: BEGIN
870: SAVEPOINT csr_rule_create;

Line 999: , p_rule_doc IN XMLTYPE DEFAULT NULL

995: , p_terr_id IN NUMBER 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

Line 1032: l_old_rule_doc XMLTYPE;

1028: AND t.language = userenv('LANG')
1029: FOR UPDATE NOWAIT;
1030:
1031: l_rule c_rule_details%ROWTYPE;
1032: l_old_rule_doc XMLTYPE;
1033: --
1034: i PLS_INTEGER;
1035: l_notes VARCHAR2(4000);
1036: l_notes_dtl VARCHAR2(4000);