[Home] [Help]
PACKAGE: APPS.CSI_TRANSACTIONS_PKG
Source
1 PACKAGE csi_transactions_pkg AUTHID CURRENT_USER AS
2 /* $Header: csittrxs.pls 120.1 2005/07/06 18:46:55 sguthiva noship $ */
3 -- start of comments
4 -- PACKAGE name : csi_transactions_pkg
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9 /* ---------------------------------------------------------------------------------- */
10 /* --- this PROCEDURE is used to insert the record INTO csi_transactions table. --- */
11 /* ---------------------------------------------------------------------------------- */
12 PROCEDURE insert_row(
13 px_transaction_id IN OUT NOCOPY NUMBER ,
14 p_transaction_date DATE ,
15 p_source_transaction_date DATE ,
16 p_transaction_type_id NUMBER ,
17 p_txn_sub_type_id NUMBER ,
18 p_source_group_ref_id NUMBER ,
19 p_source_group_ref VARCHAR2,
20 p_source_header_ref_id NUMBER ,
21 p_source_header_ref VARCHAR2,
22 p_source_line_ref_id NUMBER ,
23 p_source_line_ref VARCHAR2,
24 p_source_dist_ref_id1 NUMBER ,
25 p_source_dist_ref_id2 NUMBER ,
26 p_inv_material_transaction_id NUMBER ,
27 p_transaction_quantity NUMBER ,
28 p_transaction_uom_code VARCHAR2,
29 p_transacted_by NUMBER ,
30 p_transaction_status_code VARCHAR2,
31 p_transaction_action_code VARCHAR2,
32 p_message_id NUMBER ,
33 p_context VARCHAR2,
34 p_attribute1 VARCHAR2,
35 p_attribute2 VARCHAR2,
36 p_attribute3 VARCHAR2,
37 p_attribute4 VARCHAR2,
38 p_attribute5 VARCHAR2,
39 p_attribute6 VARCHAR2,
40 p_attribute7 VARCHAR2,
41 p_attribute8 VARCHAR2,
42 p_attribute9 VARCHAR2,
43 p_attribute10 VARCHAR2,
44 p_attribute11 VARCHAR2,
45 p_attribute12 VARCHAR2,
46 p_attribute13 VARCHAR2,
47 p_attribute14 VARCHAR2,
48 p_attribute15 VARCHAR2,
49 p_created_by NUMBER ,
50 p_creation_date DATE ,
51 p_last_updated_by NUMBER ,
52 p_last_update_date DATE ,
53 p_last_update_login NUMBER ,
54 p_object_version_number NUMBER ,
55 p_split_reason_code VARCHAR2,
56 p_gl_interface_status_code NUMBER);
57
58 /* ---------------------------------------------------------------------------------- */
59 /* --- This procedure is used to update the record into csi_transactions table. --- */
60 /* ---------------------------------------------------------------------------------- */
61
62 PROCEDURE update_row(
63 p_transaction_id NUMBER := fnd_api.g_miss_num ,
64 p_transaction_date DATE := fnd_api.g_miss_date,
65 p_source_transaction_date DATE := fnd_api.g_miss_date,
66 p_transaction_type_id NUMBER := fnd_api.g_miss_num ,
67 p_txn_sub_type_id NUMBER := fnd_api.g_miss_num ,
68 p_source_group_ref_id NUMBER := fnd_api.g_miss_num ,
69 p_source_group_ref VARCHAR2 := fnd_api.g_miss_char,
70 p_source_header_ref_id NUMBER := fnd_api.g_miss_num ,
71 p_source_header_ref VARCHAR2 := fnd_api.g_miss_char,
72 p_source_line_ref_id NUMBER := fnd_api.g_miss_num ,
73 p_source_line_ref VARCHAR2 := fnd_api.g_miss_char,
74 p_source_dist_ref_id1 NUMBER := fnd_api.g_miss_num ,
75 p_source_dist_ref_id2 NUMBER := fnd_api.g_miss_num ,
76 p_inv_material_transaction_id NUMBER := fnd_api.g_miss_num ,
77 p_transaction_quantity NUMBER := fnd_api.g_miss_num ,
78 p_transaction_uom_code VARCHAR2 := fnd_api.g_miss_char,
79 p_transacted_by NUMBER := fnd_api.g_miss_num ,
80 p_transaction_status_code VARCHAR2 := fnd_api.g_miss_char,
81 p_transaction_action_code VARCHAR2 := fnd_api.g_miss_char,
82 p_message_id NUMBER := fnd_api.g_miss_num ,
83 p_context VARCHAR2 := fnd_api.g_miss_char,
84 p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
85 p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
86 p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
87 p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
88 p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
89 p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
90 p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
91 p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
92 p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
93 p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
94 p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
95 p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
96 p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
97 p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
98 p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
99 p_created_by NUMBER := fnd_api.g_miss_num ,
100 p_creation_date DATE := fnd_api.g_miss_date,
101 p_last_updated_by NUMBER := fnd_api.g_miss_num ,
102 p_last_update_date DATE := fnd_api.g_miss_date,
103 p_last_update_login NUMBER := fnd_api.g_miss_num ,
104 p_object_version_NUMBER NUMBER := fnd_api.g_miss_num ,
105 p_split_reason_code VARCHAR2 := fnd_api.g_miss_char,
106 p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
107 );
108 /*
109 PROCEDURE lock_row(
110 p_transaction_id NUMBER,
111 p_transaction_date date,
112 p_source_transaction_date date,
113 p_transaction_type_id NUMBER,
114 p_source_group_ref_id NUMBER,
115 p_source_group_ref VARCHAR2,
116 p_source_header_ref_id NUMBER,
117 p_source_header_ref VARCHAR2,
118 p_source_line_ref_id NUMBER,
119 p_source_line_ref VARCHAR2,
120 p_source_dist_ref_id1 NUMBER,
121 p_source_dist_ref_id2 NUMBER,
122 p_inv_material_transaction_id NUMBER,
123 p_transaction_quantity NUMBER,
124 p_transaction_uom_code VARCHAR2,
125 p_transacted_by NUMBER,
126 p_transaction_status_code VARCHAR2,
127 p_transaction_action_code VARCHAR2,
128 p_message_id NUMBER,
129 p_context VARCHAR2,
130 p_attribute1 VARCHAR2,
131 p_attribute2 VARCHAR2,
132 p_attribute3 VARCHAR2,
133 p_attribute4 VARCHAR2,
134 p_attribute5 VARCHAR2,
135 p_attribute6 VARCHAR2,
136 p_attribute7 VARCHAR2,
137 p_attribute8 VARCHAR2,
138 p_attribute9 VARCHAR2,
139 p_attribute10 VARCHAR2,
140 p_attribute11 VARCHAR2,
141 p_attribute12 VARCHAR2,
142 p_attribute13 VARCHAR2,
143 p_attribute14 VARCHAR2,
144 p_attribute15 VARCHAR2,
145 p_created_by NUMBER,
146 p_creation_date date,
147 p_last_updated_by NUMBER,
148 p_last_update_date date,
149 p_last_update_login NUMBER,
150 p_object_version_NUMBER NUMBER)
151
152 PROCEDURE delete_row(
153 p_transaction_id NUMBER);
154
155 */
156 END csi_transactions_pkg;