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