[Home] [Help]
PACKAGE: APPS.PSP_TEMPLATE_DETAILS_API
Source
1 Package PSP_TEMPLATE_DETAILS_API as
2 /* $Header: PSPRDAIS.pls 120.0 2005/06/02 15:56:46 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------- Create_TEMPLATE_DETAILS --------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 --
33 -- ----------------------------------------------------------------------------
34 -- |--------------------------< Create_TEMPLATE_DETAILS >--------------------------|
35 -- ----------------------------------------------------------------------------
36 --
37 procedure Create_TEMPLATE_DETAILS
38 ( P_VALIDATE in boolean default false
39 , P_TEMPLATE_ID in NUMBER
40 , P_CRITERIA_LOOKUP_TYPE in VARCHAR2
41 , P_CRITERIA_LOOKUP_CODE in VARCHAR2
42 , P_INCLUDE_EXCLUDE_FLAG in VARCHAR2
43 , P_CRITERIA_VALUE1 in VARCHAR2
44 , P_CRITERIA_VALUE2 in VARCHAR2
45 , P_CRITERIA_VALUE3 in VARCHAR2
46 , P_TEMPLATE_DETAIL_ID in NUMBER
47 , P_OBJECT_VERSION_NUMBER out nocopy NUMBER
48 , P_WARNING out nocopy boolean
49 , P_RETURN_STATUS out nocopy boolean
50 );
51 --
52 -- ----------------------------------------------------------------------------
53 -- |--------------------------< Update_TEMPLATE_DETAILS >--------------------------|
54 -- ----------------------------------------------------------------------------
55 --
56 procedure Update_TEMPLATE_DETAILS
57 (P_VALIDATE in boolean default false
58 , P_TEMPLATE_ID in NUMBER
59 , P_CRITERIA_LOOKUP_TYPE in VARCHAR2
60 , P_CRITERIA_LOOKUP_CODE in VARCHAR2
61 , P_INCLUDE_EXCLUDE_FLAG in VARCHAR2
62 , P_CRITERIA_VALUE1 in VARCHAR2
63 , P_CRITERIA_VALUE2 in VARCHAR2
64 , P_CRITERIA_VALUE3 in VARCHAR2
65 , P_TEMPLATE_DETAIL_ID in out nocopy NUMBER
66 , P_OBJECT_VERSION_NUMBER in out nocopy NUMBER
67 , P_WARNING out nocopy boolean
68 , P_RETURN_STATUS out nocopy boolean
69 );
70 --
71 -- ----------------------------------------------------------------------------
72 -- |--------------------------< DELETE_TEMPLATE_DETAILS >--------------------------|
73 -- ----------------------------------------------------------------------------
74 --
75 procedure DELETE_TEMPLATE_DETAILS
76 (P_VALIDATE in BOOLEAN default false
77 , P_TEMPLATE_DETAIL_ID in NUMBER
78 ,P_OBJECT_VERSION_NUMBER in out nocopy number
79 ,P_WARNING out nocopy varchar2
80 );
81 end PSP_TEMPLATE_DETAILS_API;