DBA Data[Home] [Help]

APPS.PAY_FR_BAL_UPLOAD dependencies on PAY_MESSAGE_LINES

Line 161: type t_messages is table of pay_message_lines.line_text%TYPE

157: type t_message_line is record (
158: batch_line_id pay_balance_batch_lines.batch_line_id%TYPE,
159: message_number binary_integer);
160: type t_message_lines is table of t_message_line index by binary_integer;
161: type t_messages is table of pay_message_lines.line_text%TYPE
162: index by binary_integer;
163: tbl_messages t_messages;
164: tbl_msg_lines t_message_lines;
165: --

Line 199: insert into pay_message_lines

195: --
196: procedure write_message_lines is
197: begin
198: for i in 1..l_next_msg_line-1 loop
199: insert into pay_message_lines
200: (line_sequence
201: ,message_level
202: ,source_id
203: ,source_type

Line 206: (pay_message_lines_s.nextval

202: ,source_id
203: ,source_type
204: ,line_text)
205: values
206: (pay_message_lines_s.nextval
207: ,'F' -- 'F'atal
208: ,tbl_msg_lines(i).batch_line_id
209: ,'L'
210: ,tbl_messages(tbl_msg_lines(i).message_number));