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 2216: l_error_message_code fnd_new_messages.message_name%TYPE;

2212: l_msg_index_out NUMBER;
2213: l_start_date DATE;
2214: l_end_date DATE;
2215: l_return_status VARCHAR2(1);
2216: l_error_message_code fnd_new_messages.message_name%TYPE;
2217: l_project_id NUMBER;
2218: l_person_id NUMBER;
2219:
2220: CURSOR get_start_end_date IS

Line 2492: l_error_message_code fnd_new_messages.message_name%TYPE;

2488: l_project_role_id NUMBER ;
2489: l_project_role_name VARCHAR2(80);
2490: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
2491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2492: l_error_message_code fnd_new_messages.message_name%TYPE;
2493: l_assignment_start_date DATE;
2494: l_approver1_person_id NUMBER;
2495: l_approver1_person_name VARCHAR2(200);
2496: l_approver2_person_id NUMBER;

Line 2778: l_error_message_code fnd_new_messages.message_name%TYPE;

2774: )
2775: IS
2776:
2777: l_return_status VARCHAR2(1);
2778: l_error_message_code fnd_new_messages.message_name%TYPE;
2779: x_error_message_code fnd_new_messages.message_name%TYPE;
2780: l_msg_index_out NUMBER;
2781: l_msg_count NUMBER;
2782: l_msg_data VARCHAR2(2000);

Line 2779: x_error_message_code fnd_new_messages.message_name%TYPE;

2775: IS
2776:
2777: l_return_status VARCHAR2(1);
2778: l_error_message_code fnd_new_messages.message_name%TYPE;
2779: x_error_message_code fnd_new_messages.message_name%TYPE;
2780: l_msg_index_out NUMBER;
2781: l_msg_count NUMBER;
2782: l_msg_data VARCHAR2(2000);
2783: l_data VARCHAR2(2000);

Line 4066: l_error_message_code fnd_new_messages.message_name%TYPE;

4062: )
4063: IS
4064:
4065: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4066: l_error_message_code fnd_new_messages.message_name%TYPE;
4067: l_assignment_start_date DATE;
4068: l_approver1_person_id NUMBER;
4069: l_approver1_person_name VARCHAR2(200);
4070: l_approver2_person_id NUMBER;