APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_LOOKUPS_VIEW

Line 167: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%type,

163: Change History
164: Who When What
165: ******************************************************************/
166:
167: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%type,
168: x_code igs_lookups_view.lookup_code%type )
169: IS
170: SELECT meaning
171: FROM igs_lookup_values

Line 168: x_code igs_lookups_view.lookup_code%type )

164: Who When What
165: ******************************************************************/
166:
167: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%type,
168: x_code igs_lookups_view.lookup_code%type )
169: IS
170: SELECT meaning
171: FROM igs_lookup_values
172: WHERE lookup_code = x_code

Line 275: l_dr_account igs_lookups_view.meaning%TYPE;

271:
272: l_v_txn_num VARCHAR2(240);
273: l_v_comments ra_interface_lines_all.comments%TYPE;
274:
275: l_dr_account igs_lookups_view.meaning%TYPE;
276: l_cr_account igs_lookups_view.meaning%TYPE;
277: BEGIN
278:
279: -- Log the Source Transaction Type in one single line

Line 276: l_cr_account igs_lookups_view.meaning%TYPE;

272: l_v_txn_num VARCHAR2(240);
273: l_v_comments ra_interface_lines_all.comments%TYPE;
274:
275: l_dr_account igs_lookups_view.meaning%TYPE;
276: l_cr_account igs_lookups_view.meaning%TYPE;
277: BEGIN
278:
279: -- Log the Source Transaction Type in one single line
280: fnd_file.put_line(fnd_file.log,' '||lookup_desc('IGS_FI_LOCKBOX','SOURCE_TRAN_TYPE')||' : '||

Line 1089: FUNCTION get_log_line(p_lookup_code igs_lookups_view.lookup_code%TYPE,

1085: -- Since the comments column in the table ra_interface_lines is only 240 - We need to substring it to 240.
1086: p_comments := substr(l_v_comments,1,240);
1087: END derive_comments;
1088:
1089: FUNCTION get_log_line(p_lookup_code igs_lookups_view.lookup_code%TYPE,
1090: p_value VARCHAR2) RETURN VARCHAR2 AS
1091: /******************************************************************
1092: Created By : agairola
1093: Date Created By : 04-May-2002