[Home] [Help]
PACKAGE: APPS.OKL_SETUPCGRPARAMETERS_PVT_W
Source
1 package okl_setupcgrparameters_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLESCMS.pls 120.1 2005/07/12 09:08:55 dkagrawa noship $ */
3 procedure get_rec(x_return_status out nocopy VARCHAR2
4 , x_no_data_found out nocopy number
5 , p3_a0 out nocopy NUMBER
6 , p3_a1 out nocopy NUMBER
7 , p3_a2 out nocopy NUMBER
8 , p3_a3 out nocopy NUMBER
9 , p3_a4 out nocopy NUMBER
10 , p3_a5 out nocopy DATE
11 , p3_a6 out nocopy NUMBER
12 , p3_a7 out nocopy DATE
13 , p3_a8 out nocopy NUMBER
14 , p0_a0 NUMBER := 0-1962.0724
15 , p0_a1 NUMBER := 0-1962.0724
16 , p0_a2 NUMBER := 0-1962.0724
17 , p0_a3 NUMBER := 0-1962.0724
18 , p0_a4 NUMBER := 0-1962.0724
19 , p0_a5 DATE := fnd_api.g_miss_date
20 , p0_a6 NUMBER := 0-1962.0724
21 , p0_a7 DATE := fnd_api.g_miss_date
22 , p0_a8 NUMBER := 0-1962.0724
23 );
24 procedure insert_cgrparameters(p_api_version NUMBER
25 , p_init_msg_list VARCHAR2
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , p6_a0 out nocopy NUMBER
30 , p6_a1 out nocopy NUMBER
31 , p6_a2 out nocopy NUMBER
32 , p6_a3 out nocopy NUMBER
33 , p6_a4 out nocopy NUMBER
34 , p6_a5 out nocopy DATE
35 , p6_a6 out nocopy NUMBER
36 , p6_a7 out nocopy DATE
37 , p6_a8 out nocopy NUMBER
38 , p5_a0 NUMBER := 0-1962.0724
39 , p5_a1 NUMBER := 0-1962.0724
40 , p5_a2 NUMBER := 0-1962.0724
41 , p5_a3 NUMBER := 0-1962.0724
42 , p5_a4 NUMBER := 0-1962.0724
43 , p5_a5 DATE := fnd_api.g_miss_date
44 , p5_a6 NUMBER := 0-1962.0724
45 , p5_a7 DATE := fnd_api.g_miss_date
46 , p5_a8 NUMBER := 0-1962.0724
47 );
48 procedure update_cgrparameters(p_api_version NUMBER
49 , p_init_msg_list VARCHAR2
50 , x_return_status out nocopy VARCHAR2
51 , x_msg_count out nocopy NUMBER
52 , x_msg_data out nocopy VARCHAR2
53 , p6_a0 out nocopy NUMBER
54 , p6_a1 out nocopy NUMBER
55 , p6_a2 out nocopy NUMBER
56 , p6_a3 out nocopy NUMBER
57 , p6_a4 out nocopy NUMBER
58 , p6_a5 out nocopy DATE
59 , p6_a6 out nocopy NUMBER
60 , p6_a7 out nocopy DATE
61 , p6_a8 out nocopy NUMBER
62 , p5_a0 NUMBER := 0-1962.0724
63 , p5_a1 NUMBER := 0-1962.0724
64 , p5_a2 NUMBER := 0-1962.0724
65 , p5_a3 NUMBER := 0-1962.0724
66 , p5_a4 NUMBER := 0-1962.0724
67 , p5_a5 DATE := fnd_api.g_miss_date
68 , p5_a6 NUMBER := 0-1962.0724
69 , p5_a7 DATE := fnd_api.g_miss_date
70 , p5_a8 NUMBER := 0-1962.0724
71 );
72 procedure delete_cgrparameters(p_api_version NUMBER
73 , p_init_msg_list VARCHAR2
74 , x_return_status out nocopy VARCHAR2
75 , x_msg_count out nocopy NUMBER
76 , x_msg_data out nocopy VARCHAR2
77 , p5_a0 JTF_NUMBER_TABLE
78 , p5_a1 JTF_NUMBER_TABLE
79 , p5_a2 JTF_NUMBER_TABLE
80 , p5_a3 JTF_NUMBER_TABLE
81 , p5_a4 JTF_NUMBER_TABLE
82 , p5_a5 JTF_DATE_TABLE
83 , p5_a6 JTF_NUMBER_TABLE
84 , p5_a7 JTF_DATE_TABLE
85 , p5_a8 JTF_NUMBER_TABLE
86 );
87 procedure insert_cgrparameters(p_api_version NUMBER
88 , p_init_msg_list VARCHAR2
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , p5_a0 JTF_NUMBER_TABLE
93 , p5_a1 JTF_NUMBER_TABLE
94 , p5_a2 JTF_NUMBER_TABLE
95 , p5_a3 JTF_NUMBER_TABLE
96 , p5_a4 JTF_NUMBER_TABLE
97 , p5_a5 JTF_DATE_TABLE
98 , p5_a6 JTF_NUMBER_TABLE
99 , p5_a7 JTF_DATE_TABLE
100 , p5_a8 JTF_NUMBER_TABLE
101 , p6_a0 out nocopy JTF_NUMBER_TABLE
102 , p6_a1 out nocopy JTF_NUMBER_TABLE
103 , p6_a2 out nocopy JTF_NUMBER_TABLE
104 , p6_a3 out nocopy JTF_NUMBER_TABLE
105 , p6_a4 out nocopy JTF_NUMBER_TABLE
106 , p6_a5 out nocopy JTF_DATE_TABLE
107 , p6_a6 out nocopy JTF_NUMBER_TABLE
108 , p6_a7 out nocopy JTF_DATE_TABLE
109 , p6_a8 out nocopy JTF_NUMBER_TABLE
110 );
111 procedure update_cgrparameters(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p5_a0 JTF_NUMBER_TABLE
117 , p5_a1 JTF_NUMBER_TABLE
118 , p5_a2 JTF_NUMBER_TABLE
119 , p5_a3 JTF_NUMBER_TABLE
120 , p5_a4 JTF_NUMBER_TABLE
121 , p5_a5 JTF_DATE_TABLE
122 , p5_a6 JTF_NUMBER_TABLE
123 , p5_a7 JTF_DATE_TABLE
124 , p5_a8 JTF_NUMBER_TABLE
125 , p6_a0 out nocopy JTF_NUMBER_TABLE
126 , p6_a1 out nocopy JTF_NUMBER_TABLE
127 , p6_a2 out nocopy JTF_NUMBER_TABLE
128 , p6_a3 out nocopy JTF_NUMBER_TABLE
129 , p6_a4 out nocopy JTF_NUMBER_TABLE
130 , p6_a5 out nocopy JTF_DATE_TABLE
131 , p6_a6 out nocopy JTF_NUMBER_TABLE
132 , p6_a7 out nocopy JTF_DATE_TABLE
133 , p6_a8 out nocopy JTF_NUMBER_TABLE
134 );
135 end okl_setupcgrparameters_pvt_w;