APPS.CSF_PLAN_TERRS_PKG dependencies on CSF_PLAN_TERRS

Line 1: PACKAGE BODY CSF_PLAN_TERRS_PKG AS

1: PACKAGE BODY CSF_PLAN_TERRS_PKG AS
2: /* $Header: CSFVPLTB.pls 120.3 2007/12/18 06:21:59 ipananil ship $ */
3:
4: /*
5: +========================================================================+

Line 12: CSF_PLAN_TERRS_PKG

8: | All rights reserved. |
9: +========================================================================+
10: Name
11: ----
12: CSF_PLAN_TERRS_PKG
13:
14: Purpose
15: -------
16: Insert, lock and delete records in the CSF_PLAN_TERRS table.

Line 16: Insert, lock and delete records in the CSF_PLAN_TERRS table.

12: CSF_PLAN_TERRS_PKG
13:
14: Purpose
15: -------
16: Insert, lock and delete records in the CSF_PLAN_TERRS table.
17: Check uniqueness of columns PLAN_TERR_ID and TERR_ID/GROUP_ID combinations.
18: Check referential integrity of the TERR_ID and GROUP_ID columns.
19:
20: History

Line 46: FROM csf_plan_terrs

42: IS
43:
44: CURSOR c_unique IS
45: SELECT NULL
46: FROM csf_plan_terrs
47: WHERE ( p_rowid IS NULL OR rowid <> p_rowid )
48: AND terr_id = p_terr_id
49: AND group_id = p_group_id;
50:

Line 59: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_NOT_UNIQUE');

55: OPEN c_unique;
56: FETCH c_unique INTO r_unique;
57: IF c_unique%FOUND THEN
58: CLOSE c_unique;
59: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_NOT_UNIQUE');
60: FND_MESSAGE.Set_Token('P_TERR_ID', p_terr_id);
61: FND_MESSAGE.Set_Token('P_GROUP_ID', p_group_id);
62: APP_EXCEPTION.Raise_Exception;
63: END IF;

Line 94: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_INVALID_TERR');

90: OPEN c_terr;
91: FETCH c_terr INTO r_terr;
92: IF c_terr%NOTFOUND THEN
93: CLOSE c_terr;
94: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_INVALID_TERR');
95: FND_MESSAGE.Set_Token('P_TERR_ID', p_terr_id);
96: APP_EXCEPTION.Raise_Exception;
97: END IF;
98: CLOSE c_terr;

Line 104: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_INVALID_GROUP');

100: OPEN c_group;
101: FETCH c_group INTO r_group;
102: IF c_group%NOTFOUND THEN
103: CLOSE c_group;
104: FND_MESSAGE.Set_Name('CSF', 'CSF_PLAN_TERRS_INVALID_GROUP');
105: FND_MESSAGE.Set_Token('P_GROUP_ID', p_group_id);
106: APP_EXCEPTION.Raise_Exception;
107: END IF;
108: CLOSE c_group;

Line 130: FROM csf_plan_terrs

126: l_object_version_number NUMBER := 1;
127:
128: CURSOR c_plan_terrs IS
129: SELECT rowid
130: FROM csf_plan_terrs
131: WHERE plan_terr_id = l_plan_terr_id;
132:
133: BEGIN
134:

Line 141: SELECT CSF_PLAN_TERRS_S.NEXTVAL

137: l_creation_date := SYSDATE;
138: l_created_by := FND_GLOBAL.User_Id;
139: l_last_update_login := FND_GLOBAL.Login_Id;
140:
141: SELECT CSF_PLAN_TERRS_S.NEXTVAL
142: INTO l_plan_terr_id
143: FROM dual;
144:
145: INSERT INTO csf_plan_terrs

Line 145: INSERT INTO csf_plan_terrs

141: SELECT CSF_PLAN_TERRS_S.NEXTVAL
142: INTO l_plan_terr_id
143: FROM dual;
144:
145: INSERT INTO csf_plan_terrs
146: ( plan_terr_id ,
147: last_update_date ,
148: last_updated_by ,
149: creation_date ,

Line 188: FROM csf_plan_terrs

184: l_del_terr varchar2(4000);
185: l_dummy boolean;
186: CURSOR c_deleted_terr is
187: SELECT terr_id
188: FROM csf_plan_terrs
189: WHERE rowid = p_rowid;
190: BEGIN
191: -- BUG Fixed 3224947
192: -- After deleting a territory from the planner group

Line 215: DELETE FROM csf_plan_terrs

211:
212: -- Save the modified list
213: csf_util_pvt.set_selected_terr( l_selected_terr, fnd_global.user_id );
214: end if;
215: DELETE FROM csf_plan_terrs
216: WHERE rowid = p_rowid;
217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;

Line 234: FROM csf_plan_terrs

230: l_object_version_number NUMBER;
231:
232: CURSOR c_plan_terrs IS
233: SELECT object_version_number
234: FROM csf_plan_terrs
235: WHERE rowid = p_rowid
236: FOR UPDATE NOWAIT;
237:
238: BEGIN

Line 259: END CSF_PLAN_TERRS_PKG;

255:
256: END Lock_Row;
257:
258:
259: END CSF_PLAN_TERRS_PKG;
260:
261: