1 PACKAGE pn_distributions_pkg
2 -- $Header: PNTDISTS.pls 120.1 2005/07/25 06:50:23 appldev ship $
3
4 AS
5
6 ------------------------------------------------------------------------
7 -- PROCEDURE : INSERT_ROW
8 ------------------------------------------------------------------------
9 PROCEDURE insert_row (
10 x_rowid IN OUT NOCOPY VARCHAR2
11 ,x_distribution_id IN OUT NOCOPY NUMBER
12 ,x_account_id IN NUMBER
13 ,x_payment_term_id IN NUMBER
14 ,x_term_template_id IN NUMBER
15 ,x_account_class IN VARCHAR2
16 ,x_percentage IN NUMBER
17 ,x_line_number IN OUT NOCOPY NUMBER
18 ,x_last_update_date IN DATE
19 ,x_last_updated_by IN NUMBER
20 ,x_creation_date IN DATE
21 ,x_created_by IN NUMBER
22 ,x_last_update_login IN NUMBER
23 ,x_attribute_category IN VARCHAR2
24 ,x_attribute1 IN VARCHAR2
25 ,x_attribute2 IN VARCHAR2
26 ,x_attribute3 IN VARCHAR2
27 ,x_attribute4 IN VARCHAR2
28 ,x_attribute5 IN VARCHAR2
29 ,x_attribute6 IN VARCHAR2
30 ,x_attribute7 IN VARCHAR2
31 ,x_attribute8 IN VARCHAR2
32 ,x_attribute9 IN VARCHAR2
33 ,x_attribute10 IN VARCHAR2
34 ,x_attribute11 IN VARCHAR2
35 ,x_attribute12 IN VARCHAR2
36 ,x_attribute13 IN VARCHAR2
37 ,x_attribute14 IN VARCHAR2
38 ,x_attribute15 IN VARCHAR2
39 ,x_org_id IN NUMBER default NULL
40 );
41
42
43 ------------------------------------------------------------------------
44 -- PROCEDURE : UPDATE_ROW
45 ------------------------------------------------------------------------
46 PROCEDURE update_row (
47 x_rowid IN VARCHAR2
48 ,x_distribution_id IN NUMBER
49 ,x_account_id IN NUMBER
50 ,x_payment_term_id IN NUMBER
51 ,x_term_template_id IN NUMBER
52 ,x_account_class IN VARCHAR2
53 ,x_percentage IN NUMBER
54 ,x_line_number IN NUMBER
55 ,x_last_update_date IN DATE
56 ,x_last_updated_by IN NUMBER
57 ,x_last_update_login IN NUMBER
58 ,x_attribute_category IN VARCHAR2
59 ,x_attribute1 IN VARCHAR2
60 ,x_attribute2 IN VARCHAR2
61 ,x_attribute3 IN VARCHAR2
62 ,x_attribute4 IN VARCHAR2
63 ,x_attribute5 IN VARCHAR2
64 ,x_attribute6 IN VARCHAR2
65 ,x_attribute7 IN VARCHAR2
66 ,x_attribute8 IN VARCHAR2
67 ,x_attribute9 IN VARCHAR2
68 ,x_attribute10 IN VARCHAR2
69 ,x_attribute11 IN VARCHAR2
70 ,x_attribute12 IN VARCHAR2
71 ,x_attribute13 IN VARCHAR2
72 ,x_attribute14 IN VARCHAR2
73 ,x_attribute15 IN VARCHAR2
74 ,x_lease_change_id IN NUMBER DEFAULT NULL
75 );
76
77
78 ------------------------------------------------------------------------
79 -- PROCEDURE : LOCK_ROW
80 ------------------------------------------------------------------------
81 PROCEDURE lock_row (
82 x_rowid IN VARCHAR2
83 ,x_distribution_id IN NUMBER
84 ,x_account_id IN NUMBER
85 ,x_payment_term_id IN NUMBER
86 ,x_term_template_id IN NUMBER
87 ,x_account_class IN VARCHAR2
88 ,x_percentage IN NUMBER
89 ,x_line_number IN NUMBER
90 ,x_attribute_category IN VARCHAR2
91 ,x_attribute1 IN VARCHAR2
92 ,x_attribute2 IN VARCHAR2
93 ,x_attribute3 IN VARCHAR2
94 ,x_attribute4 IN VARCHAR2
95 ,x_attribute5 IN VARCHAR2
96 ,x_attribute6 IN VARCHAR2
97 ,x_attribute7 IN VARCHAR2
98 ,x_attribute8 IN VARCHAR2
99 ,x_attribute9 IN VARCHAR2
100 ,x_attribute10 IN VARCHAR2
101 ,x_attribute11 IN VARCHAR2
102 ,x_attribute12 IN VARCHAR2
103 ,x_attribute13 IN VARCHAR2
104 ,x_attribute14 IN VARCHAR2
105 ,x_attribute15 IN VARCHAR2
106 );
107
108
109 ------------------------------------------------------------------------
110 -- PROCEDURE : DELETE_ROW
111 ------------------------------------------------------------------------
112 PROCEDURE delete_row (x_rowid IN VARCHAR2);
113
114 -------------------------------------------------------------------------------
115 -- PROCDURE : delete_row
116 -- INVOKED FROM : delete_row procedure
117 -- PURPOSE : deletes the row
118 -- NOTE : overloaded this procedure to take PK as In parameter
119 -- HISTORY :
120 -- 04-JUL-05 piagrawa o Bug 4284035 - Created
121 -------------------------------------------------------------------------------
122 PROCEDURE delete_row (x_distribution_id IN NUMBER);
123
124 END pn_distributions_pkg;