DBA Data[Home] [Help]

PACKAGE: APPS.OKL_SETUPCONTEXTGROUPS_PVT_W

Source


1 package okl_setupcontextgroups_pvt_w as
2   /* $Header: OKLESCGS.pls 120.1 2005/07/12 09:08:40 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  VARCHAR2
8     , p3_a3 out nocopy  VARCHAR2
9     , p3_a4 out nocopy  VARCHAR2
10     , p3_a5 out nocopy  NUMBER
11     , p3_a6 out nocopy  DATE
12     , p3_a7 out nocopy  NUMBER
13     , p3_a8 out nocopy  DATE
14     , p3_a9 out nocopy  NUMBER
15     , p0_a0  NUMBER := 0-1962.0724
16     , p0_a1  NUMBER := 0-1962.0724
17     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
18     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
19     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
20     , p0_a5  NUMBER := 0-1962.0724
21     , p0_a6  DATE := fnd_api.g_miss_date
22     , p0_a7  NUMBER := 0-1962.0724
23     , p0_a8  DATE := fnd_api.g_miss_date
24     , p0_a9  NUMBER := 0-1962.0724
25   );
26   procedure insert_contextgroups(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , x_return_status out nocopy  VARCHAR2
29     , x_msg_count out nocopy  NUMBER
30     , x_msg_data out nocopy  VARCHAR2
31     , p6_a0 out nocopy  NUMBER
32     , p6_a1 out nocopy  NUMBER
33     , p6_a2 out nocopy  VARCHAR2
34     , p6_a3 out nocopy  VARCHAR2
35     , p6_a4 out nocopy  VARCHAR2
36     , p6_a5 out nocopy  NUMBER
37     , p6_a6 out nocopy  DATE
38     , p6_a7 out nocopy  NUMBER
39     , p6_a8 out nocopy  DATE
40     , p6_a9 out nocopy  NUMBER
41     , p5_a0  NUMBER := 0-1962.0724
42     , p5_a1  NUMBER := 0-1962.0724
43     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
44     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
45     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
46     , p5_a5  NUMBER := 0-1962.0724
47     , p5_a6  DATE := fnd_api.g_miss_date
48     , p5_a7  NUMBER := 0-1962.0724
49     , p5_a8  DATE := fnd_api.g_miss_date
50     , p5_a9  NUMBER := 0-1962.0724
51   );
52   procedure update_contextgroups(p_api_version  NUMBER
53     , p_init_msg_list  VARCHAR2
54     , x_return_status out nocopy  VARCHAR2
55     , x_msg_count out nocopy  NUMBER
56     , x_msg_data out nocopy  VARCHAR2
57     , p6_a0 out nocopy  NUMBER
58     , p6_a1 out nocopy  NUMBER
59     , p6_a2 out nocopy  VARCHAR2
60     , p6_a3 out nocopy  VARCHAR2
61     , p6_a4 out nocopy  VARCHAR2
62     , p6_a5 out nocopy  NUMBER
63     , p6_a6 out nocopy  DATE
64     , p6_a7 out nocopy  NUMBER
65     , p6_a8 out nocopy  DATE
66     , p6_a9 out nocopy  NUMBER
67     , p5_a0  NUMBER := 0-1962.0724
68     , p5_a1  NUMBER := 0-1962.0724
69     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
70     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
71     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
72     , p5_a5  NUMBER := 0-1962.0724
73     , p5_a6  DATE := fnd_api.g_miss_date
74     , p5_a7  NUMBER := 0-1962.0724
75     , p5_a8  DATE := fnd_api.g_miss_date
76     , p5_a9  NUMBER := 0-1962.0724
77   );
78 end okl_setupcontextgroups_pvt_w;