APPS.GCS_TRANS_HRATES_DYN_BUILD_PKG dependencies on AD_DDL

Line 126: -- Get APPLSYS information. Needed for ad_ddl

122: BEGIN
123: module := 'CREATE_PACKAGE';
124: module_log_write(module, g_module_enter);
125:
126: -- Get APPLSYS information. Needed for ad_ddl
127: IF NOT fnd_installation.get_app_info('FND', status, industry, appl) THEN
128: raise gcs_ccy_applsys_not_found;
129: END IF;
130:

Line 268: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

264:
265: curr_pos := 1;
266: body_len := LENGTH(body_block);
267: WHILE curr_pos <= body_len LOOP
268: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
269: line_num);
270: curr_pos := curr_pos + g_line_size;
271: line_num := line_num + 1;
272: END LOOP;

Line 300: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

296:
297: curr_pos := 1;
298: body_len := LENGTH(body_block);
299: WHILE curr_pos <= body_len LOOP
300: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
301: line_num);
302: curr_pos := curr_pos + g_line_size;
303: line_num := line_num + 1;
304: END LOOP;

Line 342: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

338:
339: curr_pos := 1;
340: body_len := LENGTH(body_block);
341: WHILE curr_pos <= body_len LOOP
342: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
343: line_num);
344: curr_pos := curr_pos + g_line_size;
345: line_num := line_num + 1;
346: END LOOP;

Line 374: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

370:
371: curr_pos := 1;
372: body_len := LENGTH(body_block);
373: WHILE curr_pos <= body_len LOOP
374: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
375: line_num);
376: curr_pos := curr_pos + g_line_size;
377: line_num := line_num + 1;
378: END LOOP;

Line 418: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

414:
415: curr_pos := 1;
416: body_len := LENGTH(body_block);
417: WHILE curr_pos <= body_len LOOP
418: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
419: line_num);
420: curr_pos := curr_pos + g_line_size;
421: line_num := line_num + 1;
422: END LOOP;

Line 459: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

455:
456: curr_pos := 1;
457: body_len := LENGTH(body_block);
458: WHILE curr_pos <= body_len LOOP
459: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
460: line_num);
461: curr_pos := curr_pos + g_line_size;
462: line_num := line_num + 1;
463: END LOOP;

Line 488: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

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

Line 521: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

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

Line 556: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

552:
553: curr_pos := 1;
554: body_len := LENGTH(body_block);
555: WHILE curr_pos <= body_len LOOP
556: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
557: line_num);
558: curr_pos := curr_pos + g_line_size;
559: line_num := line_num + 1;
560: END LOOP;

Line 590: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

586:
587: curr_pos := 1;
588: body_len := LENGTH(body_block);
589: WHILE curr_pos <= body_len LOOP
590: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
591: line_num);
592: curr_pos := curr_pos + g_line_size;
593: line_num := line_num + 1;
594: END LOOP;

Line 674: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

670:
671: curr_pos := 1;
672: body_len := LENGTH(body_block);
673: WHILE curr_pos <= body_len LOOP
674: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
675: line_num);
676: curr_pos := curr_pos + g_line_size;
677: line_num := line_num + 1;
678: END LOOP;

Line 730: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

726:
727: curr_pos := 1;
728: body_len := LENGTH(body_block);
729: WHILE curr_pos <= body_len LOOP
730: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
731: line_num);
732: curr_pos := curr_pos + g_line_size;
733: line_num := line_num + 1;
734: END LOOP;

Line 753: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

749:
750: curr_pos := 1;
751: body_len := LENGTH(body_block);
752: WHILE curr_pos <= body_len LOOP
753: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
754: line_num);
755: curr_pos := curr_pos + g_line_size;
756: line_num := line_num + 1;
757: END LOOP;

Line 784: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

780:
781: curr_pos := 1;
782: body_len := LENGTH(body_block);
783: WHILE curr_pos <= body_len LOOP
784: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
785: line_num);
786: curr_pos := curr_pos + g_line_size;
787: line_num := line_num + 1;
788: END LOOP;

Line 814: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

810:
811: curr_pos := 1;
812: body_len := LENGTH(body_block);
813: WHILE curr_pos <= body_len LOOP
814: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
815: line_num);
816: curr_pos := curr_pos + g_line_size;
817: line_num := line_num + 1;
818: END LOOP;

Line 870: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

866:
867: curr_pos := 1;
868: body_len := LENGTH(body_block);
869: WHILE curr_pos <= body_len LOOP
870: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
871: line_num);
872: curr_pos := curr_pos + g_line_size;
873: line_num := line_num + 1;
874: END LOOP;

Line 893: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

889:
890: curr_pos := 1;
891: body_len := LENGTH(body_block);
892: WHILE curr_pos <= body_len LOOP
893: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
894: line_num);
895: curr_pos := curr_pos + g_line_size;
896: line_num := line_num + 1;
897: END LOOP;

Line 923: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

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

Line 945: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

941:
942: curr_pos := 1;
943: body_len := LENGTH(body_block);
944: WHILE curr_pos <= body_len LOOP
945: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
946: line_num);
947: curr_pos := curr_pos + g_line_size;
948: line_num := line_num + 1;
949: END LOOP;

Line 976: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

972:
973: curr_pos := 1;
974: body_len := LENGTH(body_block);
975: WHILE curr_pos <= body_len LOOP
976: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
977: line_num);
978: curr_pos := curr_pos + g_line_size;
979: line_num := line_num + 1;
980: END LOOP;

Line 1032: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1028:
1029: curr_pos := 1;
1030: body_len := LENGTH(body_block);
1031: WHILE curr_pos <= body_len LOOP
1032: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1033: line_num);
1034: curr_pos := curr_pos + g_line_size;
1035: line_num := line_num + 1;
1036: END LOOP;

Line 1071: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1067:
1068: curr_pos := 1;
1069: body_len := LENGTH(body_block);
1070: WHILE curr_pos <= body_len LOOP
1071: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1072: line_num);
1073: curr_pos := curr_pos + g_line_size;
1074: line_num := line_num + 1;
1075: END LOOP;

Line 1101: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1097:
1098: curr_pos := 1;
1099: body_len := LENGTH(body_block);
1100: WHILE curr_pos <= body_len LOOP
1101: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1102: line_num);
1103: curr_pos := curr_pos + g_line_size;
1104: line_num := line_num + 1;
1105: END LOOP;

Line 1157: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1153:
1154: curr_pos := 1;
1155: body_len := LENGTH(body_block);
1156: WHILE curr_pos <= body_len LOOP
1157: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1158: line_num);
1159: curr_pos := curr_pos + g_line_size;
1160: line_num := line_num + 1;
1161: END LOOP;

Line 1196: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1192:
1193: curr_pos := 1;
1194: body_len := LENGTH(body_block);
1195: WHILE curr_pos <= body_len LOOP
1196: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1197: line_num);
1198: curr_pos := curr_pos + g_line_size;
1199: line_num := line_num + 1;
1200: END LOOP;

Line 1218: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1214:
1215: curr_pos := 1;
1216: body_len := LENGTH(body_block);
1217: WHILE curr_pos <= body_len LOOP
1218: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1219: line_num);
1220: curr_pos := curr_pos + g_line_size;
1221: line_num := line_num + 1;
1222: END LOOP;

Line 1325: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1321:
1322: curr_pos := 1;
1323: body_len := LENGTH(body_block);
1324: WHILE curr_pos <= body_len LOOP
1325: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1326: line_num);
1327: curr_pos := curr_pos + g_line_size;
1328: line_num := line_num + 1;
1329: END LOOP;

Line 1385: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1381:
1382: curr_pos := 1;
1383: body_len := LENGTH(body_block);
1384: WHILE curr_pos <= body_len LOOP
1385: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1386: line_num);
1387: curr_pos := curr_pos + g_line_size;
1388: line_num := line_num + 1;
1389: END LOOP;

Line 1410: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1406:
1407: curr_pos := 1;
1408: body_len := LENGTH(body_block);
1409: WHILE curr_pos <= body_len LOOP
1410: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1411: line_num);
1412: curr_pos := curr_pos + g_line_size;
1413: line_num := line_num + 1;
1414: END LOOP;

Line 1443: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1439:
1440: curr_pos := 1;
1441: body_len := LENGTH(body_block);
1442: WHILE curr_pos <= body_len LOOP
1443: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1444: line_num);
1445: curr_pos := curr_pos + g_line_size;
1446: line_num := line_num + 1;
1447: END LOOP;

Line 1463: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1459:
1460: curr_pos := 1;
1461: body_len := LENGTH(body_block);
1462: WHILE curr_pos <= body_len LOOP
1463: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1464: line_num);
1465: curr_pos := curr_pos + g_line_size;
1466: line_num := line_num + 1;
1467: END LOOP;

Line 1493: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1489:
1490: curr_pos := 1;
1491: body_len := LENGTH(body_block);
1492: WHILE curr_pos <= body_len LOOP
1493: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1494: line_num);
1495: curr_pos := curr_pos + g_line_size;
1496: line_num := line_num + 1;
1497: END LOOP;

Line 1552: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1548:
1549: curr_pos := 1;
1550: body_len := LENGTH(body_block);
1551: WHILE curr_pos <= body_len LOOP
1552: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1553: line_num);
1554: curr_pos := curr_pos + g_line_size;
1555: line_num := line_num + 1;
1556: END LOOP;

Line 1577: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1573:
1574: curr_pos := 1;
1575: body_len := LENGTH(body_block);
1576: WHILE curr_pos <= body_len LOOP
1577: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1578: line_num);
1579: curr_pos := curr_pos + g_line_size;
1580: line_num := line_num + 1;
1581: END LOOP;

Line 1610: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1606:
1607: curr_pos := 1;
1608: body_len := LENGTH(body_block);
1609: WHILE curr_pos <= body_len LOOP
1610: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1611: line_num);
1612: curr_pos := curr_pos + g_line_size;
1613: line_num := line_num + 1;
1614: END LOOP;

Line 1630: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1626:
1627: curr_pos := 1;
1628: body_len := LENGTH(body_block);
1629: WHILE curr_pos <= body_len LOOP
1630: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1631: line_num);
1632: curr_pos := curr_pos + g_line_size;
1633: line_num := line_num + 1;
1634: END LOOP;

Line 1652: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1648:
1649: curr_pos := 1;
1650: body_len := LENGTH(body_block);
1651: WHILE curr_pos <= body_len LOOP
1652: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1653: line_num);
1654: curr_pos := curr_pos + g_line_size;
1655: line_num := line_num + 1;
1656: END LOOP;

Line 1684: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1680:
1681: curr_pos := 1;
1682: body_len := LENGTH(body_block);
1683: WHILE curr_pos <= body_len LOOP
1684: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1685: line_num);
1686: curr_pos := curr_pos + g_line_size;
1687: line_num := line_num + 1;
1688: END LOOP;

Line 1744: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1740:
1741: curr_pos := 1;
1742: body_len := LENGTH(body_block);
1743: WHILE curr_pos <= body_len LOOP
1744: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1745: line_num);
1746: curr_pos := curr_pos + g_line_size;
1747: line_num := line_num + 1;
1748: END LOOP;

Line 1787: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1783:
1784: curr_pos := 1;
1785: body_len := LENGTH(body_block);
1786: WHILE curr_pos <= body_len LOOP
1787: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1788: line_num);
1789: curr_pos := curr_pos + g_line_size;
1790: line_num := line_num + 1;
1791: END LOOP;

Line 1807: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1803:
1804: curr_pos := 1;
1805: body_len := LENGTH(body_block);
1806: WHILE curr_pos <= body_len LOOP
1807: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1808: line_num);
1809: curr_pos := curr_pos + g_line_size;
1810: line_num := line_num + 1;
1811: END LOOP;

Line 1838: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1834:
1835: curr_pos := 1;
1836: body_len := LENGTH(body_block);
1837: WHILE curr_pos <= body_len LOOP
1838: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1839: line_num);
1840: curr_pos := curr_pos + g_line_size;
1841: line_num := line_num + 1;
1842: END LOOP;

Line 1897: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1893:
1894: curr_pos := 1;
1895: body_len := LENGTH(body_block);
1896: WHILE curr_pos <= body_len LOOP
1897: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1898: line_num);
1899: curr_pos := curr_pos + g_line_size;
1900: line_num := line_num + 1;
1901: END LOOP;

Line 1939: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1935:
1936: curr_pos := 1;
1937: body_len := LENGTH(body_block);
1938: WHILE curr_pos <= body_len LOOP
1939: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1940: line_num);
1941: curr_pos := curr_pos + g_line_size;
1942: line_num := line_num + 1;
1943: END LOOP;

Line 1959: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1955:
1956: curr_pos := 1;
1957: body_len := LENGTH(body_block);
1958: WHILE curr_pos <= body_len LOOP
1959: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1960: line_num);
1961: curr_pos := curr_pos + g_line_size;
1962: line_num := line_num + 1;
1963: END LOOP;

Line 1981: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

1977:
1978: curr_pos := 1;
1979: body_len := LENGTH(body_block);
1980: WHILE curr_pos <= body_len LOOP
1981: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
1982: line_num);
1983: curr_pos := curr_pos + g_line_size;
1984: line_num := line_num + 1;
1985: END LOOP;

Line 2021: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),

2017:
2018: curr_pos := 1;
2019: body_len := LENGTH(body_block);
2020: WHILE curr_pos <= body_len LOOP
2021: ad_ddl.build_statement(SUBSTR(body_block, curr_pos, g_line_size),
2022: line_num);
2023: curr_pos := curr_pos + g_line_size;
2024: line_num := line_num + 1;
2025: END LOOP;

Line 2028: ad_ddl.create_plsql_object(appl, 'APPS', 'GCS_TRANS_HRATES_DYNAMIC_PKG', 1, line_num - 1 , 'FALSE', err);

2024: line_num := line_num + 1;
2025: END LOOP;
2026:
2027:
2028: ad_ddl.create_plsql_object(appl, 'APPS', 'GCS_TRANS_HRATES_DYNAMIC_PKG', 1, line_num - 1 , 'FALSE', err);
2029:
2030:
2031: IF err = 'TRUE' THEN
2032: raise GCS_CCY_DYN_PKG_BUILD_ERR;