APPS.PAY_GB_RTI_EAS dependencies on PAY_MESSAGE_LINES

Line 1109: INSERT INTO pay_message_lines(line_sequence,

1105: BEGIN
1106: /* EAS 2013 Changes */
1107: if (instr(p_message_text,'is aggregated & therefore not included on the EDI file') = 0) then
1108:
1109: INSERT INTO pay_message_lines(line_sequence,
1110: payroll_id,
1111: message_level,
1112: source_id,
1113: source_type,

Line 1116: pay_message_lines_s.nextval

1112: source_id,
1113: source_type,
1114: line_text)
1115: VALUES(
1116: pay_message_lines_s.nextval
1117: ,100
1118: ,'F'
1119: ,p_assignment_action_id
1120: ,'A'

Line 1124: INSERT INTO pay_message_lines(line_sequence,

1120: ,'A'
1121: ,substr(p_message_text,1,240)
1122: );
1123: else
1124: INSERT INTO pay_message_lines(line_sequence,
1125: payroll_id,
1126: message_level,
1127: source_id,
1128: source_type,

Line 1131: pay_message_lines_s.nextval

1127: source_id,
1128: source_type,
1129: line_text)
1130: VALUES(
1131: pay_message_lines_s.nextval
1132: ,200
1133: ,'W'
1134: ,p_assignment_action_id
1135: ,'A'

Line 3749: -- Cursor to fetch error Messages from pay_message lines table

3745: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
3746: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
3747: and l_nino_eff_date between pap.EFFECTIVE_START_DATE and pap.EFFECTIVE_END_DATE
3748: order by end_date desc;
3749: -- Cursor to fetch error Messages from pay_message lines table
3750: cursor csr_err_msg(asg_action_id number) is
3751: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
3752: /* EAS 2013 changes */
3753: -- Cursor to fetch warning Messages from pay_message lines table

Line 3751: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;

3747: and l_nino_eff_date between pap.EFFECTIVE_START_DATE and pap.EFFECTIVE_END_DATE
3748: order by end_date desc;
3749: -- Cursor to fetch error Messages from pay_message lines table
3750: cursor csr_err_msg(asg_action_id number) is
3751: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
3752: /* EAS 2013 changes */
3753: -- Cursor to fetch warning Messages from pay_message lines table
3754: cursor csr_war_msg(asg_action_id number) is
3755: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 200;

Line 3753: -- Cursor to fetch warning Messages from pay_message lines table

3749: -- Cursor to fetch error Messages from pay_message lines table
3750: cursor csr_err_msg(asg_action_id number) is
3751: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
3752: /* EAS 2013 changes */
3753: -- Cursor to fetch warning Messages from pay_message lines table
3754: cursor csr_war_msg(asg_action_id number) is
3755: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 200;
3756:
3757: err_msg csr_err_msg%rowtype;

Line 3755: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 200;

3751: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
3752: /* EAS 2013 changes */
3753: -- Cursor to fetch warning Messages from pay_message lines table
3754: cursor csr_war_msg(asg_action_id number) is
3755: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 200;
3756:
3757: err_msg csr_err_msg%rowtype;
3758: war_msg csr_war_msg%rowtype;
3759: