DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CASH_FLOW_OBJECTS_PUB

Source


1 PACKAGE OKL_CASH_FLOW_OBJECTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCFOS.pls 115.0 2003/10/16 01:54:02 sechawla noship $ */
3 
4 
5 
6  SUBTYPE cfov_rec_type IS okl_cfo_pvt.cfov_rec_type;
7  SUBTYPE cfov_tbl_type IS okl_cfo_pvt.cfov_tbl_type;
8  ------------------------------------------------------------------------------
9  -- Global Variables
10  G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_CASH_FLOW_OBJECTS_PUB';
11  G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
12  G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13  G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
14  G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
15  ------------------------------------------------------------------------------
16   --Global Exception
17  ------------------------------------------------------------------------------
18   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
19  ------------------------------------------------------------------------------
20 
21 
22    PROCEDURE insert_cash_flow_object(
23     p_api_version                  IN  NUMBER,
24     p_init_msg_list                IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
25     x_return_status                OUT NOCOPY VARCHAR2,
26     x_msg_count                    OUT NOCOPY NUMBER,
27     x_msg_data                     OUT NOCOPY VARCHAR2,
28     p_cfov_rec                     IN  cfov_rec_type,
29     x_cfov_rec                     OUT NOCOPY cfov_rec_type) ;
30 
31 
32   PROCEDURE insert_cash_flow_object(
33     p_api_version                  IN NUMBER,
34     p_init_msg_list                IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35     x_return_status                OUT NOCOPY VARCHAR2,
36     x_msg_count                    OUT NOCOPY NUMBER,
37     x_msg_data                     OUT NOCOPY VARCHAR2,
38     p_cfov_tbl                     IN cfov_tbl_type,
39     x_cfov_tbl                     OUT NOCOPY cfov_tbl_type);
40 
41   PROCEDURE lock_cash_flow_object(
42     p_api_version                  IN NUMBER,
43     p_init_msg_list                IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44     x_return_status                OUT NOCOPY VARCHAR2,
45     x_msg_count                    OUT NOCOPY NUMBER,
46     x_msg_data                     OUT NOCOPY VARCHAR2,
47     p_cfov_rec                     IN cfov_rec_type);
48 
49 
50   PROCEDURE lock_cash_flow_object(
51      p_api_version                  IN   NUMBER
52     ,p_init_msg_list                IN   VARCHAR2 DEFAULT FND_API.G_FALSE
53     ,x_return_status                OUT  NOCOPY VARCHAR2
54     ,x_msg_count                    OUT  NOCOPY NUMBER
55     ,x_msg_data                     OUT  NOCOPY VARCHAR2
56     ,p_cfov_tbl                     IN   cfov_tbl_type) ;
57 
58   PROCEDURE update_cash_flow_object(
59      p_api_version                  IN   NUMBER
60     ,p_init_msg_list                IN   VARCHAR2  DEFAULT FND_API.G_FALSE
61     ,x_return_status                OUT  NOCOPY VARCHAR2
62     ,x_msg_count                    OUT  NOCOPY NUMBER
63     ,x_msg_data                     OUT  NOCOPY VARCHAR2
64     ,p_cfov_rec                      IN   cfov_rec_type
65     ,x_cfov_rec                      OUT  NOCOPY cfov_rec_type);
66 
67 
68   PROCEDURE update_cash_flow_object(
69     p_api_version                  IN NUMBER,
70     p_init_msg_list                IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71     x_return_status                OUT NOCOPY VARCHAR2,
72     x_msg_count                    OUT NOCOPY NUMBER,
73     x_msg_data                     OUT NOCOPY VARCHAR2,
74     p_cfov_tbl                     IN  cfov_tbl_type,
75     x_cfov_tbl                     OUT NOCOPY cfov_tbl_type);
76 
77 
78 
79   PROCEDURE delete_cash_flow_object(
80     p_api_version                  IN  NUMBER,
81     p_init_msg_list                IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
82     x_return_status                OUT NOCOPY VARCHAR2,
83     x_msg_count                    OUT NOCOPY NUMBER,
84     x_msg_data                     OUT NOCOPY VARCHAR2,
85     p_cfov_rec                     IN  cfov_rec_type);
86 
87   PROCEDURE delete_cash_flow_object(
88     p_api_version                  IN  NUMBER,
89     p_init_msg_list                IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
90     x_return_status                OUT NOCOPY VARCHAR2,
91     x_msg_count                    OUT NOCOPY NUMBER,
92     x_msg_data                     OUT NOCOPY VARCHAR2,
93     p_cfov_tbl                     IN  cfov_tbl_type);
94 
95   PROCEDURE validate_cash_flow_object(
96     p_api_version                  IN NUMBER,
97     p_init_msg_list                IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98     x_return_status                OUT NOCOPY VARCHAR2,
99     x_msg_count                    OUT NOCOPY NUMBER,
100     x_msg_data                     OUT NOCOPY VARCHAR2,
101     p_cfov_rec                     IN cfov_rec_type);
102 
103 
104   PROCEDURE  validate_cash_flow_object(
105     p_api_version                  IN NUMBER,
106     p_init_msg_list                IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107     x_return_status                OUT NOCOPY VARCHAR2,
108     x_msg_count                    OUT NOCOPY NUMBER,
109     x_msg_data                     OUT NOCOPY VARCHAR2,
110     p_cfov_tbl                     IN cfov_tbl_type) ;
111 
112 END okl_cash_flow_objects_pub;