DBA Data[Home] [Help]

APPS.AR_RAXSOL_XMLP_PKG dependencies on AR_LOOKUPS

Line 58: from ar_lookups

54: l_id VARCHAR2 (80);
55: BEGIN
56: select meaning
57: into l_id
58: from ar_lookups
59: where lookup_type = 'REFERENCE'
60: and lookup_code = 'Id';
61:
62: rp_id := l_id ;

Line 74: from ar_lookups

70: l_none VARCHAR2 (80);
71: BEGIN
72: select meaning
73: into l_none
74: from ar_lookups
75: where lookup_type = 'REFERENCE'
76: and lookup_code = 'None';
77:
78: rp_none := l_none ;

Line 90: from ar_lookups

86: l_number VARCHAR2 (80);
87: BEGIN
88: select meaning
89: into l_number
90: from ar_lookups
91: where lookup_type = 'REFERENCE'
92: and lookup_code = 'Number';
93:
94: rp_number := l_number ;

Line 107: from ar_lookups

103: l_segment VARCHAR2 (80);
104: BEGIN
105: select meaning
106: into l_segment
107: from ar_lookups
108: where lookup_type = 'REFERENCE'
109: and lookup_code = 'Segment';
110:
111: rp_segment := l_segment ;

Line 124: from ar_lookups

120: l_value VARCHAR2 (80);
121: BEGIN
122: select meaning
123: into l_value
124: from ar_lookups
125: where lookup_type = 'REFERENCE'
126: and lookup_code = 'Value';
127:
128: rp_value := l_value ;

Line 140: from ar_lookups

136: l_yes VARCHAR2 (80);
137: BEGIN
138: select meaning
139: into l_yes
140: from ar_lookups
141: where lookup_type = 'YES/NO'
142: and lookup_code = 'Y';
143:
144: rp_yes := l_yes ;

Line 156: from ar_lookups

152: l_no VARCHAR2 (80);
153: BEGIN
154: select meaning
155: into l_no
156: from ar_lookups
157: where lookup_type = 'YES/NO'
158: and lookup_code = 'N';
159:
160: rp_no := l_no ;

Line 171: from ar_lookups

167: l_amt VARCHAR2 (80);
168: BEGIN
169: select meaning
170: into l_amt
171: from ar_lookups
172: where lookup_type = 'AMT/PER'
173: and lookup_code = 'Amount';
174:
175: rp_amt := l_amt ;

Line 186: from ar_lookups

182: l_per VARCHAR2 (80);
183: BEGIN
184: select meaning
185: into l_per
186: from ar_lookups
187: where lookup_type = 'AMT/PER'
188: and lookup_code = 'Percent';
189:
190: rp_per := l_per ;

Line 201: from ar_lookups

197: l_code VARCHAR2 (80);
198: BEGIN
199: select meaning
200: into l_code
201: from ar_lookups
202: where lookup_type = 'CODE'
203: and lookup_code = 'Code';
204:
205: rp_code := l_code ;