[Home] [Help]
PACKAGE: APPS.OKL_PERD_STATUS_PUB_W
Source
1 package okl_perd_status_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUPSMS.pls 120.1 2005/07/18 10:31:55 asawanka noship $ */
3 procedure search_period_status(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy JTF_NUMBER_TABLE
9 , p6_a1 out nocopy JTF_NUMBER_TABLE
10 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
11 , p6_a3 out nocopy JTF_DATE_TABLE
12 , p6_a4 out nocopy JTF_NUMBER_TABLE
13 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
14 , p6_a6 out nocopy JTF_DATE_TABLE
15 , p6_a7 out nocopy JTF_DATE_TABLE
16 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
17 , p6_a9 out nocopy JTF_NUMBER_TABLE
18 , p6_a10 out nocopy JTF_NUMBER_TABLE
19 , p6_a11 out nocopy JTF_NUMBER_TABLE
20 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
21 , p6_a13 out nocopy JTF_DATE_TABLE
22 , p6_a14 out nocopy JTF_NUMBER_TABLE
23 , p6_a15 out nocopy JTF_NUMBER_TABLE
24 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
25 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
26 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
27 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
28 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
29 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
30 , p6_a22 out nocopy JTF_DATE_TABLE
31 , p6_a23 out nocopy JTF_DATE_TABLE
32 , p6_a24 out nocopy JTF_NUMBER_TABLE
33 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
34 , p5_a0 NUMBER := 0-1962.0724
35 , p5_a1 NUMBER := 0-1962.0724
36 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
37 , p5_a3 DATE := fnd_api.g_miss_date
38 , p5_a4 NUMBER := 0-1962.0724
39 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a6 DATE := fnd_api.g_miss_date
41 , p5_a7 DATE := fnd_api.g_miss_date
42 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
43 , p5_a9 NUMBER := 0-1962.0724
44 , p5_a10 NUMBER := 0-1962.0724
45 , p5_a11 NUMBER := 0-1962.0724
46 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
47 , p5_a13 DATE := fnd_api.g_miss_date
48 , p5_a14 NUMBER := 0-1962.0724
49 , p5_a15 NUMBER := 0-1962.0724
50 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
51 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
52 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
53 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
54 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
55 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
56 , p5_a22 DATE := fnd_api.g_miss_date
57 , p5_a23 DATE := fnd_api.g_miss_date
58 , p5_a24 NUMBER := 0-1962.0724
59 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
60 );
61 procedure update_period_status(p_api_version NUMBER
62 , p_init_msg_list VARCHAR2
63 , x_return_status out nocopy VARCHAR2
64 , x_msg_count out nocopy NUMBER
65 , x_msg_data out nocopy VARCHAR2
66 , p5_a0 JTF_NUMBER_TABLE
67 , p5_a1 JTF_NUMBER_TABLE
68 , p5_a2 JTF_VARCHAR2_TABLE_100
69 , p5_a3 JTF_DATE_TABLE
70 , p5_a4 JTF_NUMBER_TABLE
71 , p5_a5 JTF_VARCHAR2_TABLE_100
72 , p5_a6 JTF_DATE_TABLE
73 , p5_a7 JTF_DATE_TABLE
74 , p5_a8 JTF_VARCHAR2_TABLE_100
75 , p5_a9 JTF_NUMBER_TABLE
76 , p5_a10 JTF_NUMBER_TABLE
77 , p5_a11 JTF_NUMBER_TABLE
78 , p5_a12 JTF_VARCHAR2_TABLE_100
79 , p5_a13 JTF_DATE_TABLE
80 , p5_a14 JTF_NUMBER_TABLE
81 , p5_a15 JTF_NUMBER_TABLE
82 , p5_a16 JTF_VARCHAR2_TABLE_200
83 , p5_a17 JTF_VARCHAR2_TABLE_200
84 , p5_a18 JTF_VARCHAR2_TABLE_200
85 , p5_a19 JTF_VARCHAR2_TABLE_200
86 , p5_a20 JTF_VARCHAR2_TABLE_200
87 , p5_a21 JTF_VARCHAR2_TABLE_200
88 , p5_a22 JTF_DATE_TABLE
89 , p5_a23 JTF_DATE_TABLE
90 , p5_a24 JTF_NUMBER_TABLE
91 , p5_a25 JTF_VARCHAR2_TABLE_100
92 );
93 end okl_perd_status_pub_w;