[Home] [Help]
PACKAGE BODY: APPS.EAM_CFR_UTIL_PVT
Source
1 PACKAGE BODY EAM_CFR_UTIL_PVT AS
2 /* $Header: EAMVCFRB.pls 120.1 2006/09/01 06:34:32 smrsharm noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVCFRB.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Body of package EAM_CFR_UTIL_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 29-AUGUST-2006 Smriti Sharma Initial Creation
21 ***************************************************************************/
22
23
24 G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_CFR_UTIL_PVT';
25 PROCEDURE GET_DESC_FLEX_ALL_PROMPTS(P_APPLICATION_ID IN VARCHAR2,
26 P_DESC_FLEX_DEF_NAME IN VARCHAR2,
27 P_DESC_FLEX_CONTEXT IN VARCHAR2,
28 P_PROMPT_TYPE IN VARCHAR2,
29 P_COLUMN1_NAME IN VARCHAR2,
30 P_COLUMN2_NAME IN VARCHAR2,
31 P_COLUMN3_NAME IN VARCHAR2,
32 P_COLUMN4_NAME IN VARCHAR2,
33 P_COLUMN5_NAME IN VARCHAR2,
34 P_COLUMN6_NAME IN VARCHAR2,
35 P_COLUMN7_NAME IN VARCHAR2,
36 P_COLUMN8_NAME IN VARCHAR2,
37 P_COLUMN9_NAME IN VARCHAR2,
38 P_COLUMN10_NAME IN VARCHAR2,
39 P_COLUMN11_NAME IN VARCHAR2,
40 P_COLUMN12_NAME IN VARCHAR2,
41 P_COLUMN13_NAME IN VARCHAR2,
42 P_COLUMN14_NAME IN VARCHAR2,
43 P_COLUMN15_NAME IN VARCHAR2,
44 P_COLUMN1_PROMPT out nocopy VARCHAR2,
45 P_COLUMN2_PROMPT out nocopy VARCHAR2,
46 P_COLUMN3_PROMPT out nocopy VARCHAR2,
47 P_COLUMN4_PROMPT out nocopy VARCHAR2,
48 P_COLUMN5_PROMPT out nocopy VARCHAR2,
49 P_COLUMN6_PROMPT out nocopy VARCHAR2,
50 P_COLUMN7_PROMPT out nocopy VARCHAR2,
51 P_COLUMN8_PROMPT out nocopy VARCHAR2,
52 P_COLUMN9_PROMPT out nocopy VARCHAR2,
53 P_COLUMN10_PROMPT out nocopy VARCHAR2,
54 P_COLUMN11_PROMPT out nocopy VARCHAR2,
55 P_COLUMN12_PROMPT out nocopy VARCHAR2,
56 P_COLUMN13_PROMPT out nocopy VARCHAR2,
57 P_COLUMN14_PROMPT out nocopy VARCHAR2,
58 P_COLUMN15_PROMPT out nocopy VARCHAR2
59 ) AS
60
61 L_PROMPT16 VARCHAR2(255);
62 L_PROMPT17 VARCHAR2(255);
63 L_PROMPT18 VARCHAR2(255);
64 L_PROMPT19 VARCHAR2(255);
65 L_PROMPT20 VARCHAR2(255);
66 L_PROMPT21 VARCHAR2(255);
67 L_PROMPT22 VARCHAR2(255);
68 L_PROMPT23 VARCHAR2(255);
69 L_PROMPT24 VARCHAR2(255);
70 L_PROMPT25 VARCHAR2(255);
71 L_PROMPT26 VARCHAR2(255);
72 L_PROMPT27 VARCHAR2(255);
73 L_PROMPT28 VARCHAR2(255);
74 L_PROMPT29 VARCHAR2(255);
75 L_PROMPT30 VARCHAR2(255);
76
77 BEGIN
78 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','In the get_desc_flex_all_prompts procedure');
79
80 EDR_STANDARD.GET_DESC_FLEX_ALL_PROMPTS(
81 P_APPLICATION_ID => P_APPLICATION_ID,
82 P_DESC_FLEX_DEF_NAME => P_DESC_FLEX_DEF_NAME,
83 P_DESC_FLEX_CONTEXT => P_DESC_FLEX_CONTEXT,
84 P_PROMPT_TYPE => P_PROMPT_TYPE,
85 P_COLUMN1_NAME => P_COLUMN1_NAME,
86 P_COLUMN2_NAME => P_COLUMN2_NAME,
87 P_COLUMN3_NAME => P_COLUMN3_NAME,
88 P_COLUMN4_NAME => P_COLUMN4_NAME,
89 P_COLUMN5_NAME => P_COLUMN5_NAME,
90 P_COLUMN6_NAME => P_COLUMN6_NAME,
91 P_COLUMN7_NAME => P_COLUMN7_NAME,
92 P_COLUMN8_NAME => P_COLUMN8_NAME,
93 P_COLUMN9_NAME => P_COLUMN9_NAME,
94 P_COLUMN10_NAME => P_COLUMN10_NAME,
95 P_COLUMN11_NAME => P_COLUMN11_NAME,
96 P_COLUMN12_NAME => P_COLUMN12_NAME,
97 P_COLUMN13_NAME => P_COLUMN13_NAME,
98 P_COLUMN14_NAME => P_COLUMN14_NAME,
99 P_COLUMN15_NAME => P_COLUMN15_NAME,
100 P_COLUMN1_PROMPT => P_COLUMN1_PROMPT,
101 P_COLUMN2_PROMPT => P_COLUMN2_PROMPT,
102 P_COLUMN3_PROMPT => P_COLUMN3_PROMPT,
103 P_COLUMN4_PROMPT => P_COLUMN4_PROMPT,
104 P_COLUMN5_PROMPT => P_COLUMN5_PROMPT,
105 P_COLUMN6_PROMPT => P_COLUMN6_PROMPT,
106 P_COLUMN7_PROMPT => P_COLUMN7_PROMPT,
107 P_COLUMN8_PROMPT => P_COLUMN8_PROMPT,
108 P_COLUMN9_PROMPT => P_COLUMN9_PROMPT,
109 P_COLUMN10_PROMPT => P_COLUMN10_PROMPT,
110 P_COLUMN11_PROMPT => P_COLUMN11_PROMPT,
111 P_COLUMN12_PROMPT => P_COLUMN12_PROMPT,
112 P_COLUMN13_PROMPT => P_COLUMN13_PROMPT,
113 P_COLUMN14_PROMPT => P_COLUMN14_PROMPT,
114 P_COLUMN15_PROMPT => P_COLUMN15_PROMPT,
115 P_COLUMN16_PROMPT => L_PROMPT16,
116 P_COLUMN17_PROMPT => L_PROMPT17,
117 P_COLUMN18_PROMPT => L_PROMPT18,
118 P_COLUMN19_PROMPT => L_PROMPT19,
119 P_COLUMN20_PROMPT => L_PROMPT20,
120 P_COLUMN21_PROMPT => L_PROMPT21,
121 P_COLUMN22_PROMPT => L_PROMPT22,
122 P_COLUMN23_PROMPT => L_PROMPT23,
123 P_COLUMN24_PROMPT => L_PROMPT24,
124 P_COLUMN25_PROMPT => L_PROMPT25,
125 P_COLUMN26_PROMPT => L_PROMPT26,
126 P_COLUMN27_PROMPT => L_PROMPT27,
127 P_COLUMN28_PROMPT => L_PROMPT28,
128 P_COLUMN29_PROMPT => L_PROMPT29,
129 P_COLUMN30_PROMPT => L_PROMPT30);
130
131 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
132 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
133 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
134 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
135 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
136 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
137 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
138 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
139 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
140 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);
141 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt11 '||P_COLUMN11_PROMPT);
142 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt12 '||P_COLUMN12_PROMPT);
143 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt13 '||P_COLUMN13_PROMPT);
144 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt14 '||P_COLUMN14_PROMPT);
145 wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt15 '||P_COLUMN15_PROMPT);
146
147 END GET_DESC_FLEX_ALL_PROMPTS;
148
149 END EAM_CFR_UTIL_PVT;
150