DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on FND_NEW_MESSAGES

Line 90: l_error_message_code fnd_new_messages.message_name%TYPE;

86: l_resource_type_id NUMBER;
87: l_action_code VARCHAR2(7);
88: l_overcommitment_flag VARCHAR2(1);
89: l_conflict_group_id NUMBER;
90: l_error_message_code fnd_new_messages.message_name%TYPE;
91: l_approval_required_flag VARCHAR2(1);
92: l_check_id_flag VARCHAR2(1);
93: l_status_flag VARCHAR2(1);
94: l_submitter_user_id NUMBER;

Line 1625: l_error_message_code fnd_new_messages.message_name%TYPE;

1621: l_new_assignment_id NUMBER;
1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;
1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;
1625: l_error_message_code fnd_new_messages.message_name%TYPE;
1626: l_resource_id pa_project_assignments.resource_id%TYPE;
1627: l_conflict_group_id NUMBER;
1628: l_overcommitment_flag VARCHAR2(1);
1629: l_action_set_id NUMBER;

Line 2272: l_error_message_code fnd_new_messages.message_name%TYPE;

2268: l_msg_index_out NUMBER;
2269: l_start_date DATE;
2270: l_end_date DATE;
2271: l_return_status VARCHAR2(1);
2272: l_error_message_code fnd_new_messages.message_name%TYPE;
2273: l_project_id NUMBER;
2274: l_person_id NUMBER;
2275:
2276: CURSOR get_start_end_date IS

Line 2553: l_error_message_code fnd_new_messages.message_name%TYPE;

2549: l_project_role_id NUMBER ;
2550: l_project_role_name VARCHAR2(80);
2551: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
2552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2553: l_error_message_code fnd_new_messages.message_name%TYPE;
2554: l_assignment_start_date DATE;
2555: l_approver1_person_id NUMBER;
2556: l_approver1_person_name VARCHAR2(200);
2557: l_approver2_person_id NUMBER;

Line 2839: l_error_message_code fnd_new_messages.message_name%TYPE;

2835: )
2836: IS
2837:
2838: l_return_status VARCHAR2(1);
2839: l_error_message_code fnd_new_messages.message_name%TYPE;
2840: x_error_message_code fnd_new_messages.message_name%TYPE;
2841: l_msg_index_out NUMBER;
2842: l_msg_count NUMBER;
2843: l_msg_data VARCHAR2(2000);

Line 2840: x_error_message_code fnd_new_messages.message_name%TYPE;

2836: IS
2837:
2838: l_return_status VARCHAR2(1);
2839: l_error_message_code fnd_new_messages.message_name%TYPE;
2840: x_error_message_code fnd_new_messages.message_name%TYPE;
2841: l_msg_index_out NUMBER;
2842: l_msg_count NUMBER;
2843: l_msg_data VARCHAR2(2000);
2844: l_data VARCHAR2(2000);

Line 4131: l_error_message_code fnd_new_messages.message_name%TYPE;

4127: )
4128: IS
4129:
4130: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4131: l_error_message_code fnd_new_messages.message_name%TYPE;
4132: l_assignment_start_date DATE;
4133: l_approver1_person_id NUMBER;
4134: l_approver1_person_name VARCHAR2(200);
4135: l_approver2_person_id NUMBER;