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 2818: l_assignment_status per_assignment_status_types.per_system_status%TYPE; --Added for Bug#14670348

2814: l_effective_date DATE;
2815: l_message_text VARCHAR2(255);
2816: l_log_message VARCHAR2(255);
2817: l_already_errored BOOLEAN := FALSE;
2818: l_assignment_status per_assignment_status_types.per_system_status%TYPE; --Added for Bug#14670348
2819: --
2820: -- OUT Parameters for update_cwk_asg
2821: --
2822: l_object_version_number NUMBER := p_object_version_number;

Line 3442: l_assignment_status per_assignment_status_types.per_system_status%TYPE;

3438: l_already_errored BOOLEAN := FALSE;
3439: l_pay_proposal_warning BOOLEAN := FALSE;
3440: l_proc VARCHAR2(72) := g_package||'update_assignment';
3441: l_effective_date DATE;
3442: l_assignment_status per_assignment_status_types.per_system_status%TYPE;
3443: --
3444: l_non_person_type_fields BOOLEAN := FALSE;
3445: l_message_text VARCHAR2(255);
3446: l_dummy_b BOOLEAN;