[Home] [Help]
PACKAGE: APPS.CST_PAC_ITEM_COSTS_PKG
Source
1 PACKAGE CST_PAC_ITEM_COSTS_PKG AS
2 /* $Header: CSTGLICS.pls 120.1 2005/08/25 11:43:04 sheyu noship $ */
3 /*======================================================================+
4 | Copyright (c) 1999 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 | |
8 | FILENAME : CSTGLICS.pls |
9 | |
10 | DESCRIPTION: Use this package to insert,lock,update and |
11 | delete records from the table CST_PAC_ITEM_COSTS |
12 | |
13 | PROCEDURE LIST: |
14 | PROCEDURE Insert_row, |
15 | PROCEDURE Lock_row, |
16 | PROCEDURE Update_row, |
17 | PROCEDURE Delete_row |
18 | |
19 | HISTORY: |
20 | 02/15/99 Tatiana Simmonds Created |
21 +=======================================================================*/
22 --
23 --
24 --========================================================================
25 -- PUBLIC PROCEDURES
26 --========================================================================
27
28 --========================================================================
29 -- PROCEDURE : Insert_row PUBLIC
30 -- PARAMETERS p_row_id ROWID of the current record
31 -- p_pac_period_id period id
32 -- p_cost_group_id cost group id
33 -- p_inventory_item_id inventory item id
34 -- p_item_cost item cost
35 -- p_market_value market value
36 -- p_justification justification
37 -- p_creation_date date,when the record was inserted
38 -- p_created_by userid of the person,who inserted the record
39 -- COMMENT : Procedure inserts record into the table CST_PAC_ITEM_COSTS
40 --========================================================================
41 PROCEDURE Insert_row (
42 p_row_id IN OUT NOCOPY VARCHAR2
43 , p_pac_period_id NUMBER
44 , p_cost_group_id NUMBER
45 , p_inventory_item_id NUMBER
46 , p_item_cost NUMBER
47 , p_market_value NUMBER
48 , p_justification VARCHAR2
49 , p_creation_date DATE
50 , p_created_by NUMBER
51 );
52 --
53 --
54 --========================================================================
55 -- PROCEDURE : Lock_row PUBLIC
56 -- PARAMETERS: p_row_id ROWID of the current record
57 -- p_market_value market value
58 -- p_justification justification
59 -- COMMENT : Procedure locks record in the table CST_PAC_ITEM_COSTS.
60 -- EXCEPTION : CST_PAC_ITEM_COSTS_PKG.g_record_changed
61 -- CST_PAC_ITEM_COSTS_PKG.g_record_deleted
62 -- CST_PAC_ITEM_COSTS_PKG.g_record_locked
63 --========================================================================
64 PROCEDURE Lock_row (
65 p_row_id VARCHAR2
66 ,p_market_value NUMBER
67 ,p_justification VARCHAR2
68 );
69 --
70 --
71 --========================================================================
72 -- PROCEDURE : Update_row PUBLIC
73 -- PARAMETERS: p_row_id ROWID of the current record
74 -- p_item_cost item cost
75 -- p_market_value market value
76 -- p_justification justification
77 -- p_last_update_date date,when the record was updated
78 -- p_last_updated_by userid of the person,who updated the record
79 -- COMMENT : Procedure updates columns market_value and justification
80 -- in the table CST_PAC_ITEM_COSTS for the record
81 -- with ROWID,passed as a parameter p_row_id.
82 --========================================================================
83 PROCEDURE Update_row (
84 p_row_id VARCHAR2
85 , p_item_cost NUMBER
86 , p_market_value NUMBER
87 , p_justification VARCHAR2
88 , p_last_update_date DATE
89 , p_last_updated_by NUMBER
90 );
91 --
92 --
93 --========================================================================
94 -- PROCEDURE : Delete_row PUBLIC
95 -- PARAMETERS: p_row_id ROWID of the current record
96 -- COMMENT : Procedure deletes record with ROWID=p_row_id from the
97 -- table CST_PAC_ITEM_COSTS.
98 --========================================================================
99 PROCEDURE Delete_row (
100 p_row_id VARCHAR2);
101 --
102 --
103 END CST_PAC_ITEM_COSTS_PKG;