APPS.PAY_GB_MOVDED_EDI dependencies on PAY_MESSAGE_LINES

Line 1539: INSERT INTO pay_message_lines(line_sequence,

1535: PRAGMA AUTONOMOUS_TRANSACTION;
1536: BEGIN
1537: hr_utility.set_location(' Entering: populate_run_msg',111);
1538:
1539: INSERT INTO pay_message_lines(line_sequence,
1540: payroll_id,
1541: message_level,
1542: source_id,
1543: source_type,

Line 1546: pay_message_lines_s.nextval

1542: source_id,
1543: source_type,
1544: line_text)
1545: VALUES(
1546: pay_message_lines_s.nextval
1547: ,null
1548: ,'F'
1549: ,p45_assignment_action_id
1550: ,'A'

Line 3069: From pay_message_lines pml

3065:
3066: Cursor messages (p_asg_act_id in number)
3067: Is
3068: Select pml.line_text error_text
3069: From pay_message_lines pml
3070: Where pml.source_id = p_asg_act_id
3071: and pml.MESSAGE_LEVEL = 'F'
3072: and pml.line_sequence < (select line_sequence
3073: from pay_message_lines pml1

Line 3073: from pay_message_lines pml1

3069: From pay_message_lines pml
3070: Where pml.source_id = p_asg_act_id
3071: and pml.MESSAGE_LEVEL = 'F'
3072: and pml.line_sequence < (select line_sequence
3073: from pay_message_lines pml1
3074: where pml1.source_id = p_asg_act_id
3075: and pml1.line_text like 'Error ORA-20001: Error(s) found while archiving data.')
3076: UNION ALL
3077: Select pml.line_text error_text

Line 3078: From pay_message_lines pml

3074: where pml1.source_id = p_asg_act_id
3075: and pml1.line_text like 'Error ORA-20001: Error(s) found while archiving data.')
3076: UNION ALL
3077: Select pml.line_text error_text
3078: From pay_message_lines pml
3079: Where pml.source_id = p_asg_act_id
3080: and pml.message_level = 'W';
3081:
3082: l_param csr_leg_param%rowtype;