[Home] [Help]
PACKAGE: APPS.CN_CREDIT_CONV_FCTS_PKG
Source
1 package CN_CREDIT_CONV_FCTS_PKG AUTHID CURRENT_USER as
2 /* $Header: cncrtcvs.pls 115.2 2001/10/29 17:06:17 pkm ship $ */
3 PROCEDURE Insert_Row
4 ( x_credit_conv_fct_id NUMBER ,
5 x_from_credit_type_id NUMBER ,
6 x_to_credit_type_id NUMBER ,
7 x_conversion_factor NUMBER ,
8 x_start_date DATE ,
9 x_end_date DATE ,
10 x_attribute_category VARCHAR2 := NULL ,
11 x_attribute1 VARCHAR2 := NULL ,
12 x_attribute2 VARCHAR2 := NULL ,
13 x_attribute3 VARCHAR2 := NULL ,
14 x_attribute4 VARCHAR2 := NULL ,
15 x_attribute5 VARCHAR2 := NULL ,
16 x_attribute6 VARCHAR2 := NULL ,
17 x_attribute7 VARCHAR2 := NULL ,
18 x_attribute8 VARCHAR2 := NULL ,
19 x_attribute9 VARCHAR2 := NULL ,
20 x_attribute10 VARCHAR2 := NULL ,
21 x_attribute11 VARCHAR2 := NULL ,
22 x_attribute12 VARCHAR2 := NULL ,
23 x_attribute13 VARCHAR2 := NULL ,
24 x_attribute14 VARCHAR2 := NULL ,
25 x_attribute15 VARCHAR2 := NULL ,
26 x_created_by NUMBER ,
27 x_creation_date DATE ,
28 x_last_update_login NUMBER ,
29 x_last_update_date DATE ,
30 x_last_updated_by NUMBER
31 );
32
33 PROCEDURE Update_Row
34 ( x_credit_conv_fct_id NUMBER ,
35 x_object_version number,
36 x_from_credit_type_id NUMBER ,
37 x_to_credit_type_id NUMBER ,
38 x_conversion_factor NUMBER ,
39 x_start_date DATE ,
40 x_end_date DATE ,
41 x_attribute_category VARCHAR2 := NULL ,
42 x_attribute1 VARCHAR2 := NULL ,
43 x_attribute2 VARCHAR2 := NULL ,
44 x_attribute3 VARCHAR2 := NULL ,
45 x_attribute4 VARCHAR2 := NULL ,
46 x_attribute5 VARCHAR2 := NULL ,
47 x_attribute6 VARCHAR2 := NULL ,
48 x_attribute7 VARCHAR2 := NULL ,
49 x_attribute8 VARCHAR2 := NULL ,
50 x_attribute9 VARCHAR2 := NULL ,
51 x_attribute10 VARCHAR2 := NULL ,
52 x_attribute11 VARCHAR2 := NULL ,
53 x_attribute12 VARCHAR2 := NULL ,
54 x_attribute13 VARCHAR2 := NULL ,
55 x_attribute14 VARCHAR2 := NULL ,
56 x_attribute15 VARCHAR2 := NULL ,
57 x_created_by NUMBER ,
58 x_creation_date DATE ,
59 x_last_update_login NUMBER ,
60 x_last_update_date DATE ,
61 x_last_updated_by NUMBER
62 );
63
64 PROCEDURE Lock_Row
65 ( x_credit_conv_fct_id NUMBER ,
66 x_from_credit_type_id NUMBER ,
67 x_to_credit_type_id NUMBER ,
68 x_conversion_factor NUMBER ,
69 x_start_date DATE ,
70 x_end_date DATE ,
71 x_attribute_category VARCHAR2 := NULL ,
72 x_attribute1 VARCHAR2 := NULL ,
73 x_attribute2 VARCHAR2 := NULL ,
74 x_attribute3 VARCHAR2 := NULL ,
75 x_attribute4 VARCHAR2 := NULL ,
76 x_attribute5 VARCHAR2 := NULL ,
77 x_attribute6 VARCHAR2 := NULL ,
78 x_attribute7 VARCHAR2 := NULL ,
79 x_attribute8 VARCHAR2 := NULL ,
80 x_attribute9 VARCHAR2 := NULL ,
81 x_attribute10 VARCHAR2 := NULL ,
82 x_attribute11 VARCHAR2 := NULL ,
83 x_attribute12 VARCHAR2 := NULL ,
84 x_attribute13 VARCHAR2 := NULL ,
85 x_attribute14 VARCHAR2 := NULL ,
86 x_attribute15 VARCHAR2 := NULL ,
87 x_created_by NUMBER ,
88 x_creation_date DATE ,
89 x_last_update_login NUMBER ,
90 x_last_update_date DATE ,
91 x_last_updated_by NUMBER
92 );
93
94 PROCEDURE Delete_Row(x_credit_conv_fct_id NUMBER);
95 end CN_CREDIT_CONV_FCTS_PKG;