1 PACKAGE hr_interview AUTHID CURRENT_USER AS
2 /* $Header: peintviw.pkh 115.1 2003/12/23 21:20:10 bsubrama ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ****************************************************************** */
21 /*
22 Name : hr_interview (HEADER)
23
24 Description : This package declares procedures required to
25 INSERT, UPDATE and DELETE Assignment Statuses for
26 Applicant Interviews called from PERREAB.
27
28 Change List
29 -----------
30
31 Version Date Author ER/CR No. Description of Change
32 -------+---------+----------+---------+-----------------------
33 70.0 09-FEB-93 PShergill Date Created
34 70.1 11-MAR-93 NKhan Added 'exit' to end
35 70.2 05-APR-93 A.McGhee Corrected incorrect END identifier
36 name.
37 115.1 24-Dec-03 bsubrama 3333891 Added dbdrv and commit
38 ================================================================= */
39
40 --
41 --
42 ------------------- insert_interview -----------------------------
43 /*
44 NAME
45 insert_interview
46
47 DESCRIPTION
48 Inserts an assignment of type specified in the paramenter list
49 starting from applicant interview start date
50 PARAMETERS
51 p_assignment_id - assignment_id of applicant
52 p_idate - New Interview Date
53 p_assignment_status_type_id - Assignment Status Type Id of Interview
54 p_last_updated_by - Required for Auditing
55 p_last_update_login - Required for Auditing
56 */
57 PROCEDURE insert_interview
58 (
59 p_assignment_id IN INTEGER,
60 p_idate IN DATE,
61 p_assignment_status_type_id IN INTEGER,
62 p_last_updated_by IN INTEGER,
63 p_last_update_login IN INTEGER
64 );
65 --
66 --
67 ------------------- delete_interview -----------------------------
68 /*
69 NAME
70 delete_interview
71 DESCRIPTION
72 Deletes assignment for associated applicant interview
73 PARAMETERS
74 p_assignment_id - assignment_id of applicant
75 p_idate - New Interview Date
76 p_last_updated_by - Required for Auditing
77 p_last_update_login - Required for Auditing
78 */
79 PROCEDURE delete_interview
80 (p_assignment_id IN INTEGER,
81 p_idate IN DATE,
82 p_last_updated_by IN INTEGER,
83 p_last_update_login IN INTEGER
84 );
85 --
86 --
87 ------------------- update_interview -------------------------------
88 /*
89 NAME
90 update_interview
91 DESCRIPTION
92 Update assignment for associated applicant interview
93 PARAMETERS
94 p_assignment_id - assignment_id of applicant
95 p_idate - New Interview Date
96 p_odate - Old Interview Date
97 p_last_updated_by - Required for Auditing
98 p_last_update_login - Required for Auditing
99 */
100 PROCEDURE update_interview
101 (p_assignment_id IN INTEGER,
102 p_idate IN DATE,
103 p_odate IN DATE,
104 p_last_updated_by IN INTEGER,
105 p_last_update_login IN INTEGER
106 );
107 --
108 --
109 end hr_interview;