DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PA_TASKS

Line 3773: FROM pa_tasks

3769: -- get the task number
3770: BEGIN
3771: SELECT task_number
3772: INTO l_task_number
3773: FROM pa_tasks
3774: WHERE task_id = gms_interface_rec.task_id;
3775: EXCEPTION
3776: WHEN NO_DATA_FOUND THEN
3777: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);

Line 3778: l_table := 'PA_TASKS';

3774: WHERE task_id = gms_interface_rec.task_id;
3775: EXCEPTION
3776: WHEN NO_DATA_FOUND THEN
3777: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3778: l_table := 'PA_TASKS';
3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;