DBA Data[Home] [Help]

APPS.IGS_FI_AD_HOC_WAV dependencies on FND_LOOKUP_VALUES

Line 141: FUNCTION test_mode (p_code IN fnd_lookup_values.lookup_code%TYPE) RETURN VARCHAR2 IS

137: END log_messages ;
138:
139: /* Removed the function sub_name as a part of Subaccount removal Build. Bug # 2564643 */
140:
141: FUNCTION test_mode (p_code IN fnd_lookup_values.lookup_code%TYPE) RETURN VARCHAR2 IS
142:
143: ------------------------------------------------------------------
144: --Created by : Jabeen Begum, Oracle IDC
145: --Date created: 20/12/2001

Line 155: --pathipat 26-Apr-2004 Bug 3578249 - Modified cur_mode - replaced fnd_lookup_values

151: --Known limitations/enhancements and/or remarks:
152: --
153: --Change History:
154: --Who When What
155: --pathipat 26-Apr-2004 Bug 3578249 - Modified cur_mode - replaced fnd_lookup_values
156: -- with igs_lookup_values.
157: --vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_mode.
158: -------------------------------------------------------------------
159:

Line 160: CURSOR cur_mode(cp_code fnd_lookup_values.lookup_code%TYPE) IS

156: -- with igs_lookup_values.
157: --vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_mode.
158: -------------------------------------------------------------------
159:
160: CURSOR cur_mode(cp_code fnd_lookup_values.lookup_code%TYPE) IS
161: SELECT meaning
162: FROM igs_lookup_values
163: WHERE lookup_code = cp_code
164: AND lookup_type = 'YES_NO';

Line 166: l_mode fnd_lookup_values.meaning%TYPE ;

162: FROM igs_lookup_values
163: WHERE lookup_code = cp_code
164: AND lookup_type = 'YES_NO';
165:
166: l_mode fnd_lookup_values.meaning%TYPE ;
167:
168: BEGIN
169:
170: OPEN cur_mode(p_code);

Line 191: p_c_test_flag IN fnd_lookup_values.lookup_code%TYPE

187: /* Removed the parameters p_n_sub_acc_1 and p_n_sub_acc_2, as a part of Bug # 2564643 */
188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,
189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,
190: p_c_fee_type_3 IN igs_fi_inv_int.fee_type%TYPE ,
191: p_c_test_flag IN fnd_lookup_values.lookup_code%TYPE
192: ) AS
193: ------------------------------------------------------------------
194: --Created by : Jabeen Begum, Oracle IDC
195: --Date created: 5/12/2001