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_BUILD_FEM_POSTING_PKG dependencies on GCS_DYNAMIC_UTIL_PKG

Line 128: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);

124: curr_pos := curr_pos + g_line_size;
125: r := r + 1;
126: END LOOP;
127:
128: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);
129:
130: body:=
131: ' XTD_BALANCE_E,
132: YTD_BALANCE_E,

Line 156: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

152: curr_pos := curr_pos + g_line_size;
153: r := r + 1;
154: END LOOP;
155:
156: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
157: body:=
158: ' nvl(GLE.XTD_BALANCE_E, GLE.YTD_BALANCE_E),
159: GLE.YTD_BALANCE_E,
160: nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E),

Line 204: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);

200: curr_pos := curr_pos + g_line_size;
201: r := r + 1;
202: END LOOP;
203:
204: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);
205:
206: body:=
207: ' XTD_BALANCE_E,
208: YTD_BALANCE_E,

Line 232: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);

228: curr_pos := curr_pos + g_line_size;
229: r := r + 1;
230: END LOOP;
231:
232: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);
233:
234: body := '
235: GFB.XTD_BALANCE_E,
236: GFB.YTD_BALANCE_E,

Line 257: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

253: curr_pos := curr_pos + g_line_size;
254: r := r + 1;
255: END LOOP;
256:
257: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
258:
259: body:=
260: ' max(GHD.ENTITY_ID) ENTITY_ID,
261: sum(nvl(GLE.XTD_BALANCE_E, GLE.YTD_BALANCE_E)) XTD_BALANCE_E,

Line 291: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

287: curr_pos := curr_pos + g_line_size;
288: r := r + 1;
289: END LOOP;
290:
291: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
292:
293: body:= 'GLE.intercompany_id ) GFB;
294:
295: EXCEPTION

Line 317: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);

313: curr_pos := curr_pos + g_line_size;
314: r := r + 1;
315: END LOOP;
316:
317: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);
318:
319: body:=
320: ' XTD_BALANCE_E,
321: YTD_BALANCE_E,

Line 345: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);

341: curr_pos := curr_pos + g_line_size;
342: r := r + 1;
343: END LOOP;
344:
345: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);
346:
347: body := '
348: GFB.XTD_BALANCE_E,
349: GFB.YTD_BALANCE_E,

Line 370: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

366: curr_pos := curr_pos + g_line_size;
367: r := r + 1;
368: END LOOP;
369:
370: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
371:
372: body:=
373: ' max(GHD.ENTITY_ID) ENTITY_ID,
374: sum(nvl(GLE.XTD_BALANCE_E, GLE.YTD_BALANCE_E)) XTD_BALANCE_E,

Line 400: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

396: curr_pos := curr_pos + g_line_size;
397: r := r + 1;
398: END LOOP;
399:
400: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
401:
402: body:= 'GLE.intercompany_id ) GFB;
403: END;
404:

Line 441: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);

437: curr_pos := curr_pos + g_line_size;
438: r := r + 1;
439: END LOOP;
440:
441: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);
442:
443: body:=
444: ' XTD_BALANCE_E,
445: YTD_BALANCE_E,

Line 469: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);

465: curr_pos := curr_pos + g_line_size;
466: r := r + 1;
467: END LOOP;
468:
469: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);
470:
471: body := '
472: GFB.XTD_BALANCE_E,
473: GFB.YTD_BALANCE_E,

Line 494: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

490: curr_pos := curr_pos + g_line_size;
491: r := r + 1;
492: END LOOP;
493:
494: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
495:
496: body:=
497: ' max(GHD.ENTITY_ID) ENTITY_ID,
498: sum(nvl(GLE.XTD_BALANCE_E, GLE.YTD_BALANCE_E)) XTD_BALANCE_E,

Line 527: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

523: curr_pos := curr_pos + g_line_size;
524: r := r + 1;
525: END LOOP;
526:
527: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
528:
529: body:= 'GLE.intercompany_id ) GFB;
530:
531: EXCEPTION

Line 553: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);

549: curr_pos := curr_pos + g_line_size;
550: r := r + 1;
551: END LOOP;
552:
553: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r);
554:
555: body:=
556: ' XTD_BALANCE_E,
557: YTD_BALANCE_E,

Line 581: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);

577: curr_pos := curr_pos + g_line_size;
578: r := r + 1;
579: END LOOP;
580:
581: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GFB.', GCS_UTILITY_PKG.g_nl, '', r);
582:
583: body := '
584: GFB.XTD_BALANCE_E,
585: GFB.YTD_BALANCE_E,

Line 606: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

602: curr_pos := curr_pos + g_line_size;
603: r := r + 1;
604: END LOOP;
605:
606: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
607:
608: body:=
609: ' max(GHD.ENTITY_ID) ENTITY_ID,
610: sum(nvl(GLE.XTD_BALANCE_E, GLE.YTD_BALANCE_E)) XTD_BALANCE_E,

Line 635: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);

631: curr_pos := curr_pos + g_line_size;
632: r := r + 1;
633: END LOOP;
634:
635: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(' GLE.', GCS_UTILITY_PKG.g_nl, '', r);
636:
637: body:= 'GLE.intercompany_id ) GFB;
638:
639: END;

Line 722: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r, 'N');

718: curr_pos := curr_pos + g_line_size;
719: r := r + 1;
720: END LOOP;
721:
722: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r, 'N');
723:
724: body:=
725: ' CREATED_BY_REQUEST_ID,
726: CREATED_BY_OBJECT_ID,

Line 760: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r, 'Y');

756: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
757: curr_pos := curr_pos + g_line_size;
758: r := r + 1;
759: END LOOP;
760: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List(' ', GCS_UTILITY_PKG.g_nl, '', r, 'Y');
761: body:=
762: ' l_req_id,
763: p_object_id,
764: l_req_id,

Line 872: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List('GLE.', GCS_UTILITY_PKG.g_nl, '', r);

868: curr_pos := curr_pos + g_line_size;
869: r := r + 1;
870: END LOOP;
871:
872: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List('GLE.', GCS_UTILITY_PKG.g_nl, '', r);
873:
874: body :=
875: ' GLE.CURRENCY_CODE CURRENCY_CODE,
876: GLE.ENTITY_ID ENTITY_ID,

Line 929: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('FB.', GCS_UTILITY_PKG.g_nl, '', r, 'N');

925: curr_pos := curr_pos + g_line_size;
926: r := r + 1;
927: END LOOP;
928:
929: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('FB.', GCS_UTILITY_PKG.g_nl, '', r, 'N');
930:
931: body:= 'FB.CREATED_BY_REQUEST_ID,
932: FB.CREATED_BY_OBJECT_ID,
933: FB.LAST_UPDATED_BY_REQUEST_ID,

Line 965: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('GFB.', GCS_UTILITY_PKG.g_nl, '', r, 'Y');

961: curr_pos := curr_pos + g_line_size;
962: r := r + 1;
963: END LOOP;
964:
965: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('GFB.', GCS_UTILITY_PKG.g_nl, '', r, 'Y');
966:
967: body := ' GFB.CREATED_BY_REQUEST_ID,
968: GFB.CREATED_BY_OBJECT_ID,
969: GFB.LAST_UPDATED_BY_REQUEST_ID,

Line 1004: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List('GLE.', GCS_UTILITY_PKG.g_nl, '', r);

1000: curr_pos := curr_pos + g_line_size;
1001: r := r + 1;
1002: END LOOP;
1003:
1004: r := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List('GLE.', GCS_UTILITY_PKG.g_nl, '', r);
1005:
1006: body :=
1007: ' GLE.CURRENCY_CODE CURRENCY_CODE,
1008: GLE.ENTITY_ID ENTITY_ID,

Line 1061: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('FB.', GCS_UTILITY_PKG.g_nl, '', r, 'N');

1057: curr_pos := curr_pos + g_line_size;
1058: r := r + 1;
1059: END LOOP;
1060:
1061: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('FB.', GCS_UTILITY_PKG.g_nl, '', r, 'N');
1062:
1063: body:= 'FB.CREATED_BY_REQUEST_ID,
1064: FB.CREATED_BY_OBJECT_ID,
1065: FB.LAST_UPDATED_BY_REQUEST_ID,

Line 1097: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('GFB.', GCS_UTILITY_PKG.g_nl, '', r, 'Y');

1093: curr_pos := curr_pos + g_line_size;
1094: r := r + 1;
1095: END LOOP;
1096:
1097: r := GCS_DYNAMIC_UTIL_PKG.Build_Fem_Comma_List('GFB.', GCS_UTILITY_PKG.g_nl, '', r, 'Y');
1098:
1099: body := ' GFB.CREATED_BY_REQUEST_ID,
1100: GFB.CREATED_BY_OBJECT_ID,
1101: GFB.LAST_UPDATED_BY_REQUEST_ID,

Line 1573: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', 'GCS_DYN_FEM_POSTING_PKG',1, r - 1, 'FALSE', err);

1569: curr_pos := curr_pos + g_line_size;
1570: r := r + 1;
1571: END LOOP;
1572:
1573: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', 'GCS_DYN_FEM_POSTING_PKG',1, r - 1, 'FALSE', err);
1574:
1575: -- dbms_output.put_line('Error' || AD_DDL.error_buf);
1576:
1577: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN