APPS.PQH_ASG_WRAPPER dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 62: FROM per_assignment_status_types p

58: (p_assignment_status_type_id IN NUMBER) RETURN VARCHAR2 IS
59: --
60: CURSOR get_status_type IS
61: SELECT p.per_system_status
62: FROM per_assignment_status_types p
63: WHERE p.assignment_status_type_id = p_assignment_status_type_id;
64: --
65: l_proc VARCHAR2(72) := g_package||'get_assignment_status_type';
66: l_assignment_status_type per_assignment_status_types.per_system_status%TYPE;

Line 66: l_assignment_status_type per_assignment_status_types.per_system_status%TYPE;

62: FROM per_assignment_status_types p
63: WHERE p.assignment_status_type_id = p_assignment_status_type_id;
64: --
65: l_proc VARCHAR2(72) := g_package||'get_assignment_status_type';
66: l_assignment_status_type per_assignment_status_types.per_system_status%TYPE;
67:
68: BEGIN
69: --
70: hr_utility.set_location('Entering : '||l_proc, 10);

Line 1607: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

1603: l_entries_changed_warning VARCHAR2(10);
1604: l_pay_proposal_warning BOOLEAN := FALSE;
1605: l_proc VARCHAR2(72) := g_package||'upd_asg';
1606: l_effective_date DATE;
1607: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
1608: --
1609: l_message_text VARCHAR2(255);
1610: --
1611: l_OBJECT_VERSION_NUMBER NUMBER := p_OBJECT_VERSION_NUMBER ;

Line 2343: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

2339: v_log_message varchar2(255);
2340: v_already_errored boolean := FALSE;
2341: --
2342: l_effective_date DATE;
2343: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
2344: --
2345: l_message_text VARCHAR2(255);
2346: --
2347: BEGIN

Line 3384: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

3380: l_already_errored BOOLEAN := FALSE;
3381: l_pay_proposal_warning BOOLEAN := FALSE;
3382: l_proc VARCHAR2(72) := g_package||'update_assignment';
3383: l_effective_date DATE;
3384: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
3385: --
3386: l_non_person_type_fields BOOLEAN := FALSE;
3387: l_message_text VARCHAR2(255);
3388: l_dummy_b BOOLEAN;