eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GCS_TEMPLATES_DYNAMIC_PKG dependencies on GCS_UTILITY_PKG

Line 50: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id

46: fem_ext_acct_types_attr fxata
47: WHERE dt.hierarchy_id = p_hierarchy_id
48: AND dt.template_code = 'RE'
49: AND flia.line_item_id = dt.line_item_id
50: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
51: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
52: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
53: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
54: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

Line 51: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

47: WHERE dt.hierarchy_id = p_hierarchy_id
48: AND dt.template_code = 'RE'
49: AND flia.line_item_id = dt.line_item_id
50: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
51: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
52: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
53: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
54: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
55:

Line 53: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id

49: AND flia.line_item_id = dt.line_item_id
50: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
51: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
52: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
53: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
54: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
55:
56: sign_value NUMBER;
57: l_intercompany_id NUMBER(15);

Line 54: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

50: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
51: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
52: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
53: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
54: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
55:
56: sign_value NUMBER;
57: l_intercompany_id NUMBER(15);
58:

Line 69: gcs_utility_pkg.g_module_enter

65: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
66: THEN
67: fnd_log.STRING (fnd_log.level_procedure,
68: g_pkg_name || '.' || l_api_name,
69: gcs_utility_pkg.g_module_enter
70: || ' '
71: || l_api_name
72: || '() '
73: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 165: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||

161: 'WHERE dt.hierarchy_id = ' || p_hierarchy_id || g_nl ||
162: 'AND dt.template_code = ''RE''' || g_nl ||
163: 'AND flia.line_item_id = dt.line_item_id' || g_nl ||
164: 'AND flia.attribute_id = ' ||
165: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
166: 'AND flia.version_id = ' ||
167: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
168: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
169: 'AND fxata.attribute_id = ' ||

Line 167: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||

163: 'AND flia.line_item_id = dt.line_item_id' || g_nl ||
164: 'AND flia.attribute_id = ' ||
165: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
166: 'AND flia.version_id = ' ||
167: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
168: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
169: 'AND fxata.attribute_id = ' ||
170: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
171: 'AND fxata.version_id = ' ||

Line 170: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||

166: 'AND flia.version_id = ' ||
167: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
168: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
169: 'AND fxata.attribute_id = ' ||
170: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
171: 'AND fxata.version_id = ' ||
172: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
173: );
174: END IF;

Line 172: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id

168: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
169: 'AND fxata.attribute_id = ' ||
170: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
171: 'AND fxata.version_id = ' ||
172: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
173: );
174: END IF;
175:
176: -- Get signage information

Line 189: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,

185:
186:
187: IF org_tracking_flag = 'N'
188: THEN
189: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
190: p_hierarchy_id => p_hierarchy_id);
191: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
192: THEN
193: fnd_log.STRING (fnd_log.level_statement,

Line 220: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

216: AND gel_1.entry_id = :2
217: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
218: AND feata.dim_attribute_numeric_member IS NULL
219: AND flia.value_set_id = '
220: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
221: || '
222: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
223: AND flia.attribute_id = '
224: || gcs_utility_pkg.g_dimension_attr_info

Line 224: || gcs_utility_pkg.g_dimension_attr_info

220: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
221: || '
222: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
223: AND flia.attribute_id = '
224: || gcs_utility_pkg.g_dimension_attr_info
225: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
226: || '
227: AND feata.attribute_id = '
228: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 228: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

224: || gcs_utility_pkg.g_dimension_attr_info
225: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
226: || '
227: AND feata.attribute_id = '
228: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
229: || '
230: AND flia.version_id = '
231: || gcs_utility_pkg.g_dimension_attr_info
232: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 231: || gcs_utility_pkg.g_dimension_attr_info

227: AND feata.attribute_id = '
228: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
229: || '
230: AND flia.version_id = '
231: || gcs_utility_pkg.g_dimension_attr_info
232: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
233: || '
234: AND feata.version_id = '
235: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 235: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

231: || gcs_utility_pkg.g_dimension_attr_info
232: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
233: || '
234: AND feata.version_id = '
235: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
236: || '
237: AND gel_1.line_item_id = flia.line_item_id
238: GROUP BY
239: , gel_1.company_cost_center_org_id ) src

Line 300: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

296: AND gel_1.entry_id = :2
297: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
298: AND feata.dim_attribute_numeric_member IS NULL
299: AND flia.value_set_id = '
300: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
301: || '
302: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
303: AND flia.attribute_id = '
304: || gcs_utility_pkg.g_dimension_attr_info

Line 304: || gcs_utility_pkg.g_dimension_attr_info

300: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
301: || '
302: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
303: AND flia.attribute_id = '
304: || gcs_utility_pkg.g_dimension_attr_info
305: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
306: || '
307: AND feata.attribute_id = '
308: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 308: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

304: || gcs_utility_pkg.g_dimension_attr_info
305: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
306: || '
307: AND feata.attribute_id = '
308: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
309: || '
310: AND flia.version_id = '
311: || gcs_utility_pkg.g_dimension_attr_info
312: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 311: || gcs_utility_pkg.g_dimension_attr_info

307: AND feata.attribute_id = '
308: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
309: || '
310: AND flia.version_id = '
311: || gcs_utility_pkg.g_dimension_attr_info
312: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
313: || '
314: AND feata.version_id = '
315: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 315: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

311: || gcs_utility_pkg.g_dimension_attr_info
312: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
313: || '
314: AND feata.version_id = '
315: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
316: || '
317: AND gel_1.line_item_id = flia.line_item_id
318: GROUP BY
319: ) src

Line 380: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

376: AND gel_1.entry_id = :2
377: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
378: AND feata.dim_attribute_numeric_member IS NULL
379: AND flia.value_set_id = '
380: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
381: || '
382: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
383: AND flia.attribute_id = '
384: || gcs_utility_pkg.g_dimension_attr_info

Line 384: || gcs_utility_pkg.g_dimension_attr_info

380: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
381: || '
382: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
383: AND flia.attribute_id = '
384: || gcs_utility_pkg.g_dimension_attr_info
385: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
386: || '
387: AND feata.attribute_id = '
388: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 388: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

384: || gcs_utility_pkg.g_dimension_attr_info
385: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
386: || '
387: AND feata.attribute_id = '
388: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
389: || '
390: AND flia.version_id = '
391: || gcs_utility_pkg.g_dimension_attr_info
392: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 391: || gcs_utility_pkg.g_dimension_attr_info

387: AND feata.attribute_id = '
388: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
389: || '
390: AND flia.version_id = '
391: || gcs_utility_pkg.g_dimension_attr_info
392: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
393: || '
394: AND feata.version_id = '
395: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 395: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

391: || gcs_utility_pkg.g_dimension_attr_info
392: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
393: || '
394: AND feata.version_id = '
395: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
396: || '
397: AND gel_1.line_item_id = flia.line_item_id
398: GROUP BY gel_1.company_cost_center_org_id) src
399: ON ( gel.entry_id = :2

Line 457: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

453: AND gel_1.entry_id = :2
454: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
455: AND feata.dim_attribute_numeric_member IS NULL
456: AND flia.value_set_id = '
457: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
458: || '
459: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
460: AND flia.attribute_id = '
461: || gcs_utility_pkg.g_dimension_attr_info

Line 461: || gcs_utility_pkg.g_dimension_attr_info

457: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
458: || '
459: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
460: AND flia.attribute_id = '
461: || gcs_utility_pkg.g_dimension_attr_info
462: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
463: || '
464: AND feata.attribute_id = '
465: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 465: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

461: || gcs_utility_pkg.g_dimension_attr_info
462: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
463: || '
464: AND feata.attribute_id = '
465: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
466: || '
467: AND flia.version_id = '
468: || gcs_utility_pkg.g_dimension_attr_info
469: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 468: || gcs_utility_pkg.g_dimension_attr_info

464: AND feata.attribute_id = '
465: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
466: || '
467: AND flia.version_id = '
468: || gcs_utility_pkg.g_dimension_attr_info
469: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
470: || '
471: AND feata.version_id = '
472: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 472: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

468: || gcs_utility_pkg.g_dimension_attr_info
469: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
470: || '
471: AND feata.version_id = '
472: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
473: || '
474: AND gel_1.line_item_id = flia.line_item_id
475: GROUP BY ) src
476: ON ( gel.entry_id = :2

Line 526: gcs_utility_pkg.g_module_success

522: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
523: THEN
524: fnd_log.STRING (fnd_log.level_procedure,
525: g_pkg_name || '.' || l_api_name,
526: gcs_utility_pkg.g_module_success
527: || ' '
528: || l_api_name
529: || '() '
530: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 542: gcs_utility_pkg.g_module_failure

538: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
539: THEN
540: fnd_log.STRING (fnd_log.level_procedure,
541: g_pkg_name || '.' || l_api_name,
542: gcs_utility_pkg.g_module_failure
543: || ' '
544: || l_api_name
545: || '() '
546: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 582: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id

578: fem_ext_acct_types_attr fxata
579: WHERE dt.hierarchy_id = p_hierarchy_id
580: AND dt.template_code = 'RE'
581: AND flia.line_item_id = dt.line_item_id
582: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
583: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
584: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
585: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
586: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

Line 583: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

579: WHERE dt.hierarchy_id = p_hierarchy_id
580: AND dt.template_code = 'RE'
581: AND flia.line_item_id = dt.line_item_id
582: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
583: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
584: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
585: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
586: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
587:

Line 585: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id

581: AND flia.line_item_id = dt.line_item_id
582: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
583: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
584: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
585: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
586: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
587:
588: sign_value NUMBER;
589: l_intercompany_id NUMBER(15);

Line 586: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

582: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
583: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
584: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
585: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
586: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
587:
588: sign_value NUMBER;
589: l_intercompany_id NUMBER(15);
590:

Line 665: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||

661: 'WHERE dt.hierarchy_id = ' || p_hierarchy_id || g_nl ||
662: 'AND dt.template_code = ''RE''' || g_nl ||
663: 'AND flia.line_item_id = dt.line_item_id' || g_nl ||
664: 'AND flia.attribute_id = ' ||
665: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
666: 'AND flia.version_id = ' ||
667: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
668: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
669: 'AND fxata.attribute_id = ' ||

Line 667: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||

663: 'AND flia.line_item_id = dt.line_item_id' || g_nl ||
664: 'AND flia.attribute_id = ' ||
665: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
666: 'AND flia.version_id = ' ||
667: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
668: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
669: 'AND fxata.attribute_id = ' ||
670: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id|| g_nl ||
671: 'AND fxata.version_id = ' ||

Line 670: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id|| g_nl ||

666: 'AND flia.version_id = ' ||
667: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
668: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
669: 'AND fxata.attribute_id = ' ||
670: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id|| g_nl ||
671: 'AND fxata.version_id = ' ||
672: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
673: );
674: END IF;

Line 672: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id

668: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
669: 'AND fxata.attribute_id = ' ||
670: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id|| g_nl ||
671: 'AND fxata.version_id = ' ||
672: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
673: );
674: END IF;
675:
676: -- Get signage information

Line 689: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,

685:
686:
687: IF org_tracking_flag = 'N'
688: THEN
689: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
690: p_hierarchy_id => p_hierarchy_id);
691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
692: THEN
693: fnd_log.STRING (fnd_log.level_statement,

Line 724: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

720: AND fb.source_system_code = fssb.source_system_code
721: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
722: AND feata.dim_attribute_numeric_member IS NULL
723: AND flia.value_set_id = '
724: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
725: || '
726: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
727: AND flia.attribute_id = '
728: || gcs_utility_pkg.g_dimension_attr_info

Line 728: || gcs_utility_pkg.g_dimension_attr_info

724: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
725: || '
726: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
727: AND flia.attribute_id = '
728: || gcs_utility_pkg.g_dimension_attr_info
729: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
730: || '
731: AND feata.attribute_id = '
732: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 732: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

728: || gcs_utility_pkg.g_dimension_attr_info
729: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
730: || '
731: AND feata.attribute_id = '
732: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
733: || '
734: AND flia.version_id = '
735: || gcs_utility_pkg.g_dimension_attr_info
736: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 735: || gcs_utility_pkg.g_dimension_attr_info

731: AND feata.attribute_id = '
732: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
733: || '
734: AND flia.version_id = '
735: || gcs_utility_pkg.g_dimension_attr_info
736: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
737: || '
738: AND feata.version_id = '
739: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 739: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

735: || gcs_utility_pkg.g_dimension_attr_info
736: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
737: || '
738: AND feata.version_id = '
739: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
740: || '
741: AND fb.line_item_id = flia.line_item_id
742: GROUP BY
743: , fb.company_cost_center_org_id ) src

Line 809: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

805: AND fb.source_system_code = fssb.source_system_code
806: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
807: AND feata.dim_attribute_numeric_member IS NULL
808: AND flia.value_set_id = '
809: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
810: || '
811: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
812: AND flia.attribute_id = '
813: || gcs_utility_pkg.g_dimension_attr_info

Line 813: || gcs_utility_pkg.g_dimension_attr_info

809: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
810: || '
811: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
812: AND flia.attribute_id = '
813: || gcs_utility_pkg.g_dimension_attr_info
814: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
815: || '
816: AND feata.attribute_id = '
817: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 817: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

813: || gcs_utility_pkg.g_dimension_attr_info
814: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
815: || '
816: AND feata.attribute_id = '
817: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
818: || '
819: AND flia.version_id = '
820: || gcs_utility_pkg.g_dimension_attr_info
821: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 820: || gcs_utility_pkg.g_dimension_attr_info

816: AND feata.attribute_id = '
817: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
818: || '
819: AND flia.version_id = '
820: || gcs_utility_pkg.g_dimension_attr_info
821: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
822: || '
823: AND feata.version_id = '
824: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 824: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

820: || gcs_utility_pkg.g_dimension_attr_info
821: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
822: || '
823: AND feata.version_id = '
824: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
825: || '
826: AND fb.line_item_id = flia.line_item_id
827: GROUP BY
828: ) src

Line 893: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

889: AND fb.source_system_code = fssb.source_system_code
890: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
891: AND feata.dim_attribute_numeric_member IS NULL
892: AND flia.value_set_id = '
893: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
894: || '
895: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
896: AND flia.attribute_id = '
897: || gcs_utility_pkg.g_dimension_attr_info

Line 897: || gcs_utility_pkg.g_dimension_attr_info

893: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
894: || '
895: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
896: AND flia.attribute_id = '
897: || gcs_utility_pkg.g_dimension_attr_info
898: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
899: || '
900: AND feata.attribute_id = '
901: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 901: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

897: || gcs_utility_pkg.g_dimension_attr_info
898: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
899: || '
900: AND feata.attribute_id = '
901: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
902: || '
903: AND flia.version_id = '
904: || gcs_utility_pkg.g_dimension_attr_info
905: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 904: || gcs_utility_pkg.g_dimension_attr_info

900: AND feata.attribute_id = '
901: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
902: || '
903: AND flia.version_id = '
904: || gcs_utility_pkg.g_dimension_attr_info
905: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
906: || '
907: AND feata.version_id = '
908: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 908: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

904: || gcs_utility_pkg.g_dimension_attr_info
905: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
906: || '
907: AND feata.version_id = '
908: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
909: || '
910: AND fb.line_item_id = flia.line_item_id
911: GROUP BY fb.company_cost_center_org_id) src
912: ON ( gel.entry_id = :2

Line 974: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id

970: AND fb.source_system_code = fssb.source_system_code
971: AND feata.dim_attribute_varchar_member IN (''REVENUE'', ''EXPENSE'')
972: AND feata.dim_attribute_numeric_member IS NULL
973: AND flia.value_set_id = '
974: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
975: || '
976: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
977: AND flia.attribute_id = '
978: || gcs_utility_pkg.g_dimension_attr_info

Line 978: || gcs_utility_pkg.g_dimension_attr_info

974: || gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id
975: || '
976: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
977: AND flia.attribute_id = '
978: || gcs_utility_pkg.g_dimension_attr_info
979: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
980: || '
981: AND feata.attribute_id = '
982: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

Line 982: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id

978: || gcs_utility_pkg.g_dimension_attr_info
979: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
980: || '
981: AND feata.attribute_id = '
982: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
983: || '
984: AND flia.version_id = '
985: || gcs_utility_pkg.g_dimension_attr_info
986: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

Line 985: || gcs_utility_pkg.g_dimension_attr_info

981: AND feata.attribute_id = '
982: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id
983: || '
984: AND flia.version_id = '
985: || gcs_utility_pkg.g_dimension_attr_info
986: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
987: || '
988: AND feata.version_id = '
989: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

Line 989: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id

985: || gcs_utility_pkg.g_dimension_attr_info
986: ('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
987: || '
988: AND feata.version_id = '
989: || gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id
990: || '
991: AND fb.line_item_id = flia.line_item_id
992: GROUP BY ) src
993: ON ( gel.entry_id = :2

Line 1048: gcs_utility_pkg.g_module_failure

1044: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1045: THEN
1046: fnd_log.STRING (fnd_log.level_procedure,
1047: g_pkg_name || '.' || l_api_name,
1048: gcs_utility_pkg.g_module_failure
1049: || ' '
1050: || l_api_name
1051: || '() '
1052: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1096: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id

1092: SELECT fxata.number_assign_value
1093: FROM fem_ln_items_attr flia,
1094: fem_ext_acct_types_attr fxata
1095: WHERE flia.line_item_id = p_template.line_item_id
1096: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
1097: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
1098: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1099: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
1100: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

Line 1097: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id

1093: FROM fem_ln_items_attr flia,
1094: fem_ext_acct_types_attr fxata
1095: WHERE flia.line_item_id = p_template.line_item_id
1096: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
1097: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
1098: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1099: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
1100: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
1101:

Line 1099: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id

1095: WHERE flia.line_item_id = p_template.line_item_id
1096: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
1097: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
1098: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1099: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
1100: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
1101:
1102: sign_value NUMBER;
1103: l_intercompany_id NUMBER(15);

Line 1100: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;

1096: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id
1097: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id
1098: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1099: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id
1100: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id;
1101:
1102: sign_value NUMBER;
1103: l_intercompany_id NUMBER(15);
1104: l_category VARCHAR2(50);

Line 1123: gcs_utility_pkg.g_module_enter

1119: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1120: THEN
1121: fnd_log.STRING (fnd_log.level_procedure,
1122: g_pkg_name || '.' || l_api_name,
1123: gcs_utility_pkg.g_module_enter
1124: || ' '
1125: || l_api_name
1126: || '() '
1127: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1232: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||

1228: 'FROM fem_ln_items_attr flia,' || g_nl ||
1229: ' fem_ext_acct_types_attr fxata' || g_nl ||
1230: 'WHERE flia.line_item_id = ' || p_template.line_item_id || g_nl ||
1231: 'AND flia.attribute_id = ' ||
1232: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
1233: 'AND flia.version_id = ' ||
1234: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
1235: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
1236: 'AND fxata.attribute_id = ' ||

Line 1234: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||

1230: 'WHERE flia.line_item_id = ' || p_template.line_item_id || g_nl ||
1231: 'AND flia.attribute_id = ' ||
1232: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || g_nl ||
1233: 'AND flia.version_id = ' ||
1234: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
1235: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
1236: 'AND fxata.attribute_id = ' ||
1237: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
1238: 'AND fxata.version_id = ' ||

Line 1237: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||

1233: 'AND flia.version_id = ' ||
1234: GCS_UTILITY_PKG.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || g_nl ||
1235: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
1236: 'AND fxata.attribute_id = ' ||
1237: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
1238: 'AND fxata.version_id = ' ||
1239: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
1240: );
1241: END IF;

Line 1239: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id

1235: 'AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member' || g_nl ||
1236: 'AND fxata.attribute_id = ' ||
1237: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').attribute_id || g_nl ||
1238: 'AND fxata.version_id = ' ||
1239: GCS_UTILITY_PKG.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-SIGN').version_id
1240: );
1241: END IF;
1242:
1243: -- Get signage information

Line 1274: GCS_UTILITY_PKG.Get_Conversion_Rate

1270: where entry_id = p_entry_id;
1271:
1272: IF l_currency_code <> p_threshold_currency_code THEN
1273:
1274: GCS_UTILITY_PKG.Get_Conversion_Rate
1275: (p_source_currency => p_threshold_currency_code,
1276: p_target_currency => l_currency_code,
1277: p_cal_period_id => l_cal_period_id,
1278: p_conversion_rate => l_corp_rate,

Line 1297: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,

1293:
1294:
1295: IF org_tracking_flag = 'N'
1296: THEN
1297: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
1298: p_hierarchy_id => p_hierarchy_id);
1299: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1300: THEN
1301: fnd_log.STRING (fnd_log.level_statement,

Line 1701: gcs_utility_pkg.g_module_success

1697: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1698: THEN
1699: fnd_log.STRING (fnd_log.level_procedure,
1700: g_pkg_name || '.' || l_api_name,
1701: gcs_utility_pkg.g_module_success
1702: || ' '
1703: || l_api_name
1704: || '() '
1705: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1719: gcs_utility_pkg.g_module_failure

1715: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1716: THEN
1717: fnd_log.STRING (fnd_log.level_procedure,
1718: g_pkg_name || '.' || l_api_name,
1719: gcs_utility_pkg.g_module_failure
1720: || ' '
1721: || l_api_name
1722: || '() '
1723: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1736: gcs_utility_pkg.g_module_failure

1732: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1733: THEN
1734: fnd_log.STRING (fnd_log.level_procedure,
1735: g_pkg_name || '.' || l_api_name,
1736: gcs_utility_pkg.g_module_failure
1737: || ' '
1738: || l_api_name
1739: || '() '
1740: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1753: gcs_utility_pkg.g_module_failure

1749: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1750: THEN
1751: fnd_log.STRING (fnd_log.level_procedure,
1752: g_pkg_name || '.' || l_api_name,
1753: gcs_utility_pkg.g_module_failure
1754: || ' '
1755: || l_api_name
1756: || '() '
1757: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')