DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PA_TASKS

Line 4998: pa_tasks pt,

4994: pesl.gms_batch_name --6146805
4995: FROM psp_enc_summary_lines pesl,
4996: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
4997: pa_projects_all ppa,
4998: pa_tasks pt,
4999: per_time_periods ptp,
5000: per_all_people_f papf,
5001: psp_enc_controls pec
5002: WHERE pesl.payroll_action_id = p_payroll_action_id

Line 5347: fnd_message.set_token('TABLE', 'PA_TASKS');

5343:
5344: IF r_interface.task_number(recno) IS NULL THEN
5345: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5346: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5347: fnd_message.set_token('TABLE', 'PA_TASKS');
5348: fnd_msg_pub.add;
5349: l_raise_error := TRUE;
5350: END IF;
5351: END LOOP;

Line 5565: FROM pa_tasks

5561:
5562: BEGIN
5563: SELECT task_number
5564: INTO l_task_number
5565: FROM pa_tasks
5566: WHERE task_id = int_rec.task_id;
5567: EXCEPTION
5568: WHEN NO_DATA_FOUND THEN
5569: l_value := 'Task id ='||to_char(int_rec.task_id);

Line 5570: l_table := 'PA_TASKS';

5566: WHERE task_id = int_rec.task_id;
5567: EXCEPTION
5568: WHEN NO_DATA_FOUND THEN
5569: l_value := 'Task id ='||to_char(int_rec.task_id);
5570: l_table := 'PA_TASKS';
5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;