[Home] [Help]
PACKAGE: APPS.PER_LETTER_REQUEST_LINES_PKG
Source
1 PACKAGE PER_LETTER_REQUEST_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: peltl01t.pkh 115.3 2003/02/21 07:11:09 vramanai ship $ */
3 --
4 PROCEDURE check_request_line_unique(X_letter_request_line_id in number,
5 X_assignment_id in number,
6 X_letter_request_id in number,
7 X_business_group_id in number,
8 X_OTA_EVENT_ID number,
9 X_OTA_BOOKING_ID number,
10 X_OTA_BOOKING_STATUS_TYPE_ID number);
11 --
12 PROCEDURE get_ota_details
13 (p_letter_request_line_id in number
14 ,p_event_title in out NOCOPY varchar2
15 ,p_delegate_full_name in out NOCOPY varchar2
16 ,p_course_start_date in out NOCOPY date
17 ,p_ota_booking_id in number
18 ,p_ota_event_id in number);
19 --
20 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
21 X_Letter_Request_Line_Id IN OUT NOCOPY NUMBER,
22 X_Business_Group_Id NUMBER,
23 X_Letter_Request_Id NUMBER,
24 X_Person_Id NUMBER,
25 X_Assignment_Id NUMBER,
26 X_Assignment_Status_Type_Id NUMBER,
27 X_Date_From DATE,
28 X_OTA_BOOKING_STATUS_TYPE_ID number,
29 X_OTA_BOOKING_ID number,
30 X_OTA_EVENT_ID number,
31 X_CONTRACT_ID IN NUMBER DEFAULT NULL
32 );
33 --
34 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
35 X_Letter_Request_Line_Id NUMBER,
36 X_Business_Group_Id NUMBER,
37 X_Letter_Request_Id NUMBER,
38 X_Person_Id NUMBER,
39 X_Assignment_Id NUMBER,
40 X_Assignment_Status_Type_Id NUMBER,
41 X_Date_From DATE,
42 X_OTA_BOOKING_STATUS_TYPE_ID number,
43 X_OTA_BOOKING_ID number,
44 X_OTA_EVENT_ID number
45 );
46 --
47 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
48 --
49 END PER_LETTER_REQUEST_LINES_PKG;