1 PACKAGE PV_PRGM_PMT_MODE_PKG AS
2 /* $Header: pvxtppms.pls 120.0 2005/05/27 16:00:02 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PRGM_PMT_MODE_PKG
7 -- Purpose
8 --
9 -- History
10 -- 26-APR-2002 Peter.Nixon Created
11 -- 30-APR-2002 Peter.Nixon Modified
12 -- NOTE
13 --
14 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
15 -- All rights reserved.
16 --
17 -- End of Comments
18 -- ===============================================================
19
20
21 PROCEDURE Insert_Row(
22 px_program_payment_mode_id IN OUT NOCOPY NUMBER
23 ,p_program_id NUMBER
24 ,p_geo_hierarchy_id NUMBER
25 ,p_mode_of_payment VARCHAR2
26 ,p_last_update_date DATE
27 ,p_last_updated_by NUMBER
28 ,p_creation_date DATE
29 ,p_created_by NUMBER
30 ,p_last_update_login NUMBER
31 ,p_object_version_number NUMBER
32 ,p_mode_type VARCHAR2
33 );
34
35 PROCEDURE Update_Row(
36 p_program_payment_mode_id NUMBER
37 ,p_program_id NUMBER
38 ,p_geo_hierarchy_id NUMBER
39 ,p_mode_of_payment VARCHAR2
40 ,p_last_update_date DATE
41 ,p_last_updated_by NUMBER
42 ,p_last_update_login NUMBER
43 ,p_object_version_number NUMBER
44 ,p_mode_type VARCHAR2
45 );
46
47 PROCEDURE Delete_Row(
48 p_program_payment_mode_id NUMBER
49 ,p_object_version_number NUMBER
50 );
51
52 PROCEDURE Lock_Row(
53 px_program_payment_mode_id IN OUT NOCOPY NUMBER
54 ,p_program_id NUMBER
55 ,p_geo_hierarchy_id NUMBER
56 ,p_mode_of_payment VARCHAR2
57 ,p_last_update_date DATE
58 ,p_last_updated_by NUMBER
59 ,p_creation_date DATE
60 ,p_created_by NUMBER
61 ,p_last_update_login NUMBER
62 ,px_object_version_number IN OUT NOCOPY NUMBER
63 ,p_mode_type VARCHAR2
64 );
65
66 END PV_PRGM_PMT_MODE_PKG;
[Home] [Help]