APPS.CST_PAC_ITEM_COSTS_PKG dependencies on CST_PAC_ITEM_COSTS

Line 1: PACKAGE BODY CST_PAC_ITEM_COSTS_PKG AS

1: PACKAGE BODY CST_PAC_ITEM_COSTS_PKG AS
2: /* $Header: CSTGLICB.pls 115.7 2002/11/08 20:33:53 awwang ship $ */
3: /*======================================================================+
4: | Copyright (c) 1999 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 10: | records from the table CST_PAC_ITEM_COSTS |

6: | All rights reserved. |
7: | FILENAME : CSTGLICS.pls |
8: | |
9: | DESCRIPTION: Use this package to insert,lock,update and delete |
10: | records from the table CST_PAC_ITEM_COSTS |
11: | |
12: | PROCEDURE LIST: |
13: | PROCEDURE Insert_row, |
14: | PROCEDURE Lock_row, |

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30) :='CST_PAC_ITEM_COSTS_PKG';

21:
22: --======================================================================
23: --CONSTANTS
24: --======================================================================
25: G_PKG_NAME CONSTANT VARCHAR2(30) :='CST_PAC_ITEM_COSTS_PKG';
26:
27:
28: --========================================================================
29: -- PROCEDURE : Insert_row PUBLIC

Line 39: -- COMMENT : Procedure inserts record into the table CST_PAC_ITEM_COSTS

35: -- p_market_value market value
36: -- p_justification justification
37: -- p_creation_date date, when a record was inserted
38: -- p_created_by userid of the person,who inserted a 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

Line 57: CST_PAC_ITEM_COSTS

53: CURSOR C IS
54: SELECT
55: rowid
56: FROM
57: CST_PAC_ITEM_COSTS
58: WHERE pac_period_id=p_pac_period_id
59: AND cost_group_id=p_cost_group_id
60: AND inventory_item_id=p_inventory_item_id;
61:

Line 64: INTO cst_pac_item_costs

60: AND inventory_item_id=p_inventory_item_id;
61:
62: BEGIN
63: INSERT
64: INTO cst_pac_item_costs
65: ( pac_period_id
66: , cost_group_id
67: , inventory_item_id
68: , item_cost

Line 109: -- COMMENT : Procedure locks current record in the table CST_PAC_ITEM_COSTS.

105: -- PROCEDURE : Lock_row PUBLIC
106: -- PARAMETERS: p_row_id ROWID of the current record
107: -- p_market_value market value
108: -- p_justification justification
109: -- COMMENT : Procedure locks current record in the table CST_PAC_ITEM_COSTS.
110: --========================================================================
111: PROCEDURE Lock_row (
112: p_row_id VARCHAR2
113: ,p_market_value NUMBER

Line 120: FROM CST_PAC_ITEM_COSTS

116: IS
117: CURSOR c
118: IS
119: SELECT *
120: FROM CST_PAC_ITEM_COSTS
121: WHERE ROWID=CHARTOROWID(p_row_id)
122: FOR UPDATE OF market_value NOWAIT;
123:
124: recinfo c%ROWTYPE;

Line 163: -- in the table CST_PAC_ITEM_COSTS for the record

159: -- p_justification justification
160: -- p_last_update_date date,when the record was updated
161: -- p_last_updated_by userid of the person,who updated the record
162: -- COMMENT : Procedure updates columns market_value and justification
163: -- in the table CST_PAC_ITEM_COSTS for the record
164: -- with ROWID,passed as a parameter p_row_id.
165: --========================================================================
166: PROCEDURE Update_row (
167: p_row_id VARCHAR2

Line 177: UPDATE CST_PAC_ITEM_COSTS

173: )
174: IS
175:
176: BEGIN
177: UPDATE CST_PAC_ITEM_COSTS
178: SET
179: item_cost=p_item_cost
180: ,market_value=p_market_value
181: ,justification=p_justification

Line 206: -- table CST_PAC_ITEM_COSTS.

202: --========================================================================
203: -- PROCEDURE : Delete_row PUBLIC
204: -- PARAMETERS: p_row_id ROWID of the current record
205: -- COMMENT : Procedure deletes record with ROWID=p_row_id from the
206: -- table CST_PAC_ITEM_COSTS.
207: --========================================================================
208: PROCEDURE Delete_row (
209: p_row_id VARCHAR2)
210: IS

Line 213: FROM CST_PAC_ITEM_COSTS

209: p_row_id VARCHAR2)
210: IS
211: BEGIN
212: DELETE
213: FROM CST_PAC_ITEM_COSTS
214: WHERE ROWID=p_row_id;
215:
216: IF (SQL%NOTFOUND)
217: THEN

Line 230: END CST_PAC_ITEM_COSTS_PKG;

226: RAISE;
227:
228: END Delete_row;
229:
230: END CST_PAC_ITEM_COSTS_PKG;