DBA Data[Home] [Help]

PACKAGE: APPS.CS_COST_DETAILS_PKG

Source


1 PACKAGE CS_COST_DETAILS_PKG AS
2 /* $Header: csxcsts.pls 120.1 2008/01/18 07:00:14 bkanimoz noship $ */
3 
4 /*=========================================
5          Procedure Insert Row
6  ===========================================
7 */
8 
9 PROCEDURE Insert_Row
10 (
11 
12 p_incident_id NUMBER,
13 p_estimate_detail_id NUMBER,
14 p_transaction_type_id NUMBER,
15 p_txn_billing_type_id NUMBER,
16 p_inventory_item_id NUMBER,
17 p_quantity NUMBER,
18 p_unit_cost NUMBER,
19 p_extended_cost NUMBER,
20 p_override_ext_cost_flag VARCHAR2,
21 p_transaction_date DATE,
22 p_source_id NUMBER,
23 p_source_code VARCHAR2,
24 p_unit_of_measure_code VARCHAR2,
25 p_currency_code VARCHAR2,
26 p_org_id NUMBER,
27 p_inventory_org_id NUMBER,
28 p_attribute1 VARCHAR2,
29 p_attribute2 VARCHAR2,
30 p_attribute3 VARCHAR2,
31 p_attribute4 VARCHAR2,
32 p_attribute5 VARCHAR2,
33 p_attribute6 VARCHAR2,
34 p_attribute7 VARCHAR2,
35 p_attribute8 VARCHAR2,
36 p_attribute9 VARCHAR2,
37 p_attribute10 VARCHAR2,
38 p_attribute11 VARCHAR2,
39 p_attribute12 VARCHAR2,
40 p_attribute13 VARCHAR2,
41 p_attribute14 VARCHAR2,
42 p_attribute15 VARCHAR2,
43 p_last_update_date DATE,
44 p_last_updated_by NUMBER,
45 p_last_update_login NUMBER,
46 p_created_by NUMBER,
47 p_creation_date DATE,
48 x_object_version_number OUT NOCOPY NUMBER,
49 x_cost_id OUT NOCOPY NUMBER
50 );
51 
52 /*=========================================
53          Procedure Update Row
54  ===========================================
55 */
56 
57 
58 PROCEDURE Update_Row
59 (
60 p_cost_id NUMBER,
61 p_incident_id NUMBER,
62 p_estimate_detail_id NUMBER,
63 p_transaction_type_id NUMBER,
64 p_txn_billing_type_id NUMBER,
65 p_inventory_item_id NUMBER,
66 p_quantity NUMBER,
67 p_unit_cost NUMBER,
68 p_extended_cost NUMBER,
69 p_override_ext_cost_flag VARCHAR2,
70 p_transaction_date DATE,
71 p_source_id NUMBER,
72 p_source_code VARCHAR2,
73 p_unit_of_measure_code VARCHAR2,
74 p_currency_code VARCHAR2,
75 p_org_id NUMBER,
76 p_inventory_org_id NUMBER,
77 p_attribute1 VARCHAR2,
78 p_attribute2 VARCHAR2,
79 p_attribute3 VARCHAR2,
80 p_attribute4 VARCHAR2,
81 p_attribute5 VARCHAR2,
82 p_attribute6 VARCHAR2,
83 p_attribute7 VARCHAR2,
84 p_attribute8 VARCHAR2,
85 p_attribute9 VARCHAR2,
86 p_attribute10 VARCHAR2,
87 p_attribute11 VARCHAR2,
88 p_attribute12 VARCHAR2,
89 p_attribute13 VARCHAR2,
90 p_attribute14 VARCHAR2,
91 p_attribute15 VARCHAR2,
92 p_last_update_date DATE,
93 p_last_updated_by NUMBER,
94 p_last_update_login NUMBER,
95 p_created_by NUMBER,
96 p_creation_date DATE,
97 x_object_version_number IN OUT NOCOPY NUMBER
98 
99 );
100 
101 /*=========================================
102          Procedure Delete Row
103  ===========================================
104 */
105 
106 PROCEDURE Delete_Row
107 (
108 p_cost_id NUMBER
109 );
110 
111 END CS_COST_DETAILS_PKG;
112