1 PACKAGE OKL_CSH_ORDER_SEQ_Pvt AS
2 /* $Header: OKLRSATS.pls 120.2 2006/07/11 09:58:54 dkagrawa noship $ */
3
4
5 SUBTYPE stav_rec_type IS okl_strm_typ_allocs_pub.stav_rec_type;
6 SUBTYPE stav_tbl_type IS okl_strm_typ_allocs_pub.stav_tbl_type;
7
8 ---------------------------------------------------------------------------
9 -- GLOBAL DATASTRUCTURES
10 ---------------------------------------------------------------------------
11
12 TYPE okl_csh_order_rec_type IS RECORD (
13 name OKL_STRM_TYPE_V.NAME%TYPE,
14 sty_id OKL_BPD_CSH_ORDER_UV.STY_ID%TYPE,
15 cat_id OKL_BPD_CSH_ORDER_UV.CAT_ID%TYPE,
16 id NUMBER,
17 object_version_number NUMBER := 1.0,
18 sequence_number NUMBER,
19 stream_allc_type OKL_STRM_TYP_ALLOCS.STREAM_ALLC_TYPE%TYPE,
20 created_by NUMBER := 0,
21 creation_date OKL_STRM_TYP_ALLOCS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
22 last_updated_by NUMBER := 0,
23 last_update_date OKL_STRM_TYP_ALLOCS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
24 last_update_login NUMBER := 1);
25
26 g_miss_okl_csh_order_rec okl_csh_order_rec_type;
27 TYPE okl_csh_order_tbl_type IS TABLE OF okl_csh_order_rec_type
28 INDEX BY BINARY_INTEGER;
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL VARIABLES
32 ---------------------------------------------------------------------------
33
34 ---------------------------------------------------------------------------
35 -- Procedures and Functions
36 ---------------------------------------------------------------------------
37
38 PROCEDURE insert_row (p_api_version IN NUMBER
39 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 ,p_okl_csh_order_rec IN okl_csh_order_rec_type
44 ,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type
45 );
46
47 PROCEDURE insert_row (p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type
53 ,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type
54 );
55
56 PROCEDURE update_row (p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_okl_csh_order_rec IN okl_csh_order_rec_type
62 ,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type
63 );
64
65 PROCEDURE update_row (p_api_version IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type
71 ,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type
72 );
73
74 PROCEDURE delete_row (p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,p_okl_csh_order_rec IN okl_csh_order_rec_type
80 );
81
82 PROCEDURE delete_row (p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ,p_okl_csh_order_tbl IN okl_csh_order_tbl_type
88 );
89
90 END OKL_CSH_ORDER_SEQ_Pvt;