[Home] [Help]
PACKAGE: APPS.OKL_SETUPPDTTEMPLATES_PVT_W
Source
1 package okl_setuppdttemplates_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLESPTS.pls 115.2 2002/12/24 04:04:17 sgorantl 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 DATE
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 , p3_a10 out nocopy DATE
16 , p3_a11 out nocopy NUMBER
17 , p0_a0 NUMBER := 0-1962.0724
18 , p0_a1 NUMBER := 0-1962.0724
19 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
20 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
21 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22 , p0_a5 DATE := fnd_api.g_miss_date
23 , p0_a6 DATE := fnd_api.g_miss_date
24 , p0_a7 NUMBER := 0-1962.0724
25 , p0_a8 DATE := fnd_api.g_miss_date
26 , p0_a9 NUMBER := 0-1962.0724
27 , p0_a10 DATE := fnd_api.g_miss_date
28 , p0_a11 NUMBER := 0-1962.0724
29 );
30 procedure get_version(p_name VARCHAR2
31 , p_cur_version VARCHAR2
32 , p_from_date date
33 , p_to_date date
34 , p_table VARCHAR2
35 , x_return_status out nocopy VARCHAR2
36 , x_new_version out nocopy VARCHAR2
37 );
38 procedure check_overlaps(p_id NUMBER
39 , p_name VARCHAR2
40 , p_from_date date
41 , p_to_date date
42 , p_table VARCHAR2
43 , x_return_status out nocopy VARCHAR2
44 , x_valid out nocopy number
45 );
46 procedure insert_pdttemplates(p_api_version NUMBER
47 , p_init_msg_list VARCHAR2
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_count out nocopy NUMBER
50 , x_msg_data out nocopy VARCHAR2
51 , p6_a0 out nocopy NUMBER
52 , p6_a1 out nocopy NUMBER
53 , p6_a2 out nocopy VARCHAR2
54 , p6_a3 out nocopy VARCHAR2
55 , p6_a4 out nocopy VARCHAR2
56 , p6_a5 out nocopy DATE
57 , p6_a6 out nocopy DATE
58 , p6_a7 out nocopy NUMBER
59 , p6_a8 out nocopy DATE
60 , p6_a9 out nocopy NUMBER
61 , p6_a10 out nocopy DATE
62 , p6_a11 out nocopy NUMBER
63 , p5_a0 NUMBER := 0-1962.0724
64 , p5_a1 NUMBER := 0-1962.0724
65 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
67 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68 , p5_a5 DATE := fnd_api.g_miss_date
69 , p5_a6 DATE := fnd_api.g_miss_date
70 , p5_a7 NUMBER := 0-1962.0724
71 , p5_a8 DATE := fnd_api.g_miss_date
72 , p5_a9 NUMBER := 0-1962.0724
73 , p5_a10 DATE := fnd_api.g_miss_date
74 , p5_a11 NUMBER := 0-1962.0724
75 );
76 procedure update_pdttemplates(p_api_version NUMBER
77 , p_init_msg_list VARCHAR2
78 , x_return_status out nocopy VARCHAR2
79 , x_msg_count out nocopy NUMBER
80 , x_msg_data out nocopy VARCHAR2
81 , p6_a0 out nocopy NUMBER
82 , p6_a1 out nocopy NUMBER
83 , p6_a2 out nocopy VARCHAR2
84 , p6_a3 out nocopy VARCHAR2
85 , p6_a4 out nocopy VARCHAR2
86 , p6_a5 out nocopy DATE
87 , p6_a6 out nocopy DATE
88 , p6_a7 out nocopy NUMBER
89 , p6_a8 out nocopy DATE
90 , p6_a9 out nocopy NUMBER
91 , p6_a10 out nocopy DATE
92 , p6_a11 out nocopy NUMBER
93 , p5_a0 NUMBER := 0-1962.0724
94 , p5_a1 NUMBER := 0-1962.0724
95 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a5 DATE := fnd_api.g_miss_date
99 , p5_a6 DATE := fnd_api.g_miss_date
100 , p5_a7 NUMBER := 0-1962.0724
101 , p5_a8 DATE := fnd_api.g_miss_date
102 , p5_a9 NUMBER := 0-1962.0724
103 , p5_a10 DATE := fnd_api.g_miss_date
104 , p5_a11 NUMBER := 0-1962.0724
105 );
106 end okl_setuppdttemplates_pvt_w;