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.

APPS.GCS_TEMPLATES_PKG dependencies on GCS_UTILITY_PKG

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

89: fem_ext_acct_types_attr fxata
90: WHERE dt.hierarchy_id = p_hierarchy_id
91: AND dt.template_code = ''RE''
92: AND flia.line_item_id = dt.line_item_id
93: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
94: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
95: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
96: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
97: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

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

90: WHERE dt.hierarchy_id = p_hierarchy_id
91: AND dt.template_code = ''RE''
92: AND flia.line_item_id = dt.line_item_id
93: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
94: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
95: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
96: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
97: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
98:

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

92: AND flia.line_item_id = dt.line_item_id
93: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
94: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
95: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
96: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
97: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
98:
99: sign_value NUMBER;
100: l_intercompany_id NUMBER(15);

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

93: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
94: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
95: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
96: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
97: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
98:
99: sign_value NUMBER;
100: l_intercompany_id NUMBER(15);
101:

Line 112: gcs_utility_pkg.g_module_enter

108: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
109: THEN
110: fnd_log.STRING (fnd_log.level_procedure,
111: g_pkg_name || ''.'' || l_api_name,
112: gcs_utility_pkg.g_module_enter
113: || '' ''
114: || l_api_name
115: || ''() ''
116: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

204: ''WHERE dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
205: ''AND dt.template_code = ''''RE'''''' || g_nl ||
206: ''AND flia.line_item_id = dt.line_item_id'' || g_nl ||
207: ''AND flia.attribute_id = '' ||
208: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
209: ''AND flia.version_id = '' ||
210: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
211: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
212: ''AND fxata.attribute_id = '' ||

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

206: ''AND flia.line_item_id = dt.line_item_id'' || g_nl ||
207: ''AND flia.attribute_id = '' ||
208: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
209: ''AND flia.version_id = '' ||
210: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
211: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
212: ''AND fxata.attribute_id = '' ||
213: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
214: ''AND fxata.version_id = '' ||

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

209: ''AND flia.version_id = '' ||
210: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
211: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
212: ''AND fxata.attribute_id = '' ||
213: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
214: ''AND fxata.version_id = '' ||
215: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
216: );
217: END IF;

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

211: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
212: ''AND fxata.attribute_id = '' ||
213: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
214: ''AND fxata.version_id = '' ||
215: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
216: );
217: END IF;
218:
219: -- Get signage information

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

228:
229:
230: IF org_tracking_flag = ''N''
231: THEN
232: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
233: p_hierarchy_id => p_hierarchy_id);
234: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
235: THEN
236: fnd_log.STRING (fnd_log.level_statement,

Line 255: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;

251: lines);
252: curr_index := curr_index + 200;
253: END LOOP;
254:
255: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
256:
257: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST)
258: LOOP
259: IF ( l_index_column_name <> 'ENTITY_ID'

Line 257: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST)

253: END LOOP;
254:
255: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.FIRST;
256:
257: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST)
258: LOOP
259: IF ( l_index_column_name <> 'ENTITY_ID'
260: AND gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs =
261: 'Y'

Line 260: AND gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs =

256:
257: WHILE (l_index_column_name <= gcs_utility_pkg.g_gcs_dimension_info.LAST)
258: LOOP
259: IF ( l_index_column_name <> 'ENTITY_ID'
260: AND gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).required_for_gcs =
261: 'Y'
262: )
263: THEN
264: l_gel_dims_text :=

Line 321: gcs_utility_pkg.g_gcs_dimension_info.NEXT (l_index_column_name);

317:
318: END IF;
319:
320: l_index_column_name :=
321: gcs_utility_pkg.g_gcs_dimension_info.NEXT (l_index_column_name);
322: END LOOP;
323:
324: --Bugfix 6072367: Added check for line type code as calculated
325: l_equal_text := l_equal_text || ' AND gel.line_type_code = ''''CALCULATED'''' ';

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

344: AND gel_1.entry_id = :2
345: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
346: AND feata.dim_attribute_numeric_member IS NULL
347: AND flia.value_set_id = ''
348: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
349: || ''
350: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
351: AND flia.attribute_id = ''
352: || gcs_utility_pkg.g_dimension_attr_info

Line 352: || gcs_utility_pkg.g_dimension_attr_info

348: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
349: || ''
350: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
351: AND flia.attribute_id = ''
352: || gcs_utility_pkg.g_dimension_attr_info
353: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
354: || ''
355: AND feata.attribute_id = ''
356: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

352: || gcs_utility_pkg.g_dimension_attr_info
353: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
354: || ''
355: AND feata.attribute_id = ''
356: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
357: || ''
358: AND flia.version_id = ''
359: || gcs_utility_pkg.g_dimension_attr_info
360: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 359: || gcs_utility_pkg.g_dimension_attr_info

355: AND feata.attribute_id = ''
356: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
357: || ''
358: AND flia.version_id = ''
359: || gcs_utility_pkg.g_dimension_attr_info
360: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
361: || ''
362: AND feata.version_id = ''
363: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

359: || gcs_utility_pkg.g_dimension_attr_info
360: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
361: || ''
362: AND feata.version_id = ''
363: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
364: || ''
365: AND gel_1.line_item_id = flia.line_item_id
366: GROUP BY
367: ' ||l_decode_group_text

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

431: AND gel_1.entry_id = :2
432: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
433: AND feata.dim_attribute_numeric_member IS NULL
434: AND flia.value_set_id = ''
435: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
436: || ''
437: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
438: AND flia.attribute_id = ''
439: || gcs_utility_pkg.g_dimension_attr_info

Line 439: || gcs_utility_pkg.g_dimension_attr_info

435: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
436: || ''
437: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
438: AND flia.attribute_id = ''
439: || gcs_utility_pkg.g_dimension_attr_info
440: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
441: || ''
442: AND feata.attribute_id = ''
443: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

439: || gcs_utility_pkg.g_dimension_attr_info
440: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
441: || ''
442: AND feata.attribute_id = ''
443: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
444: || ''
445: AND flia.version_id = ''
446: || gcs_utility_pkg.g_dimension_attr_info
447: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 446: || gcs_utility_pkg.g_dimension_attr_info

442: AND feata.attribute_id = ''
443: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
444: || ''
445: AND flia.version_id = ''
446: || gcs_utility_pkg.g_dimension_attr_info
447: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
448: || ''
449: AND feata.version_id = ''
450: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

446: || gcs_utility_pkg.g_dimension_attr_info
447: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
448: || ''
449: AND feata.version_id = ''
450: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
451: || ''
452: AND gel_1.line_item_id = flia.line_item_id
453: GROUP BY
454: ' ||l_decode_group_text

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

517: AND gel_1.entry_id = :2
518: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
519: AND feata.dim_attribute_numeric_member IS NULL
520: AND flia.value_set_id = ''
521: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
522: || ''
523: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
524: AND flia.attribute_id = ''
525: || gcs_utility_pkg.g_dimension_attr_info

Line 525: || gcs_utility_pkg.g_dimension_attr_info

521: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
522: || ''
523: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
524: AND flia.attribute_id = ''
525: || gcs_utility_pkg.g_dimension_attr_info
526: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
527: || ''
528: AND feata.attribute_id = ''
529: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

525: || gcs_utility_pkg.g_dimension_attr_info
526: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
527: || ''
528: AND feata.attribute_id = ''
529: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
530: || ''
531: AND flia.version_id = ''
532: || gcs_utility_pkg.g_dimension_attr_info
533: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 532: || gcs_utility_pkg.g_dimension_attr_info

528: AND feata.attribute_id = ''
529: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
530: || ''
531: AND flia.version_id = ''
532: || gcs_utility_pkg.g_dimension_attr_info
533: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
534: || ''
535: AND feata.version_id = ''
536: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

532: || gcs_utility_pkg.g_dimension_attr_info
533: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
534: || ''
535: AND feata.version_id = ''
536: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
537: || ''
538: AND gel_1.line_item_id = flia.line_item_id
539: GROUP BY '||l_gdt_dims_text||'gel_1.company_cost_center_org_id) src
540: ON ( gel.entry_id = :2

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

596: AND gel_1.entry_id = :2
597: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
598: AND feata.dim_attribute_numeric_member IS NULL
599: AND flia.value_set_id = ''
600: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
601: || ''
602: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
603: AND flia.attribute_id = ''
604: || gcs_utility_pkg.g_dimension_attr_info

Line 604: || gcs_utility_pkg.g_dimension_attr_info

600: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
601: || ''
602: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
603: AND flia.attribute_id = ''
604: || gcs_utility_pkg.g_dimension_attr_info
605: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
606: || ''
607: AND feata.attribute_id = ''
608: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

604: || gcs_utility_pkg.g_dimension_attr_info
605: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
606: || ''
607: AND feata.attribute_id = ''
608: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
609: || ''
610: AND flia.version_id = ''
611: || gcs_utility_pkg.g_dimension_attr_info
612: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 611: || gcs_utility_pkg.g_dimension_attr_info

607: AND feata.attribute_id = ''
608: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
609: || ''
610: AND flia.version_id = ''
611: || gcs_utility_pkg.g_dimension_attr_info
612: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
613: || ''
614: AND feata.version_id = ''
615: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

611: || gcs_utility_pkg.g_dimension_attr_info
612: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
613: || ''
614: AND feata.version_id = ''
615: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
616: || ''
617: AND gel_1.line_item_id = flia.line_item_id
618: GROUP BY '||SUBSTR(l_gdt_dims_text, 0, LENGTH(l_gdt_dims_text)-2)||') src
619: ON ( gel.entry_id = :2

Line 671: gcs_utility_pkg.g_module_success

667: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
668: THEN
669: fnd_log.STRING (fnd_log.level_procedure,
670: g_pkg_name || ''.'' || l_api_name,
671: gcs_utility_pkg.g_module_success
672: || '' ''
673: || l_api_name
674: || ''() ''
675: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 687: gcs_utility_pkg.g_module_failure

683: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
684: THEN
685: fnd_log.STRING (fnd_log.level_procedure,
686: g_pkg_name || ''.'' || l_api_name,
687: gcs_utility_pkg.g_module_failure
688: || '' ''
689: || l_api_name
690: || ''() ''
691: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

735: fem_ext_acct_types_attr fxata
736: WHERE dt.hierarchy_id = p_hierarchy_id
737: AND dt.template_code = ''RE''
738: AND flia.line_item_id = dt.line_item_id
739: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
740: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
741: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
742: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
743: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

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

736: WHERE dt.hierarchy_id = p_hierarchy_id
737: AND dt.template_code = ''RE''
738: AND flia.line_item_id = dt.line_item_id
739: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
740: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
741: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
742: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
743: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
744:

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

738: AND flia.line_item_id = dt.line_item_id
739: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
740: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
741: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
742: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
743: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
744:
745: sign_value NUMBER;
746: l_intercompany_id NUMBER(15);

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

739: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
740: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
741: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
742: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
743: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
744:
745: sign_value NUMBER;
746: l_intercompany_id NUMBER(15);
747:

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

818: ''WHERE dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
819: ''AND dt.template_code = ''''RE'''''' || g_nl ||
820: ''AND flia.line_item_id = dt.line_item_id'' || g_nl ||
821: ''AND flia.attribute_id = '' ||
822: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
823: ''AND flia.version_id = '' ||
824: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
825: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
826: ''AND fxata.attribute_id = '' ||

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

820: ''AND flia.line_item_id = dt.line_item_id'' || g_nl ||
821: ''AND flia.attribute_id = '' ||
822: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
823: ''AND flia.version_id = '' ||
824: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
825: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
826: ''AND fxata.attribute_id = '' ||
827: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id|| g_nl ||
828: ''AND fxata.version_id = '' ||

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

823: ''AND flia.version_id = '' ||
824: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
825: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
826: ''AND fxata.attribute_id = '' ||
827: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id|| g_nl ||
828: ''AND fxata.version_id = '' ||
829: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
830: );
831: END IF;

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

825: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
826: ''AND fxata.attribute_id = '' ||
827: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id|| g_nl ||
828: ''AND fxata.version_id = '' ||
829: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
830: );
831: END IF;
832:
833: -- Get signage information

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

842:
843:
844: IF org_tracking_flag = ''N''
845: THEN
846: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
847: p_hierarchy_id => p_hierarchy_id);
848: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
849: THEN
850: fnd_log.STRING (fnd_log.level_statement,

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

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

Line 899: || gcs_utility_pkg.g_dimension_attr_info

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

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

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

Line 906: || gcs_utility_pkg.g_dimension_attr_info

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

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

906: || gcs_utility_pkg.g_dimension_attr_info
907: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
908: || ''
909: AND feata.version_id = ''
910: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
911: || ''
912: AND fb.line_item_id = flia.line_item_id
913: GROUP BY
914: ' ||l_decode_group_text

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

983: AND fb.source_system_code = fssb.source_system_code
984: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
985: AND feata.dim_attribute_numeric_member IS NULL
986: AND flia.value_set_id = ''
987: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
988: || ''
989: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
990: AND flia.attribute_id = ''
991: || gcs_utility_pkg.g_dimension_attr_info

Line 991: || gcs_utility_pkg.g_dimension_attr_info

987: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
988: || ''
989: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
990: AND flia.attribute_id = ''
991: || gcs_utility_pkg.g_dimension_attr_info
992: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
993: || ''
994: AND feata.attribute_id = ''
995: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

991: || gcs_utility_pkg.g_dimension_attr_info
992: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
993: || ''
994: AND feata.attribute_id = ''
995: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
996: || ''
997: AND flia.version_id = ''
998: || gcs_utility_pkg.g_dimension_attr_info
999: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 998: || gcs_utility_pkg.g_dimension_attr_info

994: AND feata.attribute_id = ''
995: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
996: || ''
997: AND flia.version_id = ''
998: || gcs_utility_pkg.g_dimension_attr_info
999: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1000: || ''
1001: AND feata.version_id = ''
1002: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

998: || gcs_utility_pkg.g_dimension_attr_info
999: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1000: || ''
1001: AND feata.version_id = ''
1002: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
1003: || ''
1004: AND fb.line_item_id = flia.line_item_id
1005: GROUP BY
1006: ' ||l_decode_group_text

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

1073: AND fb.source_system_code = fssb.source_system_code
1074: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
1075: AND feata.dim_attribute_numeric_member IS NULL
1076: AND flia.value_set_id = ''
1077: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
1078: || ''
1079: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
1080: AND flia.attribute_id = ''
1081: || gcs_utility_pkg.g_dimension_attr_info

Line 1081: || gcs_utility_pkg.g_dimension_attr_info

1077: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
1078: || ''
1079: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
1080: AND flia.attribute_id = ''
1081: || gcs_utility_pkg.g_dimension_attr_info
1082: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1083: || ''
1084: AND feata.attribute_id = ''
1085: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

1081: || gcs_utility_pkg.g_dimension_attr_info
1082: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1083: || ''
1084: AND feata.attribute_id = ''
1085: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
1086: || ''
1087: AND flia.version_id = ''
1088: || gcs_utility_pkg.g_dimension_attr_info
1089: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 1088: || gcs_utility_pkg.g_dimension_attr_info

1084: AND feata.attribute_id = ''
1085: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
1086: || ''
1087: AND flia.version_id = ''
1088: || gcs_utility_pkg.g_dimension_attr_info
1089: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1090: || ''
1091: AND feata.version_id = ''
1092: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

1088: || gcs_utility_pkg.g_dimension_attr_info
1089: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1090: || ''
1091: AND feata.version_id = ''
1092: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
1093: || ''
1094: AND fb.line_item_id = flia.line_item_id
1095: GROUP BY '||l_gdt_dims_text||'fb.company_cost_center_org_id) src
1096: ON ( gel.entry_id = :2

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

1156: AND fb.source_system_code = fssb.source_system_code
1157: AND feata.dim_attribute_varchar_member IN (''''REVENUE'''', ''''EXPENSE'''')
1158: AND feata.dim_attribute_numeric_member IS NULL
1159: AND flia.value_set_id = ''
1160: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
1161: || ''
1162: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
1163: AND flia.attribute_id = ''
1164: || gcs_utility_pkg.g_dimension_attr_info

Line 1164: || gcs_utility_pkg.g_dimension_attr_info

1160: || gcs_utility_pkg.g_gcs_dimension_info (''LINE_ITEM_ID'').associated_value_set_id
1161: || ''
1162: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
1163: AND flia.attribute_id = ''
1164: || gcs_utility_pkg.g_dimension_attr_info
1165: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1166: || ''
1167: AND feata.attribute_id = ''
1168: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id

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

1164: || gcs_utility_pkg.g_dimension_attr_info
1165: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1166: || ''
1167: AND feata.attribute_id = ''
1168: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
1169: || ''
1170: AND flia.version_id = ''
1171: || gcs_utility_pkg.g_dimension_attr_info
1172: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id

Line 1171: || gcs_utility_pkg.g_dimension_attr_info

1167: AND feata.attribute_id = ''
1168: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').attribute_id
1169: || ''
1170: AND flia.version_id = ''
1171: || gcs_utility_pkg.g_dimension_attr_info
1172: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1173: || ''
1174: AND feata.version_id = ''
1175: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id

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

1171: || gcs_utility_pkg.g_dimension_attr_info
1172: (''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1173: || ''
1174: AND feata.version_id = ''
1175: || gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id
1176: || ''
1177: AND fb.line_item_id = flia.line_item_id
1178: GROUP BY '||SUBSTR(l_gdt_dims_text, 0, LENGTH(l_gdt_dims_text)-2)||') src
1179: ON ( gel.entry_id = :2

Line 1236: gcs_utility_pkg.g_module_failure

1232: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1233: THEN
1234: fnd_log.STRING (fnd_log.level_procedure,
1235: g_pkg_name || ''.'' || l_api_name,
1236: gcs_utility_pkg.g_module_failure
1237: || '' ''
1238: || l_api_name
1239: || ''() ''
1240: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

1293: SELECT fxata.number_assign_value
1294: FROM fem_ln_items_attr flia,
1295: fem_ext_acct_types_attr fxata
1296: WHERE flia.line_item_id = p_template.line_item_id
1297: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1298: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1299: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1300: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
1301: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;

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

1294: FROM fem_ln_items_attr flia,
1295: fem_ext_acct_types_attr fxata
1296: WHERE flia.line_item_id = p_template.line_item_id
1297: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1298: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1299: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1300: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
1301: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
1302:

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

1296: WHERE flia.line_item_id = p_template.line_item_id
1297: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1298: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1299: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1300: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
1301: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
1302:
1303: sign_value NUMBER;
1304: l_intercompany_id NUMBER(15);

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

1297: AND flia.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id
1298: AND flia.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id
1299: AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member
1300: AND fxata.attribute_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id
1301: AND fxata.version_id = GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id;
1302:
1303: sign_value NUMBER;
1304: l_intercompany_id NUMBER(15);
1305: l_category VARCHAR2(50);

Line 1324: gcs_utility_pkg.g_module_enter

1320: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1321: THEN
1322: fnd_log.STRING (fnd_log.level_procedure,
1323: g_pkg_name || ''.'' || l_api_name,
1324: gcs_utility_pkg.g_module_enter
1325: || '' ''
1326: || l_api_name
1327: || ''() ''
1328: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

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

1429: ''FROM fem_ln_items_attr flia,'' || g_nl ||
1430: '' fem_ext_acct_types_attr fxata'' || g_nl ||
1431: ''WHERE flia.line_item_id = '' || p_template.line_item_id || g_nl ||
1432: ''AND flia.attribute_id = '' ||
1433: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
1434: ''AND flia.version_id = '' ||
1435: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
1436: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
1437: ''AND fxata.attribute_id = '' ||

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

1431: ''WHERE flia.line_item_id = '' || p_template.line_item_id || g_nl ||
1432: ''AND flia.attribute_id = '' ||
1433: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').attribute_id || g_nl ||
1434: ''AND flia.version_id = '' ||
1435: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
1436: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
1437: ''AND fxata.attribute_id = '' ||
1438: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
1439: ''AND fxata.version_id = '' ||

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

1434: ''AND flia.version_id = '' ||
1435: GCS_UTILITY_PKG.g_dimension_attr_info(''LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE'').version_id || g_nl ||
1436: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
1437: ''AND fxata.attribute_id = '' ||
1438: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
1439: ''AND fxata.version_id = '' ||
1440: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
1441: );
1442: END IF;

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

1436: ''AND fxata.ext_account_type_code = flia.dim_attribute_varchar_member'' || g_nl ||
1437: ''AND fxata.attribute_id = '' ||
1438: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').attribute_id || g_nl ||
1439: ''AND fxata.version_id = '' ||
1440: GCS_UTILITY_PKG.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-SIGN'').version_id
1441: );
1442: END IF;
1443:
1444: -- Get signage information

Line 1475: GCS_UTILITY_PKG.Get_Conversion_Rate

1471: where entry_id = p_entry_id;
1472:
1473: IF l_currency_code <> p_threshold_currency_code THEN
1474:
1475: GCS_UTILITY_PKG.Get_Conversion_Rate
1476: (p_source_currency => p_threshold_currency_code,
1477: p_target_currency => l_currency_code,
1478: p_cal_period_id => l_cal_period_id,
1479: p_conversion_rate => l_corp_rate,

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

1494:
1495:
1496: IF org_tracking_flag = ''N''
1497: THEN
1498: l_org_id := gcs_utility_pkg.Get_Org_Id(p_entity_id => p_entity_id,
1499: p_hierarchy_id => p_hierarchy_id);
1500: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1501: THEN
1502: fnd_log.STRING (fnd_log.level_statement,

Line 1948: gcs_utility_pkg.g_module_success

1944: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1945: THEN
1946: fnd_log.STRING (fnd_log.level_procedure,
1947: g_pkg_name || ''.'' || l_api_name,
1948: gcs_utility_pkg.g_module_success
1949: || '' ''
1950: || l_api_name
1951: || ''() ''
1952: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 1966: gcs_utility_pkg.g_module_failure

1962: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1963: THEN
1964: fnd_log.STRING (fnd_log.level_procedure,
1965: g_pkg_name || ''.'' || l_api_name,
1966: gcs_utility_pkg.g_module_failure
1967: || '' ''
1968: || l_api_name
1969: || ''() ''
1970: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 1983: gcs_utility_pkg.g_module_failure

1979: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1980: THEN
1981: fnd_log.STRING (fnd_log.level_procedure,
1982: g_pkg_name || ''.'' || l_api_name,
1983: gcs_utility_pkg.g_module_failure
1984: || '' ''
1985: || l_api_name
1986: || ''() ''
1987: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 2000: gcs_utility_pkg.g_module_failure

1996: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1997: THEN
1998: fnd_log.STRING (fnd_log.level_procedure,
1999: g_pkg_name || ''.'' || l_api_name,
2000: gcs_utility_pkg.g_module_failure
2001: || '' ''
2002: || l_api_name
2003: || ''() ''
2004: || TO_CHAR (SYSDATE, ''DD-MON-YYYY HH:MI:SS'')

Line 2076: gcs_utility_pkg.g_avg_fin_elem;

2072:
2073: IF (p_balance_type_code = 'ADB')
2074: THEN
2075: p_template_record.financial_elem_id :=
2076: gcs_utility_pkg.g_avg_fin_elem;
2077: END IF;
2078:
2079: EXCEPTION
2080: WHEN OTHERS