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

Line 191: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

187: line_num);
188: curr_pos := curr_pos + g_line_size;
189: line_num := line_num + 1;
190: END LOOP;
191: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
192: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
193:
194:
195:

Line 251: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

247: END LOOP;
248:
249:
250: --******--
251: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
252: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
253: --******--
254:
255: body_block :=

Line 273: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

269: END LOOP;
270:
271:
272: --******--
273: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
274: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
275:
276:
277: body_block :=

Line 344: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

340: line_num);
341: curr_pos := curr_pos + g_line_size;
342: line_num := line_num + 1;
343: END LOOP;
344: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
345: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
346:
347:
348:

Line 404: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

400: END LOOP;
401:
402:
403: --******--
404: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
405: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
406:
407: --******--
408:

Line 428: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

424: END LOOP;
425:
426:
427: --******--
428: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
429: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
430:
431:
432: body_block :=

Line 527: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

523: curr_pos := curr_pos + g_line_size;
524: line_num := line_num + 1;
525: END LOOP;
526:
527: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
528: ' giet.',
529: 'DECODE(giet.elim_lob_id, NULL,giet.',
530: 'DECODE(p_lob_dim_col_name, ',
531: ' giet.elim_lob_id, giet.',

Line 589: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

585: line_num := line_num + 1;
586: END LOOP;
587: --******--
588:
589: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
590: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
591:
592: body_block :=
593: '

Line 609: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

605: END LOOP;
606:
607: --******--
608:
609: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
610: ' giet.',
611: 'DECODE(giet.elim_lob_id, NULL,giet.',
612: 'DECODE(p_lob_dim_col_name, ',
613: ' giet.elim_lob_id, giet.',

Line 710: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

706: curr_pos := curr_pos + g_line_size;
707: line_num := line_num + 1;
708: END LOOP;
709:
710: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
711: ' giet.',
712: 'DECODE(giet.elim_lob_id, NULL,giet.',
713: 'DECODE(p_lob_dim_col_name, ',
714: ' giet.elim_lob_id, giet.',

Line 772: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

768: line_num := line_num + 1;
769: END LOOP;
770: --******--
771:
772: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
773: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
774:
775: body_block :=
776: '

Line 792: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

788: END LOOP;
789:
790: --******--
791:
792: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
793: ' giet.',
794: 'DECODE(giet.elim_lob_id, NULL,giet.',
795: 'DECODE(p_lob_dim_col_name, ',
796: ' giet.elim_lob_id, giet.',

Line 885: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

881: line_num);
882: curr_pos := curr_pos + g_line_size;
883: line_num := line_num + 1;
884: END LOOP;
885: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
886: ' giet.', GCS_UTILITY_PKG.g_nl, ' NULL,', line_num);
887:
888:
889:

Line 937: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

933: END LOOP;
934:
935:
936: --******--
937: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
938: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
939:
940:
941: --******--

Line 965: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

961: line_num := line_num + 1;
962: END LOOP;
963: --******--
964:
965: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
966: ' AND giet3.', ' = giet. ',
967: GCS_UTILITY_PKG.g_nl, line_num);
968:
969: body_block :=

Line 1006: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

1002: END LOOP;
1003:
1004:
1005: --******--
1006: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
1007: ' giet.', GCS_UTILITY_PKG.g_nl, '', line_num);
1008:
1009:
1010: body_block :=

Line 1102: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

1098: curr_pos := curr_pos + g_line_size;
1099: line_num := line_num + 1;
1100: END LOOP;
1101:
1102: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
1103: ' giet.',
1104: 'DECODE(giet.elim_lob_id, NULL,giet.',
1105: 'DECODE(p_lob_dim_col_name, ',
1106: ' giet.elim_lob_id, giet.',

Line 1156: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

1152: line_num := line_num + 1;
1153: END LOOP;
1154: --******--
1155:
1156: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
1157: ' AND fb.', ' = giet. ', GCS_UTILITY_PKG.g_nl, line_num);
1158: body_block := '
1159: AND NOT EXISTS (SELECT 1
1160: FROM GCS_INTERCO_ELM_TRX giet3,

Line 1184: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

1180: END LOOP;
1181: --******--
1182:
1183:
1184: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
1185: ' AND giet3.', ' = giet. ',
1186: GCS_UTILITY_PKG.g_nl, line_num);
1187:
1188: body_block :=

Line 1225: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(

1221: END LOOP;
1222:
1223: --******--
1224:
1225: line_num := GCS_DYNAMIC_UTIL_PKG.Build_interco_Comma_List(
1226: ' giet.',
1227: 'DECODE(giet.elim_lob_id, NULL,giet.',
1228: 'DECODE(p_lob_dim_col_name, ',
1229: ' giet.elim_lob_id, giet.',

Line 2222: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

2218: line_num := line_num + 1;
2219: END LOOP;
2220:
2221:
2222: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2223: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2224:
2225: body_block := '
2226: SYSDATE, g_fnd_user_id,

Line 2367: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

2363: line_num := line_num + 1;
2364: END LOOP;
2365:
2366:
2367: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2368: ' AND giet1.', ' = gel. ',
2369: GCS_UTILITY_PKG.g_nl, line_num);
2370:
2371:

Line 2457: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

2453: line_num := line_num + 1;
2454: END LOOP;
2455:
2456:
2457: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2458: 'gel.', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2459:
2460: body_block := '
2461: SYSDATE, g_fnd_user_id,

Line 2602: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

2598: line_num := line_num + 1;
2599: END LOOP;
2600:
2601:
2602: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2603: ' AND giet1.', ' = gel. ',
2604: GCS_UTILITY_PKG.g_nl, line_num);
2605:
2606:

Line 2708: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

2704: line_num := line_num + 1;
2705: END LOOP;
2706:
2707:
2708: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2709: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2710:
2711:
2712: body_block := '

Line 2778: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

2774: line_num := line_num + 1;
2775: END LOOP;
2776:
2777:
2778: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2779: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
2780:
2781: body_block := '
2782: AND giet1.line_item_id = gel.line_item_id);

Line 2865: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

2861: line_num := line_num + 1;
2862: END LOOP;
2863:
2864:
2865: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
2866: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
2867:
2868:
2869: body_block := '

Line 2935: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

2931: line_num := line_num + 1;
2932: END LOOP;
2933:
2934:
2935: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
2936: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
2937:
2938: body_block := '
2939: AND giet1.line_item_id = gel.line_item_id);

Line 3043: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

3039: line_num := line_num + 1;
3040: END LOOP;
3041:
3042:
3043: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
3044: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
3045:
3046: body_block := '
3047: SYSDATE, g_fnd_user_id,

Line 3144: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

3140: END LOOP;
3141:
3142:
3143:
3144: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
3145: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
3146:
3147: body_block := '
3148: AND giet1.line_item_id = gel.line_item_id);

Line 3252: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

3248: line_num := line_num + 1;
3249: END LOOP;
3250:
3251:
3252: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
3253: ' ', GCS_UTILITY_PKG.g_nl, ' NULL, ', line_num);
3254:
3255: body_block := '
3256: SYSDATE, g_fnd_user_id,

Line 3354: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(

3350: END LOOP;
3351:
3352:
3353:
3354: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Join_List(
3355: ' AND giet1.', ' = gel. ', GCS_UTILITY_PKG.g_nl, line_num);
3356:
3357: body_block := '
3358: AND giet1.line_item_id = gel.line_item_id);

Line 3547: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

3543: curr_pos := curr_pos + g_line_size;
3544: line_num := line_num + 1;
3545: END LOOP;
3546:
3547: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
3548: 'GCS', 'GCS_INTERCO_DYNAMIC_PKG',
3549: 1, line_num - 1, 'FALSE', comp_err);
3550:
3551: EXCEPTION