DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_PVT dependencies on FND_NEW_MESSAGES

Line 212: l_msg_data fnd_new_messages.message_text%TYPE;

208: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
209: l_return_status VARCHAR2(1);
210: l_msg_count NUMBER;
211: l_count NUMBER;
212: l_msg_data fnd_new_messages.message_text%TYPE;
213: l_msg_index_out NUMBER;
214: l_err_code NUMBER;
215: l_err_stage VARCHAR2(2000);
216: l_err_stack VARCHAR2(2000);

Line 370: l_error_message_code fnd_new_messages.message_name%TYPE;

366: l_assignment_number pa_project_assignments.assignment_number%TYPE;
367: l_assignment_row_id ROWID;
368: l_resource_id pa_resources.resource_id%TYPE;
369: l_return_status VARCHAR2(1);
370: l_error_message_code fnd_new_messages.message_name%TYPE;
371: l_msg_count NUMBER;
372: l_msg_data fnd_new_messages.message_text%TYPE;
373: l_index NUMBER;
374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;

Line 372: l_msg_data fnd_new_messages.message_text%TYPE;

368: l_resource_id pa_resources.resource_id%TYPE;
369: l_return_status VARCHAR2(1);
370: l_error_message_code fnd_new_messages.message_name%TYPE;
371: l_msg_count NUMBER;
372: l_msg_data fnd_new_messages.message_text%TYPE;
373: l_index NUMBER;
374: l_project_calendar_id pa_projects_all.calendar_id%TYPE;
375: l_project_location_id pa_projects_all.location_id%TYPE;
376: l_number_of_days NUMBER;

Line 931: l_msg_data fnd_new_messages.message_text%TYPE;

927: IS
928:
929: l_return_status VARCHAR2(1);
930: l_msg_count NUMBER;
931: l_msg_data fnd_new_messages.message_text%TYPE;
932: l_check_team_template_in_use VARCHAR2(1);
933:
934: CURSOR check_team_template_in_use IS
935: SELECT 'X'