[Home] [Help]
PACKAGE: APPS.OKL_INTEREST_MAINT_PVT_W
Source
1 package okl_interest_maint_pvt_w as
2 /* $Header: OKLEINMS.pls 120.1 2005/07/11 12:50:50 dkagrawa noship $ */
3 function overlap_exists(p_idx_type VARCHAR2
4 , p_idx_name VARCHAR2
5 , p_datetime_valid date
6 , p_datetime_invalid date
7 ) return varchar2;
8 function overlap_exists(p_idx_id NUMBER
9 , p_datetime_valid date
10 , p_datetime_invalid date
11 ) return varchar2;
12 procedure int_hdr_ins_updt(p_api_version NUMBER
13 , p_init_msg_list VARCHAR2
14 , x_return_status out nocopy VARCHAR2
15 , x_msg_count out nocopy NUMBER
16 , x_msg_data out nocopy VARCHAR2
17 , p5_a0 NUMBER := 0-1962.0724
18 , p5_a1 NUMBER := 0-1962.0724
19 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
20 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
21 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
22 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
23 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
24 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
25 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
26 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
27 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
28 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
30 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
31 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
32 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
35 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
36 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
37 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
39 , p5_a22 NUMBER := 0-1962.0724
40 , p5_a23 NUMBER := 0-1962.0724
41 , p5_a24 NUMBER := 0-1962.0724
42 , p5_a25 DATE := fnd_api.g_miss_date
43 , p5_a26 NUMBER := 0-1962.0724
44 , p5_a27 DATE := fnd_api.g_miss_date
45 , p5_a28 NUMBER := 0-1962.0724
46 , p5_a29 DATE := fnd_api.g_miss_date
47 , p5_a30 NUMBER := 0-1962.0724
48 );
49 procedure int_hdr_ins_updt(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 , p5_a0 JTF_NUMBER_TABLE
55 , p5_a1 JTF_NUMBER_TABLE
56 , p5_a2 JTF_VARCHAR2_TABLE_200
57 , p5_a3 JTF_VARCHAR2_TABLE_2000
58 , p5_a4 JTF_VARCHAR2_TABLE_100
59 , p5_a5 JTF_VARCHAR2_TABLE_500
60 , p5_a6 JTF_VARCHAR2_TABLE_500
61 , p5_a7 JTF_VARCHAR2_TABLE_500
62 , p5_a8 JTF_VARCHAR2_TABLE_500
63 , p5_a9 JTF_VARCHAR2_TABLE_500
64 , p5_a10 JTF_VARCHAR2_TABLE_500
65 , p5_a11 JTF_VARCHAR2_TABLE_500
66 , p5_a12 JTF_VARCHAR2_TABLE_500
67 , p5_a13 JTF_VARCHAR2_TABLE_500
68 , p5_a14 JTF_VARCHAR2_TABLE_500
69 , p5_a15 JTF_VARCHAR2_TABLE_500
70 , p5_a16 JTF_VARCHAR2_TABLE_500
71 , p5_a17 JTF_VARCHAR2_TABLE_500
72 , p5_a18 JTF_VARCHAR2_TABLE_500
73 , p5_a19 JTF_VARCHAR2_TABLE_500
74 , p5_a20 JTF_VARCHAR2_TABLE_100
75 , p5_a21 JTF_VARCHAR2_TABLE_100
76 , p5_a22 JTF_NUMBER_TABLE
77 , p5_a23 JTF_NUMBER_TABLE
78 , p5_a24 JTF_NUMBER_TABLE
79 , p5_a25 JTF_DATE_TABLE
80 , p5_a26 JTF_NUMBER_TABLE
81 , p5_a27 JTF_DATE_TABLE
82 , p5_a28 JTF_NUMBER_TABLE
83 , p5_a29 JTF_DATE_TABLE
84 , p5_a30 JTF_NUMBER_TABLE
85 );
86 procedure int_dtl_ins_updt(p_api_version NUMBER
87 , p_init_msg_list VARCHAR2
88 , x_return_status out nocopy VARCHAR2
89 , x_msg_count out nocopy NUMBER
90 , x_msg_data out nocopy VARCHAR2
91 , p5_a0 NUMBER := 0-1962.0724
92 , p5_a1 NUMBER := 0-1962.0724
93 , p5_a2 NUMBER := 0-1962.0724
94 , p5_a3 NUMBER := 0-1962.0724
95 , p5_a4 DATE := fnd_api.g_miss_date
96 , p5_a5 DATE := fnd_api.g_miss_date
97 , p5_a6 NUMBER := 0-1962.0724
98 , p5_a7 NUMBER := 0-1962.0724
99 , p5_a8 NUMBER := 0-1962.0724
100 , p5_a9 DATE := fnd_api.g_miss_date
101 , p5_a10 NUMBER := 0-1962.0724
102 , p5_a11 DATE := fnd_api.g_miss_date
103 , p5_a12 NUMBER := 0-1962.0724
104 , p5_a13 DATE := fnd_api.g_miss_date
105 , p5_a14 NUMBER := 0-1962.0724
106 );
107 procedure int_dtl_ins_updt(p_api_version NUMBER
108 , p_init_msg_list VARCHAR2
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 , p5_a0 JTF_NUMBER_TABLE
113 , p5_a1 JTF_NUMBER_TABLE
114 , p5_a2 JTF_NUMBER_TABLE
115 , p5_a3 JTF_NUMBER_TABLE
116 , p5_a4 JTF_DATE_TABLE
117 , p5_a5 JTF_DATE_TABLE
118 , p5_a6 JTF_NUMBER_TABLE
119 , p5_a7 JTF_NUMBER_TABLE
120 , p5_a8 JTF_NUMBER_TABLE
121 , p5_a9 JTF_DATE_TABLE
122 , p5_a10 JTF_NUMBER_TABLE
123 , p5_a11 JTF_DATE_TABLE
124 , p5_a12 JTF_NUMBER_TABLE
125 , p5_a13 JTF_DATE_TABLE
126 , p5_a14 JTF_NUMBER_TABLE
127 );
128 end okl_interest_maint_pvt_w;