APPS.AS_SALES_LEAD_SCORECARDS_PKG dependencies on AS_SALES_LEAD_SCORECARDS

Line 1: PACKAGE BODY as_sales_lead_scorecards_pkg AS

1: PACKAGE BODY as_sales_lead_scorecards_pkg AS
2: /* $Header: asxtscdb.pls 115.8 2002/11/22 08:05:07 ckapoor ship $ */
3: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
4: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
5: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 23: FROM as_sales_lead_scorecards

19: , x_end_date_active DATE
20: ) IS
21: CURSOR l_insert IS
22: SELECT ROWID
23: FROM as_sales_lead_scorecards
24: WHERE scorecard_id = x_scorecard_id;
25: BEGIN
26: INSERT INTO as_sales_lead_scorecards (
27: scorecard_id

Line 26: INSERT INTO as_sales_lead_scorecards (

22: SELECT ROWID
23: FROM as_sales_lead_scorecards
24: WHERE scorecard_id = x_scorecard_id;
25: BEGIN
26: INSERT INTO as_sales_lead_scorecards (
27: scorecard_id
28: , last_update_date
29: , last_updated_by
30: , creation_date

Line 62: DELETE FROM as_sales_lead_scorecards

58: PROCEDURE delete_row(
59: x_scorecard_id NUMBER
60: ) IS
61: BEGIN
62: DELETE FROM as_sales_lead_scorecards
63: WHERE scorecard_id = x_scorecard_id;
64: IF (SQL%NOTFOUND) THEN
65: RAISE NO_DATA_FOUND;
66: END IF;

Line 83: UPDATE as_sales_lead_scorecards

79: , x_start_date_active DATE
80: , x_end_date_active DATE
81: ) IS
82: BEGIN
83: UPDATE as_sales_lead_scorecards
84: SET
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)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 111: UPDATE as_sales_lead_scorecards

107: , x_start_date_active DATE
108: , x_end_date_active DATE
109: ) IS
110: BEGIN
111: UPDATE as_sales_lead_scorecards
112: SET
113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 141: FROM as_sales_lead_scorecards

137: , x_end_date_active DATE
138: ) IS
139: CURSOR l_lock IS
140: SELECT *
141: FROM as_sales_lead_scorecards
142: WHERE rowid = x_rowid
143: FOR UPDATE OF scorecard_id NOWAIT;
144: l_table_rec l_lock%ROWTYPE;
145: BEGIN

Line 208: FROM as_sales_lead_scorecards

204:
205:
206: CURSOR c_get_last_updated (c_scorecard_id NUMBER) IS
207: SELECT last_updated_by
208: FROM as_sales_lead_scorecards
209: WHERE scorecard_id = c_scorecard_id;
210: l_last_updated_by NUMBER;
211: l_rowid varchar2(64);
212:

Line 259: END as_sales_lead_scorecards_pkg;

255: END load_row;
256:
257:
258:
259: END as_sales_lead_scorecards_pkg;