[Home] [Help]
PACKAGE: APPS.PV_PRGM_BENEFITS_PKG
Source
1 PACKAGE PV_PRGM_BENEFITS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pvxtppbs.pls 115.8 2003/11/07 06:13:55 ktsao ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_BENEFITS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 28-FEB-2002 Jessica.Lee Created
11 -- 1-APR-2002 Peter.Nixon Modified
12 -- Changed benefit_id NUMBER to benefit_code VARCHAR2
13 -- 24-SEP-2003 Karen.Tsao Modified for 11.5.10
14 -- 02-OCT-2003 Karen.Tsao Modified for new column responsibility_id
15 -- 06-NOV-2003 Karen.Tsao Took out column responsibility_id
16 -- NOTE
17 --
18 -- End of Comments
19 -- ===============================================================
20
21
22 PROCEDURE Insert_Row(
23 px_program_benefits_id IN OUT NOCOPY NUMBER
24 ,p_program_id NUMBER
25 ,p_benefit_code VARCHAR2
26 ,p_benefit_id NUMBER
27 ,p_benefit_type_code VARCHAR2
28 ,p_delete_flag VARCHAR2
29 ,p_last_update_login NUMBER
30 ,p_last_update_date DATE
31 ,p_last_updated_by NUMBER
32 ,p_created_by NUMBER
33 ,p_creation_date DATE
34 ,p_object_version_number NUMBER
35 );
36
37 PROCEDURE Update_Row(
38 p_program_benefits_id NUMBER
39 ,p_program_id NUMBER
40 ,p_benefit_code VARCHAR2
41 ,p_benefit_id NUMBER
42 ,p_benefit_type_code VARCHAR2
43 ,p_delete_flag VARCHAR2
44 ,p_last_update_login NUMBER
45 ,p_object_version_number NUMBER
46 ,p_last_update_date DATE
47 ,p_last_updated_by NUMBER
48 );
49
50 PROCEDURE Delete_Row(
51 p_program_benefits_id NUMBER
52 ,p_object_version_number NUMBER
53 );
54
55 PROCEDURE Lock_Row(
56 px_program_benefits_id IN OUT NOCOPY NUMBER
57 ,p_program_id NUMBER
58 ,p_benefit_code VARCHAR2
59 ,p_benefit_id NUMBER
60 ,p_benefit_type_code VARCHAR2
61 ,p_delete_flag VARCHAR2
62 ,p_last_update_login NUMBER
63 ,px_object_version_number IN OUT NOCOPY NUMBER
64 ,p_last_update_date DATE
65 ,p_last_updated_by NUMBER
66 ,p_created_by NUMBER
67 ,p_creation_date DATE
68 );
69
70 END PV_PRGM_BENEFITS_PKG;