[Home] [Help]
PACKAGE: APPS.PER_LETTER_REQUESTS_PKG
Source
1 PACKAGE PER_LETTER_REQUESTS_PKG AUTHID CURRENT_USER as
2 /* $Header: peltr01t.pkh 115.1 2003/01/15 09:59:44 pkakar ship $ */
3 --
4 PROCEDURE check_request_unique(X_letter_request_id in number,
5 X_business_group_id in number,
6 X_vacancy_id in number,
7 X_event_id in number,
8 X_letter_type_id in number,
9 X_date_from in date,
10 X_request_status in varchar2);
11 --
12 PROCEDURE check_request_lines(X_letter_request_id in NUMBER);
13 --
14 PROCEDURE confirm_delete_lines(X_letter_request_id in NUMBER,
15 X_business_group_id in NUMBER,
16 X_request_lines_exist in out nocopy BOOLEAN);
17 --
18 PROCEDURE Insert_Row(X_Rowid IN OUT nocopy VARCHAR2,
19 X_Letter_Request_Id IN OUT nocopy NUMBER,
20 X_Business_Group_Id NUMBER,
21 X_Letter_Type_Id NUMBER,
22 X_Date_From DATE,
23 X_Request_Status VARCHAR2,
24 X_Auto_Or_Manual VARCHAR2,
25 x_vacancy_id NUMBER,
26 x_event_id NUMBER
27 );
28 --
29 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
30 X_Letter_Request_Id NUMBER,
31 X_Business_Group_Id NUMBER,
32 X_Letter_Type_Id NUMBER,
33 X_Date_From DATE,
34 X_Request_Status VARCHAR2,
35 X_Auto_Or_Manual VARCHAR2,
36 x_vacancy_id NUMBER,
37 x_event_id NUMBER
38 );
39 --
40 PROCEDURE Update_Row(X_Rowid VARCHAR2,
41 X_Letter_Request_Id NUMBER,
42 X_Business_Group_Id NUMBER,
43 X_Letter_Type_Id NUMBER,
44 X_Date_From DATE,
45 X_Request_Status VARCHAR2,
46 X_Auto_Or_Manual VARCHAR2,
47 x_vacancy_id NUMBER,
48 x_event_id NUMBER
49 );
50 --
51 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
52 X_Letter_Request_Id NUMBER);
53 --
54 PROCEDURE concurrent_program_call(p_application varchar2,
55 p_program varchar2,
56 p_argument1 varchar2,
57 p_argument2 varchar2,
58 p_request_id in out nocopy number);
59 END PER_LETTER_REQUESTS_PKG;