APPS.AS_SALES_LEAD_CARD_RULES_PKG dependencies on AS_SALES_LEAD_CARD_RULES

Line 1: PACKAGE BODY as_sales_lead_card_rules_pkg AS

1: PACKAGE BODY as_sales_lead_card_rules_pkg AS
2: /* $Header: asxtscrb.pls 120.1 2005/06/24 17:02:27 appldev ship $ */
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY VARCHAR2
5: , x_card_rule_id NUMBER

Line 19: FROM as_sales_lead_card_rules

15: , x_score NUMBER
16: ) IS
17: CURSOR l_insert IS
18: SELECT ROWID
19: FROM as_sales_lead_card_rules
20: WHERE card_rule_id = x_card_rule_id;
21: BEGIN
22: INSERT INTO as_sales_lead_card_rules (
23: card_rule_id

Line 22: INSERT INTO as_sales_lead_card_rules (

18: SELECT ROWID
19: FROM as_sales_lead_card_rules
20: WHERE card_rule_id = x_card_rule_id;
21: BEGIN
22: INSERT INTO as_sales_lead_card_rules (
23: card_rule_id
24: , scorecard_id
25: , last_update_date
26: , last_updated_by

Line 60: DELETE FROM as_sales_lead_card_rules

56: PROCEDURE delete_row(
57: x_card_rule_id NUMBER
58: ) IS
59: BEGIN
60: DELETE FROM as_sales_lead_card_rules
61: WHERE card_rule_id = x_card_rule_id;
62: IF (SQL%NOTFOUND) THEN
63: RAISE NO_DATA_FOUND;
64: END IF;

Line 82: UPDATE as_sales_lead_card_rules

78: , x_end_date_active DATE
79: , x_score NUMBER
80: ) IS
81: BEGIN
82: UPDATE as_sales_lead_card_rules
83: SET
84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
85: , scorecard_id=DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

Line 117: FROM as_sales_lead_card_rules

113: , x_score NUMBER
114: ) IS
115: CURSOR l_lock IS
116: SELECT *
117: FROM as_sales_lead_card_rules
118: WHERE rowid = x_rowid
119: FOR UPDATE OF card_rule_id NOWAIT;
120: l_table_rec l_lock%ROWTYPE;
121: BEGIN

Line 171: END as_sales_lead_card_rules_pkg;

167: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: END IF;
170: END lock_row;
171: END as_sales_lead_card_rules_pkg;