APPS.AS_CARD_RULE_QUAL_VALUES_PKG dependencies on AS_CARD_RULE_QUAL_VALUES

Line 1: PACKAGE BODY as_card_rule_qual_values_pkg AS

1: PACKAGE BODY as_card_rule_qual_values_pkg AS
2: /* $Header: asxtcqvb.pls 120.1 2005/06/24 16:58:11 appldev ship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_qual_value_id NUMBER

Line 27: FROM as_card_rule_qual_values

23: , x_end_date_active DATE
24: ) IS
25: CURSOR l_insert IS
26: SELECT ROWID
27: FROM as_card_rule_qual_values
28: WHERE qual_value_id = x_qual_value_id;
29: BEGIN
30: INSERT INTO as_card_rule_qual_values (
31: qual_value_id

Line 30: INSERT INTO as_card_rule_qual_values (

26: SELECT ROWID
27: FROM as_card_rule_qual_values
28: WHERE qual_value_id = x_qual_value_id;
29: BEGIN
30: INSERT INTO as_card_rule_qual_values (
31: qual_value_id
32: , last_update_date
33: , last_updated_by
34: , creation_date

Line 84: DELETE FROM as_card_rule_qual_values

80: PROCEDURE delete_row(
81: x_qual_value_id NUMBER
82: ) IS
83: BEGIN
84: DELETE FROM as_card_rule_qual_values
85: WHERE qual_value_id = x_qual_value_id;
86: IF (SQL%NOTFOUND) THEN
87: RAISE NO_DATA_FOUND;
88: END IF;

Line 112: UPDATE as_card_rule_qual_values

108: , x_start_date_active DATE
109: , x_end_date_active DATE
110: ) IS
111: BEGIN
112: UPDATE as_card_rule_qual_values
113: SET
114: qual_value_id=DECODE(x_qual_value_id,FND_API.G_MISS_NUM,NULL,x_qual_value_id)
115: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
116: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 156: UPDATE as_card_rule_qual_values

152: , x_start_date_active DATE
153: , x_end_date_active DATE
154: ) IS
155: BEGIN
156: UPDATE as_card_rule_qual_values
157: SET
158: qual_value_id=DECODE(x_qual_value_id,FND_API.G_MISS_NUM,NULL,x_qual_value_id)
159: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
160: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 206: FROM as_card_rule_qual_values

202: , x_end_date_active DATE
203: ) IS
204: CURSOR l_lock IS
205: SELECT *
206: FROM as_card_rule_qual_values
207: WHERE rowid = x_rowid
208: FOR UPDATE OF qual_value_id NOWAIT;
209: l_table_rec l_lock%ROWTYPE;
210: BEGIN

Line 309: FROM as_card_rule_qual_values

305: row_id varchar2(64);
306:
307: CURSOR c_get_last_updated (c_qual_value_id NUMBER) IS
308: SELECT last_updated_by
309: FROM as_card_rule_qual_values
310: WHERE qual_value_id = c_qual_value_id;
311: l_last_updated_by NUMBER;
312: l_rowid varchar2(64);
313:

Line 377: END as_card_rule_qual_values_pkg;

373: );
374:
375: END load_row;
376:
377: END as_card_rule_qual_values_pkg;