APPS.GCS_DYNAMIC_UTIL_PKG dependencies on AD_DDL

Line 103: -- Get APPLSYS information. Needed for ad_ddl

99: g_ud8_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
100: g_ud9_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
101: g_ud10_fem_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
102:
103: -- Get APPLSYS information. Needed for ad_ddl
104: IF NOT fnd_installation.get_app_info('FND', status, industry,
105: g_applsys_username) THEN
106: raise gcs_ccy_applsys_not_found;
107: END IF;

Line 115: -- Build one row of the comma or join list in ad_ddl.

111: --
112: -- Procedure
113: -- Build_Dimension_Row
114: -- Purpose
115: -- Build one row of the comma or join list in ad_ddl.
116: --
117: -- Arguments
118: -- p_item The item to write if the dimension is used
119: -- p_def_item The item to write if the dimension is unused

Line 120: -- p_rownum The row number to use for ad_ddl

116: --
117: -- Arguments
118: -- p_item The item to write if the dimension is used
119: -- p_def_item The item to write if the dimension is unused
120: -- p_rownum The row number to use for ad_ddl
121: -- p_dim_req Whether or not the dimension is required
122: -- Example
123: --
124: -- Notes

Line 133: ad_ddl.build_statement(p_item, p_rownum);

129: p_rownum NUMBER,
130: p_dim_req VARCHAR2) RETURN NUMBER IS
131: BEGIN
132: IF p_dim_req = 'Y' THEN
133: ad_ddl.build_statement(p_item, p_rownum);
134: ELSE
135: ad_ddl.build_statement(p_def_item, p_rownum);
136: END IF;
137: RETURN (p_rownum + 1);

Line 135: ad_ddl.build_statement(p_def_item, p_rownum);

131: BEGIN
132: IF p_dim_req = 'Y' THEN
133: ad_ddl.build_statement(p_item, p_rownum);
134: ELSE
135: ad_ddl.build_statement(p_def_item, p_rownum);
136: END IF;
137: RETURN (p_rownum + 1);
138: END Build_Dimension_Row;
139:

Line 144: -- Build one row of the comma or join list in ad_ddl.

140: --
141: -- Procedure
142: -- Build_Fem_Dimension_Row
143: -- Purpose
144: -- Build one row of the comma or join list in ad_ddl.
145: --
146: -- Arguments
147: -- p_item The item to write if the dimension is used
148: -- p_def_item The item to write if the dimension is unused

Line 149: -- p_rownum The row number to use for ad_ddl

145: --
146: -- Arguments
147: -- p_item The item to write if the dimension is used
148: -- p_def_item The item to write if the dimension is unused
149: -- p_rownum The row number to use for ad_ddl
150: -- p_dim_req Whether or not the dimension is required
151: -- Example
152: --
153: -- Notes

Line 162: ad_ddl.build_statement('''' || p_item || '''' || ',', p_rownum);

158: p_rownum NUMBER,
159: p_dim_req VARCHAR2) RETURN NUMBER IS
160: BEGIN
161: IF p_dim_req = 'Y' THEN
162: ad_ddl.build_statement('''' || p_item || '''' || ',', p_rownum);
163: ELSE
164: ad_ddl.build_statement(p_def_item, p_rownum);
165: END IF;
166: RETURN (p_rownum + 1);

Line 164: ad_ddl.build_statement(p_def_item, p_rownum);

160: BEGIN
161: IF p_dim_req = 'Y' THEN
162: ad_ddl.build_statement('''' || p_item || '''' || ',', p_rownum);
163: ELSE
164: ad_ddl.build_statement(p_def_item, p_rownum);
165: END IF;
166: RETURN (p_rownum + 1);
167: END Build_Fem_Dimension_Row;
168: