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_TRANS_HRATES_DYN_BUILD_PKG dependencies on GCS_TRANS_DYN_BUILD_PKG

Line 132: GCS_TRANS_DYN_BUILD_PKG.Initialize_Dimensions;

128: raise gcs_ccy_applsys_not_found;
129: END IF;
130:
131: -- Bugfix 7525759: Initialize the variables that determines the required dimensions.
132: GCS_TRANS_DYN_BUILD_PKG.Initialize_Dimensions;
133:
134: -- Create the package body
135: body_block :=
136: 'CREATE OR REPLACE PACKAGE BODY GCS_TRANS_HRATES_DYNAMIC_PKG AS

Line 274: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'H');

270: curr_pos := curr_pos + g_line_size;
271: line_num := line_num + 1;
272: END LOOP;
273:
274: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'H');
275:
276: --Bugfix 6111815: Adeded Standard RE Rate Flag
277: body_block :=
278: ''' AND ghr1.cal_period_id = '' || p_prev_period_id || '')'' || g_nl ||

Line 306: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr3.', ' = ghr2.', ''' || g_nl ||', line_num, 'H');

302: curr_pos := curr_pos + g_line_size;
303: line_num := line_num + 1;
304: END LOOP;
305:
306: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr3.', ' = ghr2.', ''' || g_nl ||', line_num, 'H');
307:
308: body_block :=
309: ''' AND ghr3.from_currency = ghr2.from_currency'' || g_nl ||
310: '' AND ghr3.to_currency = ghr2.to_currency '' || g_nl ||

Line 348: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'H');

344: curr_pos := curr_pos + g_line_size;
345: line_num := line_num + 1;
346: END LOOP;
347:
348: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'H');
349:
350: --Bugfix 6111815: Added Standard RE Rate Flag
351: body_block :=
352: ' AND ghr1.cal_period_id = p_prev_period_id)

Line 380: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr3.', ' = ghr2.', '', line_num, 'H');

376: curr_pos := curr_pos + g_line_size;
377: line_num := line_num + 1;
378: END LOOP;
379:
380: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr3.', ' = ghr2.', '', line_num, 'H');
381:
382: body_block :=
383: ' AND ghr3.from_currency = ghr2.from_currency
384: AND ghr3.to_currency = ghr2.to_currency

Line 424: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr2.', ' (+)= ghr3.', ''' || g_nl ||', line_num, 'H');

420: curr_pos := curr_pos + g_line_size;
421: line_num := line_num + 1;
422: END LOOP;
423:
424: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr2.', ' (+)= ghr3.', ''' || g_nl ||', line_num, 'H');
425:
426: body_block :=
427: ''' )'');
428:

Line 465: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr2.', ' (+)= ghr3.', '', line_num, 'H');

461: curr_pos := curr_pos + g_line_size;
462: line_num := line_num + 1;
463: END LOOP;
464:
465: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr2.', ' (+)= ghr3.', '', line_num, 'H');
466:
467: body_block :=
468: ' );
469:

Line 494: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''ghr.', ' '' ||', '''NULL, '' ||', line_num, 'H');

490: curr_pos := curr_pos + g_line_size;
491: line_num := line_num + 1;
492: END LOOP;
493:
494: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''ghr.', ' '' ||', '''NULL, '' ||', line_num, 'H');
495:
496: body_block :=
497: '''ghr.translated_rate, ghr.translated_amount, ''''P'''', ''''N'''', '' ||
498: ''ghr.account_type_code, ''''N'''', sysdate, '' ||

Line 527: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'H');

523: curr_pos := curr_pos + g_line_size;
524: line_num := line_num + 1;
525: END LOOP;
526:
527: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'H');
528:
529: body_block :=
530: ''' AND ghr1.update_flag = ''''N'''''' || g_nl ||
531: '' AND ghr1.from_currency = ghr.from_currency'' || g_nl ||

Line 562: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'H');

558: curr_pos := curr_pos + g_line_size;
559: line_num := line_num + 1;
560: END LOOP;
561:
562: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'H');
563:
564: --Bugfix 6111815: Added Standard RE Rate Flag
565: body_block :=
566: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',

Line 596: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'H');

592: curr_pos := curr_pos + g_line_size;
593: line_num := line_num + 1;
594: END LOOP;
595:
596: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'H');
597:
598: body_block :=
599: ' AND ghr1.update_flag = ''N''
600: AND ghr1.from_currency = ghr.from_currency

Line 680: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

676: curr_pos := curr_pos + g_line_size;
677: line_num := line_num + 1;
678: END LOOP;
679:
680: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
681:
682: body_block :=
683: '''0, 0, 0, 0,'' || g_nl ||
684: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 736: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

732: curr_pos := curr_pos + g_line_size;
733: line_num := line_num + 1;
734: END LOOP;
735:
736: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
737:
738: body_block :=
739: ''' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,'' || g_nl ||
740: '' SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e'' || g_nl ||

Line 759: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

755: curr_pos := curr_pos + g_line_size;
756: line_num := line_num + 1;
757: END LOOP;
758:
759: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
760:
761: --Bugfix 6111815: Remove p_hier_li_id condition
762: body_block :=
763: ''' fb_in.line_item_id) fb,'' || g_nl ||

Line 790: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+) = fb.', ''' || g_nl ||', line_num, 'H');

786: curr_pos := curr_pos + g_line_size;
787: line_num := line_num + 1;
788: END LOOP;
789:
790: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+) = fb.', ''' || g_nl ||', line_num, 'H');
791:
792: body_block :=
793: ''''');
794:

Line 820: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

816: curr_pos := curr_pos + g_line_size;
817: line_num := line_num + 1;
818: END LOOP;
819:
820: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
821:
822: body_block :=
823: ' 0, 0, 0, 0,
824: round(nvl(ghr.translated_amount * 0,

Line 876: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

872: curr_pos := curr_pos + g_line_size;
873: line_num := line_num + 1;
874: END LOOP;
875:
876: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
877:
878: body_block :=
879: ' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
880: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e

Line 899: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

895: curr_pos := curr_pos + g_line_size;
896: line_num := line_num + 1;
897: END LOOP;
898:
899: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
900: --Bugfix 6111815: Remove p_hier_li_id condition and added NOT EXISTS clause
901: body_block :=
902: ' fb_in.line_item_id) fb,
903: FEM_LN_ITEMS_ATTR li,

Line 929: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+) = fb.', '', line_num, 'H');

925: curr_pos := curr_pos + g_line_size;
926: line_num := line_num + 1;
927: END LOOP;
928:
929: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+) = fb.', '', line_num, 'H');
930:
931: --Bugfix 6111815: Added Retained Earnings Exclusion
932: body_block :=
933: '

Line 951: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');

947: curr_pos := curr_pos + g_line_size;
948: line_num := line_num + 1;
949: END LOOP;
950:
951: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');
952:
953: body_block :=
954: ' );
955:

Line 982: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

978: curr_pos := curr_pos + g_line_size;
979: line_num := line_num + 1;
980: END LOOP;
981:
982: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
983:
984: body_block :=
985: '''0, 0, 0, 0,'' || g_nl ||
986: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1038: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1034: curr_pos := curr_pos + g_line_size;
1035: line_num := line_num + 1;
1036: END LOOP;
1037:
1038: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1039:
1040: --Bugfix 6111815: Removed p_hier_li_id condition and added NOT EXISTS clause
1041: body_block :=
1042: ''' ytd_debit_balance_e sum_ytd_debit_balance_e,'' || g_nl ||

Line 1077: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+) = fb.', ''' || g_nl ||', line_num, 'H');

1073: curr_pos := curr_pos + g_line_size;
1074: line_num := line_num + 1;
1075: END LOOP;
1076:
1077: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+) = fb.', ''' || g_nl ||', line_num, 'H');
1078:
1079: body_block :=
1080: ''''');
1081:

Line 1107: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1103: curr_pos := curr_pos + g_line_size;
1104: line_num := line_num + 1;
1105: END LOOP;
1106:
1107: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1108:
1109: body_block :=
1110: ' 0, 0, 0, 0,
1111: round(nvl(ghr.translated_amount * 0,

Line 1163: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1159: curr_pos := curr_pos + g_line_size;
1160: line_num := line_num + 1;
1161: END LOOP;
1162:
1163: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1164:
1165: --Bugfix 6111815: Removed p_hier_li_id condition and added not exists clause
1166: body_block :=
1167: ' ytd_debit_balance_e sum_ytd_debit_balance_e,

Line 1202: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+) = fb.', '', line_num, 'H');

1198: curr_pos := curr_pos + g_line_size;
1199: line_num := line_num + 1;
1200: END LOOP;
1201:
1202: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+) = fb.', '', line_num, 'H');
1203:
1204: --Bugfix 6111815: Added Retained Earnings Exclusion
1205: body_block :=
1206: '

Line 1224: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');

1220: curr_pos := curr_pos + g_line_size;
1221: line_num := line_num + 1;
1222: END LOOP;
1223:
1224: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');
1225:
1226: body_block :=
1227: ' );
1228:

Line 1331: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

1327: curr_pos := curr_pos + g_line_size;
1328: line_num := line_num + 1;
1329: END LOOP;
1330:
1331: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
1332:
1333: body_block :=
1334: 'g_nl ||
1335: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1391: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1387: curr_pos := curr_pos + g_line_size;
1388: line_num := line_num + 1;
1389: END LOOP;
1390:
1391: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1392:
1393: body_block :=
1394: ''' SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,'' || g_nl ||
1395: '' SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,'' || g_nl ||

Line 1416: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1412: curr_pos := curr_pos + g_line_size;
1413: line_num := line_num + 1;
1414: END LOOP;
1415:
1416: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1417:
1418: --Bugfix 6111815: Removed p_hier_li_id and added NOT EXISTS clause
1419: body_block :=
1420: ''' fb_in.line_item_id) fb,'' || g_nl ||

Line 1449: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');

1445: curr_pos := curr_pos + g_line_size;
1446: line_num := line_num + 1;
1447: END LOOP;
1448:
1449: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1450:
1451: body_block :=
1452: '''AND ghr.entity_id (+)= '' || p_entity_id || g_nl ||
1453: ''AND ghr.hierarchy_id (+)= '' || p_hierarchy_id || g_nl ||

Line 1469: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+)= fb.', ''' || g_nl ||', line_num, 'H');

1465: curr_pos := curr_pos + g_line_size;
1466: line_num := line_num + 1;
1467: END LOOP;
1468:
1469: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+)= fb.', ''' || g_nl ||', line_num, 'H');
1470:
1471: body_block :=
1472: ''''');
1473:

Line 1499: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1495: curr_pos := curr_pos + g_line_size;
1496: line_num := line_num + 1;
1497: END LOOP;
1498:
1499: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1500:
1501: body_block :=
1502: ' round(nvl(ghr.translated_amount * 0,
1503: nvl(decode(fxata.dim_attribute_varchar_member,

Line 1558: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1554: curr_pos := curr_pos + g_line_size;
1555: line_num := line_num + 1;
1556: END LOOP;
1557:
1558: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1559:
1560: body_block :=
1561: ' SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,
1562: SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,

Line 1583: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1579: curr_pos := curr_pos + g_line_size;
1580: line_num := line_num + 1;
1581: END LOOP;
1582:
1583: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1584:
1585: --Bugfix 6111815: Removed p_hier_li_id and Added Not Exists Clause
1586: body_block :=
1587: ' fb_in.line_item_id) fb,

Line 1616: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');

1612: curr_pos := curr_pos + g_line_size;
1613: line_num := line_num + 1;
1614: END LOOP;
1615:
1616: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1617:
1618: body_block :=
1619: ' AND ghr.entity_id (+)= p_entity_id
1620: AND ghr.hierarchy_id (+)= p_hierarchy_id

Line 1636: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+)= fb.', '', line_num, 'H');

1632: curr_pos := curr_pos + g_line_size;
1633: line_num := line_num + 1;
1634: END LOOP;
1635:
1636: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+)= fb.', '', line_num, 'H');
1637:
1638: --Bugfix 6111815: Added Retained Earnings Exclusion
1639: body_block :=
1640: '

Line 1658: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');

1654: curr_pos := curr_pos + g_line_size;
1655: line_num := line_num + 1;
1656: END LOOP;
1657:
1658: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');
1659:
1660: body_block :=
1661: ' );
1662:

Line 1690: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

1686: curr_pos := curr_pos + g_line_size;
1687: line_num := line_num + 1;
1688: END LOOP;
1689:
1690: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
1691:
1692: body_block :=
1693: 'g_nl ||
1694: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1750: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1746: curr_pos := curr_pos + g_line_size;
1747: line_num := line_num + 1;
1748: END LOOP;
1749:
1750: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1751:
1752: --Bugfix 6111815: Removed p_hier_li_id Condition
1753: body_block :=
1754: ''' ptd_debit_balance_e sum_ptd_debit_balance_e,'' || g_nl ||

Line 1793: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');

1789: curr_pos := curr_pos + g_line_size;
1790: line_num := line_num + 1;
1791: END LOOP;
1792:
1793: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1794:
1795: body_block :=
1796: '''AND ghr.entity_id (+)= '' || p_entity_id || g_nl ||
1797: ''AND ghr.hierarchy_id (+)= '' || p_hierarchy_id || g_nl ||

Line 1813: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+)= fb.', ''' || g_nl ||', line_num, 'H');

1809: curr_pos := curr_pos + g_line_size;
1810: line_num := line_num + 1;
1811: END LOOP;
1812:
1813: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' (+)= fb.', ''' || g_nl ||', line_num, 'H');
1814:
1815: --Bugfix 6111815: Removed p_hier_li_id condition and added NOT EXISTS clause
1816: body_block :=
1817: ''''');

Line 1844: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1840: curr_pos := curr_pos + g_line_size;
1841: line_num := line_num + 1;
1842: END LOOP;
1843:
1844: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1845:
1846: body_block :=
1847: ' round(nvl(ghr.translated_amount * 0,
1848: nvl(decode(fxata.dim_attribute_varchar_member,

Line 1903: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1899: curr_pos := curr_pos + g_line_size;
1900: line_num := line_num + 1;
1901: END LOOP;
1902:
1903: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1904:
1905: body_block :=
1906: ' ptd_debit_balance_e sum_ptd_debit_balance_e,
1907: ptd_credit_balance_e sum_ptd_credit_balance_e,

Line 1945: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');

1941: curr_pos := curr_pos + g_line_size;
1942: line_num := line_num + 1;
1943: END LOOP;
1944:
1945: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1946:
1947: body_block :=
1948: ' AND ghr.entity_id (+)= p_entity_id
1949: AND ghr.hierarchy_id (+)= p_hierarchy_id

Line 1965: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+)= fb.', '', line_num, 'H');

1961: curr_pos := curr_pos + g_line_size;
1962: line_num := line_num + 1;
1963: END LOOP;
1964:
1965: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' (+)= fb.', '', line_num, 'H');
1966:
1967: --Bugfix 6111815: Added Retained Earnings Exclusion
1968: body_block :=
1969: '

Line 1987: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');

1983: curr_pos := curr_pos + g_line_size;
1984: line_num := line_num + 1;
1985: END LOOP;
1986:
1987: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr_retained.', ' = fb.', '', line_num, 'F');
1988:
1989: body_block :=
1990: ' );
1991: