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