PACKAGE: APPS.CSF_PLAN_TERRS_PKG

Source

1 PACKAGE CSF_PLAN_TERRS_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSFVPLTS.pls 115.7 2003/10/16 06:35:29 srengana ship $ */
3 
4 /*
5 +========================================================================+
6 |                 Copyright (c) 1999 Oracle Corporation                  |
7 |                    Redwood Shores, California, USA                     |
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.
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
21 -------
22 6-JAN-2000 ipels          - First creation
23 13-NOV-2002 jgrondel      Bug 2663989.
24                           Added NOCOPY hint to procedure
25                           out-parameters.
26 13-NOV-2002 jgrondel      Added dbdrv.
27 03-dec-2002 jgrondel      Bug 2692082.
28                           Added NOCOPY hint to procedure
29                           out-parameters.
30 
31 +========================================================================+
32 */
33 
34 
35 PROCEDURE Check_Unique
36 ( p_rowid    IN VARCHAR2,
37   p_terr_id  IN NUMBER,
38   p_group_id IN NUMBER
39 );
40 
41 PROCEDURE Check_References
42 ( p_terr_id  IN NUMBER,
43   p_group_id IN NUMBER
44 );
45 
46 PROCEDURE Insert_Row
47 ( x_rowid    IN OUT NOCOPY VARCHAR2,
48   p_terr_id  IN     NUMBER,
49   p_group_id IN     NUMBER
50 );
51 
52 PROCEDURE Delete_Row
53 ( p_rowid IN VARCHAR2
54 );
55 
56 PROCEDURE Lock_Row
57 ( p_rowid                 IN VARCHAR2,
58   p_object_version_number IN NUMBER
59 );
60 
61 
62 END;
63 
64