[Home] [Help]
PACKAGE: APPS.XLA_CONDITIONS_PKG
Source
1 PACKAGE xla_conditions_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaamcon.pkh 120.3 2011/12/20 13:52:07 sgullape ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_conditions_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Conditions package |
13 | |
14 | HISTORY |
15 | 01-May-01 Dimple Shah Created |
16 | 20-Dec-11 sgullape Created New procedure |
17 | display_condition_substr for bug 13109140 |
18 +======================================================================*/
19
20 /*======================================================================+
21 | |
22 | Public Procedure |
23 | |
24 | delete_condition |
25 | |
26 | Deletes all conditions attached to the parent |
27 | |
28 +======================================================================*/
29
30 PROCEDURE delete_condition
31 (p_context IN VARCHAR2
32 ,p_application_id IN NUMBER DEFAULT NULL
33 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
34 ,p_entity_code IN VARCHAR2 DEFAULT NULL
35 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
36 ,p_accounting_line_type_code IN VARCHAR2 DEFAULT NULL
37 ,p_accounting_line_code IN VARCHAR2 DEFAULT NULL
38 ,p_segment_rule_detail_id IN NUMBER DEFAULT NULL
39 ,p_description_prio_id IN NUMBER DEFAULT NULL);
40
41 /*======================================================================+
42 | |
43 | Public Function |
44 | |
45 | display_condition |
46 | |
47 | Returns the entire condition for the parent |
48 | |
49 +======================================================================*/
50
51 FUNCTION display_condition
52 (p_application_id IN NUMBER DEFAULT NULL
53 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
54 ,p_entity_code IN VARCHAR2 DEFAULT NULL
55 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
56 ,p_accounting_line_type_code IN VARCHAR2 DEFAULT NULL
57 ,p_accounting_line_code IN VARCHAR2 DEFAULT NULL
58 ,p_segment_rule_detail_id IN NUMBER DEFAULT NULL
59 ,p_description_prio_id IN NUMBER DEFAULT NULL
60 ,p_chart_of_accounts_id IN NUMBER DEFAULT NULL
61 ,p_context IN VARCHAR2)
62 RETURN VARCHAR2;
63
64 /*======================================================================+
65 | |
66 | Public Function |
67 | |
68 | display_condition_substr |
69 | |
70 | Returns the condition based on the index valuesfor the parent |
71 | |
72 +======================================================================*/
73
74 FUNCTION display_condition_substr
75 (p_application_id IN NUMBER DEFAULT NULL
76 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
77 ,p_entity_code IN VARCHAR2 DEFAULT NULL
78 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
79 ,p_accounting_line_type_code IN VARCHAR2 DEFAULT NULL
80 ,p_accounting_line_code IN VARCHAR2 DEFAULT NULL
81 ,p_segment_rule_detail_id IN NUMBER DEFAULT NULL
82 ,p_description_prio_id IN NUMBER DEFAULT NULL
83 ,p_chart_of_accounts_id IN NUMBER DEFAULT NULL
84 ,p_context IN VARCHAR2
85 ,p_start_indx IN NUMBER
86 ,p_end_indx IN NUMBER)
87 RETURN VARCHAR2;
88
89 /*======================================================================+
90 | |
91 | Public Function |
92 | |
93 | desc_condition_is_invalid |
94 | |
95 | Returns true if condition is invalid |
96 | |
97 +======================================================================*/
98
99 FUNCTION desc_condition_is_invalid
100 (p_application_id IN NUMBER
101 ,p_amb_context_code IN VARCHAR2
102 ,p_description_type_code IN VARCHAR2
103 ,p_description_code IN VARCHAR2
104 ,p_message_name IN OUT NOCOPY VARCHAR2)
105 RETURN BOOLEAN;
106
107 /*======================================================================+
108 | |
109 | Public Function |
110 | |
111 | seg_condition_is_invalid |
112 | |
113 | Returns true if condition is invalid |
114 | |
115 +======================================================================*/
116
117 FUNCTION seg_condition_is_invalid
118 (p_application_id IN NUMBER
119 ,p_amb_context_code IN VARCHAR2
120 ,p_segment_rule_type_code IN VARCHAR2
121 ,p_segment_rule_code IN VARCHAR2
122 ,p_message_name IN OUT NOCOPY VARCHAR2)
123 RETURN BOOLEAN;
124
125 /*======================================================================+
126 | |
127 | Public Function |
128 | |
129 | acct_condition_is_invalid |
130 | |
131 | Returns true if condition is invalid |
132 | |
133 +======================================================================*/
134
135 FUNCTION acct_condition_is_invalid
136 (p_application_id IN NUMBER
137 ,p_amb_context_code IN VARCHAR2
138 ,p_entity_code IN VARCHAR2
139 ,p_event_class_code IN VARCHAR2
140 ,p_accounting_line_type_code IN VARCHAR2
141 ,p_accounting_line_code IN VARCHAR2
142 ,p_message_name IN OUT NOCOPY VARCHAR2)
143 RETURN BOOLEAN;
144
145 END xla_conditions_pkg;