APPS.CN_SEC_PROF_ASSIGNS_PKG dependencies on CN_SEC_PROF_ASSIGNS

Line 1: PACKAGE BODY CN_SEC_PROF_ASSIGNS_PKG AS

1: PACKAGE BODY CN_SEC_PROF_ASSIGNS_PKG AS
2: /* $Header: cntspfab.pls 115.6 2001/10/29 17:16:56 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_SEC_PROF_ASSIGNS_PKG

Line 5: -- CN_SEC_PROF_ASSIGNS_PKG

1: PACKAGE BODY CN_SEC_PROF_ASSIGNS_PKG AS
2: /* $Header: cntspfab.pls 115.6 2001/10/29 17:16:56 pkm ship $ */
3: --
4: -- Package Name
5: -- CN_SEC_PROF_ASSIGNS_PKG
6: -- Purpose
7: -- Table handler for CN_SEC_PROF_ASSIGNS
8: -- Form
9: -- CNSPROF

Line 7: -- Table handler for CN_SEC_PROF_ASSIGNS

3: --
4: -- Package Name
5: -- CN_SEC_PROF_ASSIGNS_PKG
6: -- Purpose
7: -- Table handler for CN_SEC_PROF_ASSIGNS
8: -- Form
9: -- CNSPROF
10: -- Block
11: -- CN_SVC_GRP_ASSIGNS

Line 18: SELECT cn_sec_prof_assigns_s.NEXTVAL

14: -- 28-Jul-99 Yonghong Mao Created
15:
16: PROCEDURE get_sec_prof_assign_id(x_sec_prof_assign_id IN OUT NUMBER) IS
17: BEGIN
18: SELECT cn_sec_prof_assigns_s.NEXTVAL
19: INTO x_sec_prof_assign_id
20: FROM dual;
21: END get_sec_prof_assign_id;
22:

Line 26: FROM cn_sec_prof_assigns

22:
23: PROCEDURE Insert_Row( x_new_rec IN OUT sec_prof_assign_rec_type) IS
24: CURSOR c IS
25: SELECT 1
26: FROM cn_sec_prof_assigns
27: WHERE sec_prof_assign_id = x_new_rec.sec_prof_assign_id;
28: l_dummy number;
29: BEGIN
30: IF x_new_rec.sec_prof_assign_id IS NULL THEN

Line 126: INSERT INTO cn_sec_prof_assigns

122: x_new_rec.last_update_date,
123: x_new_rec.last_updated_by
124: FROM dual;
125:
126: INSERT INTO cn_sec_prof_assigns
127: (sec_prof_assign_id,
128: security_profile_id,
129: salesrep_id,
130: start_date,

Line 196: FROM cn_sec_prof_assigns

192:
193: PROCEDURE Update_Row(x_new_rec sec_prof_assign_rec_type) IS
194: CURSOR c IS
195: SELECT *
196: FROM cn_sec_prof_assigns
197: WHERE sec_prof_assign_id = x_new_rec.sec_prof_assign_id
198: FOR UPDATE OF sec_prof_assign_id nowait;
199:
200: rec c%ROWTYPE;

Line 308: UPDATE cn_sec_prof_assigns SET

304: rec.last_update_date,
305: rec.last_updated_by
306: FROM dual;
307:
308: UPDATE cn_sec_prof_assigns SET
309: security_profile_id = rec.security_profile_id,
310: salesrep_id = rec.salesrep_id,
311: start_date = rec.start_date,
312: end_date = rec.end_date,

Line 343: FROM cn_sec_prof_assigns

339:
340: PROCEDURE Lock_Row(x_rec sec_prof_assign_rec_type) IS
341: CURSOR c IS
342: SELECT *
343: FROM cn_sec_prof_assigns
344: WHERE sec_prof_assign_id = x_rec.sec_prof_assign_id
345: FOR UPDATE OF sec_prof_assign_id nowait;
346: recinfo c%ROWTYPE;
347:

Line 442: DELETE cn_sec_prof_assigns

438: END Lock_Row;
439:
440: PROCEDURE Delete_Row(x_sec_prof_assign_id NUMBER) IS
441: BEGIN
442: DELETE cn_sec_prof_assigns
443: WHERE sec_prof_assign_id = x_sec_prof_assign_id;
444:
445: IF (SQL%notfound) THEN
446: RAISE no_data_found;

Line 451: END CN_SEC_PROF_ASSIGNS_PKG;

447: END IF;
448:
449: END Delete_Row;
450:
451: END CN_SEC_PROF_ASSIGNS_PKG;