DBA Data[Home] [Help]

APPS.GCS_BUILD_FEM_POSTING_PKG dependencies on AD_DDL

Line 60: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

56: ';
57: curr_pos := 1;
58: body_len := LENGTH(body);
59: WHILE curr_pos <= body_len LOOP
60: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
61: curr_pos := curr_pos + g_line_size;
62: r := r + 1;
63: END LOOP;
64:

Line 123: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

119: ';
120: curr_pos := 1;
121: body_len := LENGTH(body);
122: WHILE curr_pos <= body_len LOOP
123: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
124: curr_pos := curr_pos + g_line_size;
125: r := r + 1;
126: END LOOP;
127:

Line 151: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

147:
148: curr_pos := 1;
149: body_len := LENGTH(body);
150: WHILE curr_pos <= body_len LOOP
151: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
152: curr_pos := curr_pos + g_line_size;
153: r := r + 1;
154: END LOOP;
155:

Line 199: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

195: ';
196: curr_pos := 1;
197: body_len := LENGTH(body);
198: WHILE curr_pos <= body_len LOOP
199: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
200: curr_pos := curr_pos + g_line_size;
201: r := r + 1;
202: END LOOP;
203:

Line 227: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

223:
224: curr_pos := 1;
225: body_len := LENGTH(body);
226: WHILE curr_pos <= body_len LOOP
227: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
228: curr_pos := curr_pos + g_line_size;
229: r := r + 1;
230: END LOOP;
231:

Line 252: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

248:
249: curr_pos := 1;
250: body_len := LENGTH(body);
251: WHILE curr_pos <= body_len LOOP
252: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
253: curr_pos := curr_pos + g_line_size;
254: r := r + 1;
255: END LOOP;
256:

Line 286: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

282:
283: curr_pos := 1;
284: body_len := LENGTH(body);
285: WHILE curr_pos <= body_len LOOP
286: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
287: curr_pos := curr_pos + g_line_size;
288: r := r + 1;
289: END LOOP;
290:

Line 312: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

308: ';
309: curr_pos := 1;
310: body_len := LENGTH(body);
311: WHILE curr_pos <= body_len LOOP
312: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
313: curr_pos := curr_pos + g_line_size;
314: r := r + 1;
315: END LOOP;
316:

Line 340: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

336:
337: curr_pos := 1;
338: body_len := LENGTH(body);
339: WHILE curr_pos <= body_len LOOP
340: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
341: curr_pos := curr_pos + g_line_size;
342: r := r + 1;
343: END LOOP;
344:

Line 365: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

361:
362: curr_pos := 1;
363: body_len := LENGTH(body);
364: WHILE curr_pos <= body_len LOOP
365: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
366: curr_pos := curr_pos + g_line_size;
367: r := r + 1;
368: END LOOP;
369:

Line 395: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

391:
392: curr_pos := 1;
393: body_len := LENGTH(body);
394: WHILE curr_pos <= body_len LOOP
395: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
396: curr_pos := curr_pos + g_line_size;
397: r := r + 1;
398: END LOOP;
399:

Line 436: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

432: ';
433: curr_pos := 1;
434: body_len := LENGTH(body);
435: WHILE curr_pos <= body_len LOOP
436: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
437: curr_pos := curr_pos + g_line_size;
438: r := r + 1;
439: END LOOP;
440:

Line 464: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

460:
461: curr_pos := 1;
462: body_len := LENGTH(body);
463: WHILE curr_pos <= body_len LOOP
464: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
465: curr_pos := curr_pos + g_line_size;
466: r := r + 1;
467: END LOOP;
468:

Line 489: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

485:
486: curr_pos := 1;
487: body_len := LENGTH(body);
488: WHILE curr_pos <= body_len LOOP
489: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
490: curr_pos := curr_pos + g_line_size;
491: r := r + 1;
492: END LOOP;
493:

Line 522: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

518:
519: curr_pos := 1;
520: body_len := LENGTH(body);
521: WHILE curr_pos <= body_len LOOP
522: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
523: curr_pos := curr_pos + g_line_size;
524: r := r + 1;
525: END LOOP;
526:

Line 548: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

544: ';
545: curr_pos := 1;
546: body_len := LENGTH(body);
547: WHILE curr_pos <= body_len LOOP
548: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
549: curr_pos := curr_pos + g_line_size;
550: r := r + 1;
551: END LOOP;
552:

Line 576: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

572:
573: curr_pos := 1;
574: body_len := LENGTH(body);
575: WHILE curr_pos <= body_len LOOP
576: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
577: curr_pos := curr_pos + g_line_size;
578: r := r + 1;
579: END LOOP;
580:

Line 601: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

597:
598: curr_pos := 1;
599: body_len := LENGTH(body);
600: WHILE curr_pos <= body_len LOOP
601: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
602: curr_pos := curr_pos + g_line_size;
603: r := r + 1;
604: END LOOP;
605:

Line 630: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

626:
627: curr_pos := 1;
628: body_len := LENGTH(body);
629: WHILE curr_pos <= body_len LOOP
630: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
631: curr_pos := curr_pos + g_line_size;
632: r := r + 1;
633: END LOOP;
634:

Line 652: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

648: ';
649: curr_pos := 1;
650: body_len := LENGTH(body);
651: WHILE curr_pos <= body_len LOOP
652: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
653: curr_pos := curr_pos + g_line_size;
654: r := r + 1;
655: END LOOP;
656:

Line 717: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

713: ';
714: curr_pos := 1;
715: body_len := LENGTH(body);
716: WHILE curr_pos <= body_len LOOP
717: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
718: curr_pos := curr_pos + g_line_size;
719: r := r + 1;
720: END LOOP;
721:

Line 756: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

752:
753: curr_pos := 1;
754: body_len := LENGTH(body);
755: WHILE curr_pos <= body_len LOOP
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');

Line 803: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

799: ';
800: curr_pos := 1;
801: body_len := LENGTH(body);
802: WHILE curr_pos <= body_len LOOP
803: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
804: curr_pos := curr_pos + g_line_size;
805: r := r + 1;
806: END LOOP;
807:

Line 867: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

863:
864: curr_pos := 1;
865: body_len := LENGTH(body);
866: WHILE curr_pos <= body_len LOOP
867: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
868: curr_pos := curr_pos + g_line_size;
869: r := r + 1;
870: END LOOP;
871:

Line 889: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

885:
886: curr_pos := 1;
887: body_len := LENGTH(body);
888: WHILE curr_pos <= body_len LOOP
889: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
890: curr_pos := curr_pos + g_line_size;
891: r := r + 1;
892: END LOOP;
893:

Line 924: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

920:
921: curr_pos := 1;
922: body_len := LENGTH(body);
923: WHILE curr_pos <= body_len LOOP
924: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
925: curr_pos := curr_pos + g_line_size;
926: r := r + 1;
927: END LOOP;
928:

Line 960: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

956:
957: curr_pos := 1;
958: body_len := LENGTH(body);
959: WHILE curr_pos <= body_len LOOP
960: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
961: curr_pos := curr_pos + g_line_size;
962: r := r + 1;
963: END LOOP;
964:

Line 999: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

995:
996: curr_pos := 1;
997: body_len := LENGTH(body);
998: WHILE curr_pos <= body_len LOOP
999: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1000: curr_pos := curr_pos + g_line_size;
1001: r := r + 1;
1002: END LOOP;
1003:

Line 1021: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1017:
1018: curr_pos := 1;
1019: body_len := LENGTH(body);
1020: WHILE curr_pos <= body_len LOOP
1021: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1022: curr_pos := curr_pos + g_line_size;
1023: r := r + 1;
1024: END LOOP;
1025:

Line 1056: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1052:
1053: curr_pos := 1;
1054: body_len := LENGTH(body);
1055: WHILE curr_pos <= body_len LOOP
1056: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1057: curr_pos := curr_pos + g_line_size;
1058: r := r + 1;
1059: END LOOP;
1060:

Line 1092: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1088:
1089: curr_pos := 1;
1090: body_len := LENGTH(body);
1091: WHILE curr_pos <= body_len LOOP
1092: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1093: curr_pos := curr_pos + g_line_size;
1094: r := r + 1;
1095: END LOOP;
1096:

Line 1189: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1185:
1186: curr_pos := 1;
1187: body_len := LENGTH(body);
1188: WHILE curr_pos <= body_len LOOP
1189: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1190: curr_pos := curr_pos + g_line_size;
1191: r := r + 1;
1192: END LOOP;
1193:

Line 1247: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1243:
1244: curr_pos := 1;
1245: body_len := LENGTH(body);
1246: WHILE curr_pos <= body_len LOOP
1247: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1248: curr_pos := curr_pos + g_line_size;
1249: r := r + 1;
1250: END LOOP;
1251:

Line 1377: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1373: ';
1374: curr_pos := 1;
1375: body_len := LENGTH(body);
1376: WHILE curr_pos <= body_len LOOP
1377: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1378: curr_pos := curr_pos + g_line_size;
1379: r := r + 1;
1380: END LOOP;
1381:

Line 1454: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1450:
1451: curr_pos := 1;
1452: body_len := LENGTH(body);
1453: WHILE curr_pos <= body_len LOOP
1454: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1455: curr_pos := curr_pos + g_line_size;
1456: r := r + 1;
1457: END LOOP;
1458: body:=

Line 1568: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);

1564: ';
1565: curr_pos := 1;
1566: body_len := LENGTH(body);
1567: WHILE curr_pos <= body_len LOOP
1568: ad_ddl.build_statement(SUBSTR(body, curr_pos, g_line_size),r);
1569: curr_pos := curr_pos + g_line_size;
1570: r := r + 1;
1571: END LOOP;
1572:

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

Line 1575: -- dbms_output.put_line('Error' || AD_DDL.error_buf);

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
1578: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'CREATE_PACKAGE',
1579: GCS_UTILITY_PKG.g_module_success || 'Create package' ||