DBA Data[Home] [Help]

APPS.PA_SCHEDULE_UTILS dependencies on PA_PROJECT_STATUSES

Line 957: -- or 'STAFFED_ASGMT'. Please see pa_project_statuses.status_type

953: -- status for the entire duration of the requirement/assignment.
954: -- Otherwise returns 'N'.
955: -- p_assignment_id - assignment/requirement id
956: -- p_status_type - The value is either 'OPEN_ASGMT'
957: -- or 'STAFFED_ASGMT'. Please see pa_project_statuses.status_type
958: -- for list of current values.
959: -- p_in_system_status_code - Desired system status code.
960:
961: FUNCTION check_input_system_status

Line 963: p_status_type IN pa_project_statuses.status_type%TYPE,

959: -- p_in_system_status_code - Desired system status code.
960:
961: FUNCTION check_input_system_status
962: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
963: p_status_type IN pa_project_statuses.status_type%TYPE,
964: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
965: return VARCHAR2 IS
966:
967: l_flag VARCHAR2(1) := 'Y';

Line 964: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)

960:
961: FUNCTION check_input_system_status
962: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
963: p_status_type IN pa_project_statuses.status_type%TYPE,
964: p_in_system_status_code IN pa_project_statuses.project_system_status_code%TYPE)
965: return VARCHAR2 IS
966:
967: l_flag VARCHAR2(1) := 'Y';
968: CURSOR l_sch_csr IS