1 PACKAGE PV_PRGM_CONTRACTS_PKG AS
2 /* $Header: pvxtppcs.pls 120.0 2005/05/27 16:24:34 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_CONTRACTS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 7-MAR-2002 Peter.Nixon Created
11 -- 30-APR-2002 Peter.Nixon Modified
12 -- 27-NOV-2002 Karen.Tsao Replace of COPY with NOCOPY string.
13 -- 28-AUG-2003 Karen.Tsao Change membership_type to member_type_code.
14 -- NOTE
15 --
16 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
17 -- All rights reserved.
18 --
19 -- End of Comments
20 -- ===============================================================
21
22
23 PROCEDURE Insert_Row(
24 px_program_contracts_id IN OUT NOCOPY NUMBER
25 ,p_program_id NUMBER
26 ,p_geo_hierarchy_id NUMBER
27 ,p_contract_id NUMBER
28 ,p_last_update_date DATE
29 ,p_last_updated_by NUMBER
30 ,p_creation_date DATE
31 ,p_created_by NUMBER
32 ,p_last_update_login NUMBER
33 ,p_object_version_number NUMBER
34 ,p_member_type_code VARCHAR2
35 );
36
37 PROCEDURE Update_Row(
38 p_program_contracts_id NUMBER
39 ,p_program_id NUMBER
40 ,p_geo_hierarchy_id NUMBER
41 ,p_contract_id NUMBER
42 ,p_last_update_date DATE
43 ,p_last_updated_by NUMBER
44 ,p_last_update_login NUMBER
45 ,p_object_version_number NUMBER
46 ,p_member_type_code VARCHAR2
47 );
48
49 PROCEDURE Delete_Row(
50 p_program_contracts_id NUMBER
51 ,p_object_version_number NUMBER
52 );
53
54 PROCEDURE Lock_Row(
55 px_program_contracts_id IN OUT NOCOPY NUMBER
56 ,p_program_id NUMBER
57 ,p_geo_hierarchy_id NUMBER
58 ,p_contract_id NUMBER
59 ,p_last_update_date DATE
60 ,p_last_updated_by NUMBER
61 ,p_creation_date DATE
62 ,p_created_by NUMBER
63 ,p_last_update_login NUMBER
64 ,p_member_type_code VARCHAR2
65 ,px_object_version_number IN OUT NOCOPY NUMBER
66 );
67
68 END PV_PRGM_CONTRACTS_PKG;