[Home] [Help]
PACKAGE: APPS.BIS_REGION_EXTENSION_PVT
Source
1 PACKAGE BIS_REGION_EXTENSION_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVAKXS.pls 120.0 2005/06/01 15:10:10 appldev noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.0=120.0):~PROD:~PATH:~FILE
5 ----------------------------------------------------------------------------
6 -- PACKAGE: BIS_REGION_EXTENSION_PVT --
7 -- --
8 -- DESCRIPTION: Private package to create records in --
9 -- BIS_AK_REGION_EXTENSION table --
10 -- --
11 -- --
12 -- MODIFICATIONS --
13 -- Date User Modification --
14 -- 02/03/04 nbarik Initial Creation --
15 ----------------------------------------------------------------------------
16
17 PROCEDURE CREATE_REGION_EXTN_RECORD
18 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
19 ,pRegionCode IN VARCHAR2
20 ,pRegionAppId IN NUMBER
21 ,pAttribute16 IN VARCHAR2 DEFAULT NULL
22 ,pAttribute17 IN VARCHAR2 DEFAULT NULL
23 ,pAttribute18 IN VARCHAR2 DEFAULT NULL
24 ,pAttribute19 IN VARCHAR2 DEFAULT NULL
25 ,pAttribute20 IN VARCHAR2 DEFAULT NULL
26 ,pAttribute21 IN VARCHAR2 DEFAULT NULL
27 ,pAttribute22 IN VARCHAR2 DEFAULT NULL
28 ,pAttribute23 IN VARCHAR2 DEFAULT NULL
29 ,pAttribute24 IN VARCHAR2 DEFAULT NULL
30 ,pAttribute25 IN VARCHAR2 DEFAULT NULL
31 ,pAttribute26 IN VARCHAR2 DEFAULT NULL
32 ,pAttribute27 IN VARCHAR2 DEFAULT NULL
33 ,pAttribute28 IN VARCHAR2 DEFAULT NULL
34 ,pAttribute29 IN VARCHAR2 DEFAULT NULL
35 ,pAttribute30 IN VARCHAR2 DEFAULT NULL
36 ,pAttribute31 IN VARCHAR2 DEFAULT NULL
37 ,pAttribute32 IN VARCHAR2 DEFAULT NULL
38 ,pAttribute33 IN VARCHAR2 DEFAULT NULL
39 ,pAttribute34 IN VARCHAR2 DEFAULT NULL
40 ,pAttribute35 IN VARCHAR2 DEFAULT NULL
41 ,pAttribute36 IN VARCHAR2 DEFAULT NULL
42 ,pAttribute37 IN VARCHAR2 DEFAULT NULL
43 ,pAttribute38 IN VARCHAR2 DEFAULT NULL
44 ,pAttribute39 IN VARCHAR2 DEFAULT NULL
45 ,pAttribute40 IN VARCHAR2 DEFAULT NULL
46 );
47
48 PROCEDURE UPDATE_REGION_EXTN_RECORD
49 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
50 ,pRegionCode IN VARCHAR2
51 ,pRegionAppId IN NUMBER
52 ,pAttribute16 IN VARCHAR2 DEFAULT NULL
53 ,pAttribute17 IN VARCHAR2 DEFAULT NULL
54 ,pAttribute18 IN VARCHAR2 DEFAULT NULL
55 ,pAttribute19 IN VARCHAR2 DEFAULT NULL
56 ,pAttribute20 IN VARCHAR2 DEFAULT NULL
57 ,pAttribute21 IN VARCHAR2 DEFAULT NULL
58 ,pAttribute22 IN VARCHAR2 DEFAULT NULL
59 ,pAttribute23 IN VARCHAR2 DEFAULT NULL
60 ,pAttribute24 IN VARCHAR2 DEFAULT NULL
61 ,pAttribute25 IN VARCHAR2 DEFAULT NULL
62 ,pAttribute26 IN VARCHAR2 DEFAULT NULL
63 ,pAttribute27 IN VARCHAR2 DEFAULT NULL
64 ,pAttribute28 IN VARCHAR2 DEFAULT NULL
65 ,pAttribute29 IN VARCHAR2 DEFAULT NULL
66 ,pAttribute30 IN VARCHAR2 DEFAULT NULL
67 ,pAttribute31 IN VARCHAR2 DEFAULT NULL
68 ,pAttribute32 IN VARCHAR2 DEFAULT NULL
69 ,pAttribute33 IN VARCHAR2 DEFAULT NULL
70 ,pAttribute34 IN VARCHAR2 DEFAULT NULL
71 ,pAttribute35 IN VARCHAR2 DEFAULT NULL
72 ,pAttribute36 IN VARCHAR2 DEFAULT NULL
73 ,pAttribute37 IN VARCHAR2 DEFAULT NULL
74 ,pAttribute38 IN VARCHAR2 DEFAULT NULL
75 ,pAttribute39 IN VARCHAR2 DEFAULT NULL
76 ,pAttribute40 IN VARCHAR2 DEFAULT NULL
77 );
78
79
80 PROCEDURE DELETE_REGION_EXTN_RECORD
81 ( p_commit IN VARCHAR2 := FND_API.G_TRUE
82 ,pRegionCode IN VARCHAR2
83 ,pRegionAppId IN NUMBER
84 );
85
86 END BIS_REGION_EXTENSION_PVT;