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_XML_DYNAMIC_PKG dependencies on AD_DDL

Line 14: ad_ddl.build_statement(' '' ' || p_table_alias || '1.' ||

10: p_xml_file_type IN VARCHAR2) IS
11: BEGIN
12: IF (p_dimension_required = 'Y') THEN
13: IF (p_xml_file_type = 'RULES') THEN
14: ad_ddl.build_statement(' '' ' || p_table_alias || '1.' ||
15: p_display_col_name || ', ''|| g_nl||',
16: p_rownum);
17: p_rownum := p_rownum + 1;
18: ELSE

Line 19: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

15: p_display_col_name || ', ''|| g_nl||',
16: p_rownum);
17: p_rownum := p_rownum + 1;
18: ELSE
19: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
20: p_display_col_name || ', ''|| g_nl||',
21: p_rownum);
22: p_rownum := p_rownum + 1;
23: END IF;

Line 476: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

472: p_rownum IN OUT NOCOPY NUMBER,
473: p_xml_file_type IN VARCHAR2) IS
474: BEGIN
475: IF (p_dimension_required = 'Y') THEN
476: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
477: p_display_col_name || ' ' ||
478: p_display_col_alias || ' , ''|| g_nl||',
479: p_rownum);
480: p_rownum := p_rownum + 1;

Line 492: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

488: DecodeStatement varchar2(1000);
489: BEGIN
490: IF (p_dimension_required = 'Y') THEN
491: IF (p_xml_file_type = 'ENTRY') THEN
492: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
493: p_display_col_name || ' , ''|| g_nl||',
494: p_rownum);
495: p_rownum := p_rownum + 1;
496: ELSIF (p_xml_file_type = 'DSTB') THEN

Line 497: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

493: p_display_col_name || ' , ''|| g_nl||',
494: p_rownum);
495: p_rownum := p_rownum + 1;
496: ELSIF (p_xml_file_type = 'DSTB') THEN
497: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
498: p_display_col_name || ' , ''|| g_nl||',
499: p_rownum);
500: p_rownum := p_rownum + 1;
501: -- Santosh 5234796

Line 503: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

499: p_rownum);
500: p_rownum := p_rownum + 1;
501: -- Santosh 5234796
502: ELSIF (p_xml_file_type = 'DSLOAD') THEN
503: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
504: p_display_col_name || ' , ''|| g_nl||',
505: p_rownum);
506: p_rownum := p_rownum + 1;
507: ELSIF (p_xml_file_type = 'RULES') THEN

Line 508: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

504: p_display_col_name || ' , ''|| g_nl||',
505: p_rownum);
506: p_rownum := p_rownum + 1;
507: ELSIF (p_xml_file_type = 'RULES') THEN
508: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
509: p_display_col_name || ' , ''|| g_nl||',
510: p_rownum);
511: p_rownum := p_rownum + 1;
512: ad_ddl.build_statement(' '' ' || p_table_alias || '1.' ||

Line 512: ad_ddl.build_statement(' '' ' || p_table_alias || '1.' ||

508: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
509: p_display_col_name || ' , ''|| g_nl||',
510: p_rownum);
511: p_rownum := p_rownum + 1;
512: ad_ddl.build_statement(' '' ' || p_table_alias || '1.' ||
513: p_display_col_name || ', ''|| g_nl||',
514: p_rownum);
515: p_rownum := p_rownum + 1;
516: ELSIF (p_xml_file_type = 'DSTBID') THEN

Line 517: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

513: p_display_col_name || ', ''|| g_nl||',
514: p_rownum);
515: p_rownum := p_rownum + 1;
516: ELSIF (p_xml_file_type = 'DSTBID') THEN
517: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
518: p_display_col_name || ', ''|| g_nl||',
519: p_rownum);
520: p_rownum := p_rownum + 1;
521: ELSIF (p_xml_file_type = 'CCIDHASH') THEN

Line 522: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

518: p_display_col_name || ', ''|| g_nl||',
519: p_rownum);
520: p_rownum := p_rownum + 1;
521: ELSIF (p_xml_file_type = 'CCIDHASH') THEN
522: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
523: p_display_col_name || '||' || ' ''''.'''' ' ||
524: '|| ''|| g_nl||',
525: p_rownum);
526: p_rownum := p_rownum + 1;

Line 528: ad_ddl.build_statement(' '' ''|| g_nl||',
530: p_rownum);
531: p_rownum := p_rownum + 1;
532: --fix 5351083

Line 534: ad_ddl.build_statement(' '' 535: replace(p_display_col_name, '_name', '_id') ||
536: '" value="' ||
537: replace(p_display_col_name, '_name', '_id') ||
538: '" /> ''|| g_nl||',

Line 542: ad_ddl.build_statement(' '' ''|| g_nl||',
539: p_rownum);
540: p_rownum := p_rownum + 1;/
541: ELSIF (p_xml_file_type = 'VSMPID') THEN
542: ad_ddl.build_statement(' '' ''||g_nl|| ',
544: p_rownum);
545: p_rownum := p_rownum + 1;
546: ad_ddl.build_statement(' '' ''|| g_nl||',

Line 546: ad_ddl.build_statement(' '' ''|| g_nl||',

542: ad_ddl.build_statement(' '' ''||g_nl|| ',
544: p_rownum);
545: p_rownum := p_rownum + 1;
546: ad_ddl.build_statement(' '' ''|| g_nl||',
547: p_rownum);
548: p_rownum := p_rownum + 1;
549: ad_ddl.build_statement(' '' ''|| g_nl||',
550: p_rownum);

Line 549: ad_ddl.build_statement(' '' ''|| g_nl||',

545: p_rownum := p_rownum + 1;
546: ad_ddl.build_statement(' '' ''|| g_nl||',
547: p_rownum);
548: p_rownum := p_rownum + 1;
549: ad_ddl.build_statement(' '' ''|| g_nl||',
550: p_rownum);
551: p_rownum := p_rownum + 1;
552: ad_ddl.build_statement(' '' ''|| g_nl||',

Line 552: ad_ddl.build_statement(' '' ''|| g_nl||',
550: p_rownum);
551: p_rownum := p_rownum + 1;
552: ad_ddl.build_statement(' '' ''|| g_nl||',
554: p_rownum);
555: p_rownum := p_rownum + 1;
556: ad_ddl.build_statement(' '' ''|| g_nl||',

Line 556: ad_ddl.build_statement(' '' ''|| g_nl||',

552: ad_ddl.build_statement(' '' ''|| g_nl||',
554: p_rownum);
555: p_rownum := p_rownum + 1;
556: ad_ddl.build_statement(' '' ''|| g_nl||',
557: p_rownum);
558: p_rownum := p_rownum + 1;
559: ad_ddl.build_statement(' '' ''|| g_nl||',
560: p_rownum);

Line 559: ad_ddl.build_statement(' '' ''|| g_nl||',

555: p_rownum := p_rownum + 1;
556: ad_ddl.build_statement(' '' ''|| g_nl||',
557: p_rownum);
558: p_rownum := p_rownum + 1;
559: ad_ddl.build_statement(' '' ''|| g_nl||',
560: p_rownum);
561: p_rownum := p_rownum + 1;
562: ad_ddl.build_statement(' '' ''|| g_nl||', p_rownum);
563: p_rownum := p_rownum + 1;

Line 562: ad_ddl.build_statement(' '' ''|| g_nl||', p_rownum);

558: p_rownum := p_rownum + 1;
559: ad_ddl.build_statement(' '' ''|| g_nl||',
560: p_rownum);
561: p_rownum := p_rownum + 1;
562: ad_ddl.build_statement(' '' ''|| g_nl||', p_rownum);
563: p_rownum := p_rownum + 1;
564: ad_ddl.build_statement(' '' ''||g_nl||', p_rownum);
565: p_rownum := p_rownum + 1;
566: -- BUG 5147886

Line 564: ad_ddl.build_statement(' '' ''||g_nl||', p_rownum);

560: p_rownum);
561: p_rownum := p_rownum + 1;
562: ad_ddl.build_statement(' '' ''|| g_nl||', p_rownum);
563: p_rownum := p_rownum + 1;
564: ad_ddl.build_statement(' '' ''||g_nl||', p_rownum);
565: p_rownum := p_rownum + 1;
566: -- BUG 5147886
567: ELSIF (p_xml_file_type = 'NONPOSTED_SELECT' OR
568: p_xml_file_type = 'NONPOSTED_GROUP') THEN

Line 575: ad_ddl.build_statement(' '' ' || DecodeStatement || ',' ||

571: '''''EXPENSE'''',457,100) ';
572:
573: IF (p_display_col_name = 'financial_elem_name') THEN
574: IF (p_xml_file_type = 'NONPOSTED_GROUP') THEN
575: ad_ddl.build_statement(' '' ' || DecodeStatement || ',' ||
576: ' ''||g_nl||',
577: p_rownum);
578: p_rownum := p_rownum + 1;
579: ELSE

Line 580: ad_ddl.build_statement(' '' ' || DecodeStatement ||

576: ' ''||g_nl||',
577: p_rownum);
578: p_rownum := p_rownum + 1;
579: ELSE
580: ad_ddl.build_statement(' '' ' || DecodeStatement ||
581: 'financial_elem_id,' || ' ''||g_nl||',
582: p_rownum);
583: p_rownum := p_rownum + 1;
584: end IF;

Line 586: ad_ddl.build_statement(' '' ' || 'fiocm.' ||

582: p_rownum);
583: p_rownum := p_rownum + 1;
584: end IF;
585: ELSE
586: ad_ddl.build_statement(' '' ' || 'fiocm.' ||
587: replace(p_display_col_name,
588: '_name',
589: '_id') || ' , ''|| g_nl||',
590: p_rownum);

Line 594: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||

590: p_rownum);
591: p_rownum := p_rownum + 1;
592: END IF;
593: ELSE
594: ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
595: p_display_col_name ||
596: ' dimension_data, ''|| g_nl||',
597: p_rownum);
598: p_rownum := p_rownum + 1;

Line 610: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||

606: p_xml_file_type IN VARCHAR2) IS
607: BEGIN
608: IF (p_dimension_required = 'Y') THEN
609: IF (p_xml_file_type = 'ENTRY') THEN
610: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||
611: p_column_id || ' = gel.' || p_column_id ||
612: ' '' || g_nl|| ',
613: p_rownum);
614: p_rownum := p_rownum + 1;

Line 615: ad_ddl.build_statement(' '' AND ' || p_table_alias ||

611: p_column_id || ' = gel.' || p_column_id ||
612: ' '' || g_nl|| ',
613: p_rownum);
614: p_rownum := p_rownum + 1;
615: ad_ddl.build_statement(' '' AND ' || p_table_alias ||
616: '.language = :pLanguageCode' ||
617: ''' || g_nl||',
618: p_rownum);
619: p_rownum := p_rownum + 1;

Line 622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;

618: p_rownum);
619: p_rownum := p_rownum + 1;
620: -- Santosh 5234796
621: /ELSIF (p_xml_file_type = 'DSLOAD') THEN
622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;
624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;

Line 623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;

619: p_rownum := p_rownum + 1;
620: -- Santosh 5234796
621: /ELSIF (p_xml_file_type = 'DSLOAD') THEN
622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;
624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;
627: /

Line 624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;

620: -- Santosh 5234796
621: /ELSIF (p_xml_file_type = 'DSLOAD') THEN
622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;
624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;
627: /
628: ELSIF (p_xml_file_type <> 'RULES') THEN

Line 625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;

621: /ELSIF (p_xml_file_type = 'DSLOAD') THEN
622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;
624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;
627: /
628: ELSIF (p_xml_file_type <> 'RULES') THEN
629: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||

Line 626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;

622: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' || p_column_id || 'display_code = gbit.' || p_column_id || 'display_code '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
623: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.value_set_id = :p'||p_table_alias || 'ValueSetId'' || g_nl||', p_rownum); p_rownum := p_rownum+1;
624: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.' || p_column_id || 'id = ' || p_table_alias || '.' || p_column_id || 'id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;
627: /
628: ELSIF (p_xml_file_type <> 'RULES') THEN
629: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||
630: p_column_id || ' = fb.' || p_column_id ||

Line 629: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||

625: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.value_set_id = '||p_table_alias || '.value_set_id '' || g_nl||', p_rownum); p_rownum := p_rownum+1;
626: ad_ddl.build_statement(' '' AND ' || p_table_alias || 't.language = :pLanguageCode' || ''' || g_nl||', p_rownum); p_rownum := p_rownum+1;
627: /
628: ELSIF (p_xml_file_type <> 'RULES') THEN
629: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||
630: p_column_id || ' = fb.' || p_column_id ||
631: ' '' || g_nl||',
632: p_rownum);
633: p_rownum := p_rownum + 1;

Line 634: ad_ddl.build_statement(' '' AND ' || p_table_alias ||

630: p_column_id || ' = fb.' || p_column_id ||
631: ' '' || g_nl||',
632: p_rownum);
633: p_rownum := p_rownum + 1;
634: ad_ddl.build_statement(' '' AND ' || p_table_alias ||
635: '.language = :pLanguageCode' ||
636: ''' || g_nl||',
637: p_rownum);
638: p_rownum := p_rownum + 1;

Line 641: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||

637: p_rownum);
638: p_rownum := p_rownum + 1;
639: END IF;
640: IF (p_xml_file_type = 'RULES') THEN
641: ad_ddl.build_statement(' '' AND ' || p_table_alias || '.' ||
642: p_column_id || ' = gel.src_' || p_column_id ||
643: ' '' || g_nl||',
644: p_rownum);
645: p_rownum := p_rownum + 1;

Line 646: ad_ddl.build_statement(' '' AND ' || p_table_alias || '1.' ||

642: p_column_id || ' = gel.src_' || p_column_id ||
643: ' '' || g_nl||',
644: p_rownum);
645: p_rownum := p_rownum + 1;
646: ad_ddl.build_statement(' '' AND ' || p_table_alias || '1.' ||
647: p_column_id || ' = gel.tgt_' || p_column_id ||
648: ' '' || g_nl||',
649: p_rownum);
650: p_rownum := p_rownum + 1;

Line 1622: ad_ddl.build_statement(''' ' || p_table_name || ' ' ||

1618: p_rownum IN OUT NOCOPY NUMBER,
1619: p_xml_file_type IN VARCHAR2) IS
1620: BEGIN
1621: IF (p_dimension_required = 'Y') THEN
1622: ad_ddl.build_statement(''' ' || p_table_name || ' ' ||
1623: p_table_alias || ', '' ||g_nl||',
1624: p_rownum);
1625: p_rownum := p_rownum + 1;
1626: IF (p_xml_file_type = 'RULES') THEN

Line 1627: ad_ddl.build_statement(''' ' || p_table_name || ' ' ||

1623: p_table_alias || ', '' ||g_nl||',
1624: p_rownum);
1625: p_rownum := p_rownum + 1;
1626: IF (p_xml_file_type = 'RULES') THEN
1627: ad_ddl.build_statement(''' ' || p_table_name || ' ' ||
1628: p_table_alias || '1, '' ||g_nl||',
1629: p_rownum);
1630: p_rownum := p_rownum + 1;
1631: END IF;

Line 2039: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_XML_UTILITY_PKG AS',

2035: PROCEDURE create_xml_utility_PKG(p_retcode NUMBER, p_errbuf VARCHAR2) IS
2036: r NUMBER(15) := 1;
2037: comp_err VARCHAR2(200) := NULL;
2038: BEGIN
2039: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_XML_UTILITY_PKG AS',
2040: r);
2041: r := r + 1;
2042: ad_ddl.build_statement(' ', r);
2043: r := r + 1;

Line 2042: ad_ddl.build_statement(' ', r);

2038: BEGIN
2039: ad_ddl.build_statement('CREATE OR REPLACE PACKAGE GCS_XML_UTILITY_PKG AS',
2040: r);
2041: r := r + 1;
2042: ad_ddl.build_statement(' ', r);
2043: r := r + 1;
2044: ad_ddl.build_statement('--API Name', r);
2045: r := r + 1;
2046: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_XML_UTILITY_PKG'';',

Line 2044: ad_ddl.build_statement('--API Name', r);

2040: r);
2041: r := r + 1;
2042: ad_ddl.build_statement(' ', r);
2043: r := r + 1;
2044: ad_ddl.build_statement('--API Name', r);
2045: r := r + 1;
2046: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_XML_UTILITY_PKG'';',
2047: r);
2048: r := r + 1;

Line 2046: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_XML_UTILITY_PKG'';',

2042: ad_ddl.build_statement(' ', r);
2043: r := r + 1;
2044: ad_ddl.build_statement('--API Name', r);
2045: r := r + 1;
2046: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_XML_UTILITY_PKG'';',
2047: r);
2048: r := r + 1;
2049: ad_ddl.build_statement(' g_nl VARCHAR2(1) := ''
2050: '';',

Line 2049: ad_ddl.build_statement(' g_nl VARCHAR2(1) := ''

2045: r := r + 1;
2046: ad_ddl.build_statement(' g_api VARCHAR2(50) := ''gcs.plsql.GCS_XML_UTILITY_PKG'';',
2047: r);
2048: r := r + 1;
2049: ad_ddl.build_statement(' g_nl VARCHAR2(1) := ''
2050: '';',
2051: r);
2052: r := r + 1;
2053: ad_ddl.build_statement(' ', r);

Line 2053: ad_ddl.build_statement(' ', r);

2049: ad_ddl.build_statement(' g_nl VARCHAR2(1) := ''
2050: '';',
2051: r);
2052: r := r + 1;
2053: ad_ddl.build_statement(' ', r);
2054: r := r + 1;
2055: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for',
2056: r);
2057: r := r + 1;

Line 2055: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for',

2051: r);
2052: r := r + 1;
2053: ad_ddl.build_statement(' ', r);
2054: r := r + 1;
2055: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for',
2056: r);
2057: r := r + 1;
2058: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r);
2059: r := r + 1;

Line 2058: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r);

2054: r := r + 1;
2055: ad_ddl.build_statement(' -- Action types for writing module information to the log file. Used for',
2056: r);
2057: r := r + 1;
2058: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r);
2059: r := r + 1;
2060: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r);
2061: r := r + 1;
2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);

Line 2060: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r);

2056: r);
2057: r := r + 1;
2058: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r);
2059: r := r + 1;
2060: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r);
2061: r := r + 1;
2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);
2063: r := r + 1;
2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := ''

Line 2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);

2058: ad_ddl.build_statement(' -- the procedure log_file_module_write.', r);
2059: r := r + 1;
2060: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r);
2061: r := r + 1;
2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);
2063: r := r + 1;
2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 2065: r := r + 1;
2066: ad_ddl.build_statement(' ', r);

Line 2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := ''
2060: ad_ddl.build_statement(' g_module_enter VARCHAR2(2) := ''>>'';', r);
2061: r := r + 1;
2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);
2063: r := r + 1;
2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 2065: r := r + 1;
2066: ad_ddl.build_statement(' ', r);
2067: r := r + 1;
2068: ad_ddl.build_statement('-- Beginning of private procedures ', r);

Line 2066: ad_ddl.build_statement(' ', r);

2062: ad_ddl.build_statement(' g_module_success VARCHAR2(2) := ''<<'';', r);
2063: r := r + 1;
2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 2065: r := r + 1;
2066: ad_ddl.build_statement(' ', r);
2067: r := r + 1;
2068: ad_ddl.build_statement('-- Beginning of private procedures ', r);
2069: r := r + 1;
2070: ad_ddl.build_statement(' ', r);

Line 2068: ad_ddl.build_statement('-- Beginning of private procedures ', r);

2064: ad_ddl.build_statement(' g_module_failure VARCHAR2(2) := '' 2065: r := r + 1;
2066: ad_ddl.build_statement(' ', r);
2067: r := r + 1;
2068: ad_ddl.build_statement('-- Beginning of private procedures ', r);
2069: r := r + 1;
2070: ad_ddl.build_statement(' ', r);
2071: r := r + 1;
2072: -- Create select list for GCS Active Dims

Line 2070: ad_ddl.build_statement(' ', r);

2066: ad_ddl.build_statement(' ', r);
2067: r := r + 1;
2068: ad_ddl.build_statement('-- Beginning of private procedures ', r);
2069: r := r + 1;
2070: ad_ddl.build_statement(' ', r);
2071: r := r + 1;
2072: -- Create select list for GCS Active Dims
2073: ad_ddl.build_statement(' g_gcs_dims_select_list VARCHAR2(2000) := ',
2074: r);

Line 2073: ad_ddl.build_statement(' g_gcs_dims_select_list VARCHAR2(2000) := ',

2069: r := r + 1;
2070: ad_ddl.build_statement(' ', r);
2071: r := r + 1;
2072: -- Create select list for GCS Active Dims
2073: ad_ddl.build_statement(' g_gcs_dims_select_list VARCHAR2(2000) := ',
2074: r);
2075: r := r + 1;
2076: build_select_clause_list(r, 'ENTRY');
2077: ad_ddl.build_statement(' '' ''; ', r);

Line 2077: ad_ddl.build_statement(' '' ''; ', r);

2073: ad_ddl.build_statement(' g_gcs_dims_select_list VARCHAR2(2000) := ',
2074: r);
2075: r := r + 1;
2076: build_select_clause_list(r, 'ENTRY');
2077: ad_ddl.build_statement(' '' ''; ', r);
2078: r := r + 1;
2079: ad_ddl.build_statement(' ', r);
2080: r := r + 1;
2081: ad_ddl.build_statement(' g_gcs_dims_table_list VARCHAR2(2000) := ', r);

Line 2079: ad_ddl.build_statement(' ', r);

2075: r := r + 1;
2076: build_select_clause_list(r, 'ENTRY');
2077: ad_ddl.build_statement(' '' ''; ', r);
2078: r := r + 1;
2079: ad_ddl.build_statement(' ', r);
2080: r := r + 1;
2081: ad_ddl.build_statement(' g_gcs_dims_table_list VARCHAR2(2000) := ', r);
2082: r := r + 1;
2083: build_table_list(r, 'ENTRY');

Line 2081: ad_ddl.build_statement(' g_gcs_dims_table_list VARCHAR2(2000) := ', r);

2077: ad_ddl.build_statement(' '' ''; ', r);
2078: r := r + 1;
2079: ad_ddl.build_statement(' ', r);
2080: r := r + 1;
2081: ad_ddl.build_statement(' g_gcs_dims_table_list VARCHAR2(2000) := ', r);
2082: r := r + 1;
2083: build_table_list(r, 'ENTRY');
2084: ad_ddl.build_statement(' '' ''; ', r);
2085: r := r + 1;

Line 2084: ad_ddl.build_statement(' '' ''; ', r);

2080: r := r + 1;
2081: ad_ddl.build_statement(' g_gcs_dims_table_list VARCHAR2(2000) := ', r);
2082: r := r + 1;
2083: build_table_list(r, 'ENTRY');
2084: ad_ddl.build_statement(' '' ''; ', r);
2085: r := r + 1;
2086: ad_ddl.build_statement(' ', r);
2087: r := r + 1;
2088: ad_ddl.build_statement(' g_gcs_dims_where_clause VARCHAR2(10000) := ',

Line 2086: ad_ddl.build_statement(' ', r);

2082: r := r + 1;
2083: build_table_list(r, 'ENTRY');
2084: ad_ddl.build_statement(' '' ''; ', r);
2085: r := r + 1;
2086: ad_ddl.build_statement(' ', r);
2087: r := r + 1;
2088: ad_ddl.build_statement(' g_gcs_dims_where_clause VARCHAR2(10000) := ',
2089: r);
2090: r := r + 1;

Line 2088: ad_ddl.build_statement(' g_gcs_dims_where_clause VARCHAR2(10000) := ',

2084: ad_ddl.build_statement(' '' ''; ', r);
2085: r := r + 1;
2086: ad_ddl.build_statement(' ', r);
2087: r := r + 1;
2088: ad_ddl.build_statement(' g_gcs_dims_where_clause VARCHAR2(10000) := ',
2089: r);
2090: r := r + 1;
2091: build_where_clause_list(r, 'ENTRY');
2092: ad_ddl.build_statement(' '' ''; ', r);

Line 2092: ad_ddl.build_statement(' '' ''; ', r);

2088: ad_ddl.build_statement(' g_gcs_dims_where_clause VARCHAR2(10000) := ',
2089: r);
2090: r := r + 1;
2091: build_where_clause_list(r, 'ENTRY');
2092: ad_ddl.build_statement(' '' ''; ', r);
2093: r := r + 1;
2094: ad_ddl.build_statement(' ', r);
2095: r := r + 1;
2096: ad_ddl.build_statement(' g_gcs_dims_xml_elem VARCHAR2(2000) := ', r);

Line 2094: ad_ddl.build_statement(' ', r);

2090: r := r + 1;
2091: build_where_clause_list(r, 'ENTRY');
2092: ad_ddl.build_statement(' '' ''; ', r);
2093: r := r + 1;
2094: ad_ddl.build_statement(' ', r);
2095: r := r + 1;
2096: ad_ddl.build_statement(' g_gcs_dims_xml_elem VARCHAR2(2000) := ', r);
2097: r := r + 1;
2098: build_select_clause_list(r, 'ENTRY_XML');

Line 2096: ad_ddl.build_statement(' g_gcs_dims_xml_elem VARCHAR2(2000) := ', r);

2092: ad_ddl.build_statement(' '' ''; ', r);
2093: r := r + 1;
2094: ad_ddl.build_statement(' ', r);
2095: r := r + 1;
2096: ad_ddl.build_statement(' g_gcs_dims_xml_elem VARCHAR2(2000) := ', r);
2097: r := r + 1;
2098: build_select_clause_list(r, 'ENTRY_XML');
2099: ad_ddl.build_statement(' '' ''; ', r);
2100: r := r + 1;

Line 2099: ad_ddl.build_statement(' '' ''; ', r);

2095: r := r + 1;
2096: ad_ddl.build_statement(' g_gcs_dims_xml_elem VARCHAR2(2000) := ', r);
2097: r := r + 1;
2098: build_select_clause_list(r, 'ENTRY_XML');
2099: ad_ddl.build_statement(' '' ''; ', r);
2100: r := r + 1;
2101: ad_ddl.build_statement(' ', r);
2102: r := r + 1;
2103: ad_ddl.build_statement(' g_gcs_vsmp_xml_elem VARCHAR2(10000) := ', r);

Line 2101: ad_ddl.build_statement(' ', r);

2097: r := r + 1;
2098: build_select_clause_list(r, 'ENTRY_XML');
2099: ad_ddl.build_statement(' '' ''; ', r);
2100: r := r + 1;
2101: ad_ddl.build_statement(' ', r);
2102: r := r + 1;
2103: ad_ddl.build_statement(' g_gcs_vsmp_xml_elem VARCHAR2(10000) := ', r);
2104: r := r + 1;
2105: build_select_clause_list(r, 'VSMPID');

Line 2103: ad_ddl.build_statement(' g_gcs_vsmp_xml_elem VARCHAR2(10000) := ', r);

2099: ad_ddl.build_statement(' '' ''; ', r);
2100: r := r + 1;
2101: ad_ddl.build_statement(' ', r);
2102: r := r + 1;
2103: ad_ddl.build_statement(' g_gcs_vsmp_xml_elem VARCHAR2(10000) := ', r);
2104: r := r + 1;
2105: build_select_clause_list(r, 'VSMPID');
2106: ad_ddl.build_statement(' '' ''; ', r);
2107: r := r + 1;

Line 2106: ad_ddl.build_statement(' '' ''; ', r);

2102: r := r + 1;
2103: ad_ddl.build_statement(' g_gcs_vsmp_xml_elem VARCHAR2(10000) := ', r);
2104: r := r + 1;
2105: build_select_clause_list(r, 'VSMPID');
2106: ad_ddl.build_statement(' '' ''; ', r);
2107: r := r + 1;
2108: ad_ddl.build_statement(' ', r);
2109: r := r + 1;
2110: -- Create select list for FEM Active Dims

Line 2108: ad_ddl.build_statement(' ', r);

2104: r := r + 1;
2105: build_select_clause_list(r, 'VSMPID');
2106: ad_ddl.build_statement(' '' ''; ', r);
2107: r := r + 1;
2108: ad_ddl.build_statement(' ', r);
2109: r := r + 1;
2110: -- Create select list for FEM Active Dims
2111: ad_ddl.build_statement(' g_fem_dims_select_list_dsload VARCHAR2(2000) := ',
2112: r);

Line 2111: ad_ddl.build_statement(' g_fem_dims_select_list_dsload VARCHAR2(2000) := ',

2107: r := r + 1;
2108: ad_ddl.build_statement(' ', r);
2109: r := r + 1;
2110: -- Create select list for FEM Active Dims
2111: ad_ddl.build_statement(' g_fem_dims_select_list_dsload VARCHAR2(2000) := ',
2112: r);
2113: r := r + 1;
2114: build_select_clause_list(r, 'DSLOAD');
2115: ad_ddl.build_statement(' '' ''; ', r);

Line 2115: ad_ddl.build_statement(' '' ''; ', r);

2111: ad_ddl.build_statement(' g_fem_dims_select_list_dsload VARCHAR2(2000) := ',
2112: r);
2113: r := r + 1;
2114: build_select_clause_list(r, 'DSLOAD');
2115: ad_ddl.build_statement(' '' ''; ', r);
2116: r := r + 1;
2117: ad_ddl.build_statement(' ', r);
2118: r := r + 1;
2119: ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',

Line 2117: ad_ddl.build_statement(' ', r);

2113: r := r + 1;
2114: build_select_clause_list(r, 'DSLOAD');
2115: ad_ddl.build_statement(' '' ''; ', r);
2116: r := r + 1;
2117: ad_ddl.build_statement(' ', r);
2118: r := r + 1;
2119: ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',
2120: r);
2121: r := r + 1;

Line 2119: ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',

2115: ad_ddl.build_statement(' '' ''; ', r);
2116: r := r + 1;
2117: ad_ddl.build_statement(' ', r);
2118: r := r + 1;
2119: ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',
2120: r);
2121: r := r + 1;
2122: build_select_clause_list(r, 'DSTB');
2123: ad_ddl.build_statement(' '' ''; ', r);

Line 2123: ad_ddl.build_statement(' '' ''; ', r);

2119: ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',
2120: r);
2121: r := r + 1;
2122: build_select_clause_list(r, 'DSTB');
2123: ad_ddl.build_statement(' '' ''; ', r);
2124: r := r + 1;
2125: ad_ddl.build_statement(' ', r);
2126: r := r + 1;
2127: --fix 5351083

Line 2125: ad_ddl.build_statement(' ', r);

2121: r := r + 1;
2122: build_select_clause_list(r, 'DSTB');
2123: ad_ddl.build_statement(' '' ''; ', r);
2124: r := r + 1;
2125: ad_ddl.build_statement(' ', r);
2126: r := r + 1;
2127: --fix 5351083
2128: --ad_ddl.build_statement(' g_fem_dims_table_list_dsload VARCHAR2(2000) := ', r);
2129: --r := r + 1;

Line 2128: --ad_ddl.build_statement(' g_fem_dims_table_list_dsload VARCHAR2(2000) := ', r);

2124: r := r + 1;
2125: ad_ddl.build_statement(' ', r);
2126: r := r + 1;
2127: --fix 5351083
2128: --ad_ddl.build_statement(' g_fem_dims_table_list_dsload VARCHAR2(2000) := ', r);
2129: --r := r + 1;
2130: --build_table_list(r, 'DSLOAD');
2131: --ad_ddl.build_statement(' '' ''; ', r);
2132: --r := r + 1;

Line 2131: --ad_ddl.build_statement(' '' ''; ', r);

2127: --fix 5351083
2128: --ad_ddl.build_statement(' g_fem_dims_table_list_dsload VARCHAR2(2000) := ', r);
2129: --r := r + 1;
2130: --build_table_list(r, 'DSLOAD');
2131: --ad_ddl.build_statement(' '' ''; ', r);
2132: --r := r + 1;
2133: ad_ddl.build_statement(' ', r);
2134: r := r + 1;
2135: ad_ddl.build_statement(' g_fem_dims_table_list_dstb VARCHAR2(2000) := ',

Line 2133: ad_ddl.build_statement(' ', r);

2129: --r := r + 1;
2130: --build_table_list(r, 'DSLOAD');
2131: --ad_ddl.build_statement(' '' ''; ', r);
2132: --r := r + 1;
2133: ad_ddl.build_statement(' ', r);
2134: r := r + 1;
2135: ad_ddl.build_statement(' g_fem_dims_table_list_dstb VARCHAR2(2000) := ',
2136: r);
2137: r := r + 1;

Line 2135: ad_ddl.build_statement(' g_fem_dims_table_list_dstb VARCHAR2(2000) := ',

2131: --ad_ddl.build_statement(' '' ''; ', r);
2132: --r := r + 1;
2133: ad_ddl.build_statement(' ', r);
2134: r := r + 1;
2135: ad_ddl.build_statement(' g_fem_dims_table_list_dstb VARCHAR2(2000) := ',
2136: r);
2137: r := r + 1;
2138: build_table_list(r, 'DSTB');
2139: ad_ddl.build_statement(' '' ''; ', r);

Line 2139: ad_ddl.build_statement(' '' ''; ', r);

2135: ad_ddl.build_statement(' g_fem_dims_table_list_dstb VARCHAR2(2000) := ',
2136: r);
2137: r := r + 1;
2138: build_table_list(r, 'DSTB');
2139: ad_ddl.build_statement(' '' ''; ', r);
2140: r := r + 1;
2141: ad_ddl.build_statement(' ', r);
2142: r := r + 1;
2143: ad_ddl.build_statement(' g_fem_dims_dstb_where_clause VARCHAR2(2000) := ',

Line 2141: ad_ddl.build_statement(' ', r);

2137: r := r + 1;
2138: build_table_list(r, 'DSTB');
2139: ad_ddl.build_statement(' '' ''; ', r);
2140: r := r + 1;
2141: ad_ddl.build_statement(' ', r);
2142: r := r + 1;
2143: ad_ddl.build_statement(' g_fem_dims_dstb_where_clause VARCHAR2(2000) := ',
2144: r);
2145: r := r + 1;

Line 2143: ad_ddl.build_statement(' g_fem_dims_dstb_where_clause VARCHAR2(2000) := ',

2139: ad_ddl.build_statement(' '' ''; ', r);
2140: r := r + 1;
2141: ad_ddl.build_statement(' ', r);
2142: r := r + 1;
2143: ad_ddl.build_statement(' g_fem_dims_dstb_where_clause VARCHAR2(2000) := ',
2144: r);
2145: r := r + 1;
2146: build_where_clause_list(r, 'DSTB');
2147: ad_ddl.build_statement(' '' ''; ', r);

Line 2147: ad_ddl.build_statement(' '' ''; ', r);

2143: ad_ddl.build_statement(' g_fem_dims_dstb_where_clause VARCHAR2(2000) := ',
2144: r);
2145: r := r + 1;
2146: build_where_clause_list(r, 'DSTB');
2147: ad_ddl.build_statement(' '' ''; ', r);
2148: r := r + 1;
2149: ad_ddl.build_statement(' ', r);
2150: r := r + 1;
2151: --fix 5351083

Line 2149: ad_ddl.build_statement(' ', r);

2145: r := r + 1;
2146: build_where_clause_list(r, 'DSTB');
2147: ad_ddl.build_statement(' '' ''; ', r);
2148: r := r + 1;
2149: ad_ddl.build_statement(' ', r);
2150: r := r + 1;
2151: --fix 5351083
2152: --ad_ddl.build_statement(' g_fem_dims_dsload_where_clause VARCHAR2(10000) := ', r);
2153: --r := r + 1;

Line 2152: --ad_ddl.build_statement(' g_fem_dims_dsload_where_clause VARCHAR2(10000) := ', r);

2148: r := r + 1;
2149: ad_ddl.build_statement(' ', r);
2150: r := r + 1;
2151: --fix 5351083
2152: --ad_ddl.build_statement(' g_fem_dims_dsload_where_clause VARCHAR2(10000) := ', r);
2153: --r := r + 1;
2154: --build_where_clause_list(r, 'DSLOAD');
2155: --ad_ddl.build_statement(' '' ''; ', r);
2156: --r := r + 1;

Line 2155: --ad_ddl.build_statement(' '' ''; ', r);

2151: --fix 5351083
2152: --ad_ddl.build_statement(' g_fem_dims_dsload_where_clause VARCHAR2(10000) := ', r);
2153: --r := r + 1;
2154: --build_where_clause_list(r, 'DSLOAD');
2155: --ad_ddl.build_statement(' '' ''; ', r);
2156: --r := r + 1;
2157: ad_ddl.build_statement(' ', r);
2158: r := r + 1;
2159: ad_ddl.build_statement(' g_fem_dims_xml_elem VARCHAR2(2000) := ', r);

Line 2157: ad_ddl.build_statement(' ', r);

2153: --r := r + 1;
2154: --build_where_clause_list(r, 'DSLOAD');
2155: --ad_ddl.build_statement(' '' ''; ', r);
2156: --r := r + 1;
2157: ad_ddl.build_statement(' ', r);
2158: r := r + 1;
2159: ad_ddl.build_statement(' g_fem_dims_xml_elem VARCHAR2(2000) := ', r);
2160: r := r + 1;
2161: build_select_clause_list(r, 'DSTB_XML');

Line 2159: ad_ddl.build_statement(' g_fem_dims_xml_elem VARCHAR2(2000) := ', r);

2155: --ad_ddl.build_statement(' '' ''; ', r);
2156: --r := r + 1;
2157: ad_ddl.build_statement(' ', r);
2158: r := r + 1;
2159: ad_ddl.build_statement(' g_fem_dims_xml_elem VARCHAR2(2000) := ', r);
2160: r := r + 1;
2161: build_select_clause_list(r, 'DSTB_XML');
2162: ad_ddl.build_statement(' '' ''; ', r);
2163: r := r + 1;

Line 2162: ad_ddl.build_statement(' '' ''; ', r);

2158: r := r + 1;
2159: ad_ddl.build_statement(' g_fem_dims_xml_elem VARCHAR2(2000) := ', r);
2160: r := r + 1;
2161: build_select_clause_list(r, 'DSTB_XML');
2162: ad_ddl.build_statement(' '' ''; ', r);
2163: r := r + 1;
2164: --fix 5351083
2165: --ad_ddl.build_statement(' p_element_list_dstb VARCHAR2(2000) := ', r);
2166: --r := r + 1;

Line 2165: --ad_ddl.build_statement(' p_element_list_dstb VARCHAR2(2000) := ', r);

2161: build_select_clause_list(r, 'DSTB_XML');
2162: ad_ddl.build_statement(' '' ''; ', r);
2163: r := r + 1;
2164: --fix 5351083
2165: --ad_ddl.build_statement(' p_element_list_dstb VARCHAR2(2000) := ', r);
2166: --r := r + 1;
2167: --build_select_clause_list(r, 'DSTB_XML_ID');
2168: --ad_ddl.build_statement(' '' ''; ', r);
2169: --r := r + 1;

Line 2168: --ad_ddl.build_statement(' '' ''; ', r);

2164: --fix 5351083
2165: --ad_ddl.build_statement(' p_element_list_dstb VARCHAR2(2000) := ', r);
2166: --r := r + 1;
2167: --build_select_clause_list(r, 'DSTB_XML_ID');
2168: --ad_ddl.build_statement(' '' ''; ', r);
2169: --r := r + 1;
2170: ad_ddl.build_statement(' g_group_by_stmnt VARCHAR2(1000) := ', r);
2171: r := r + 1;
2172: build_order_clause_list(r, 'OGL');

Line 2170: ad_ddl.build_statement(' g_group_by_stmnt VARCHAR2(1000) := ', r);

2166: --r := r + 1;
2167: --build_select_clause_list(r, 'DSTB_XML_ID');
2168: --ad_ddl.build_statement(' '' ''; ', r);
2169: --r := r + 1;
2170: ad_ddl.build_statement(' g_group_by_stmnt VARCHAR2(1000) := ', r);
2171: r := r + 1;
2172: build_order_clause_list(r, 'OGL');
2173: ad_ddl.build_statement(' '' ''; ', r);
2174: r := r + 1;

Line 2173: ad_ddl.build_statement(' '' ''; ', r);

2169: --r := r + 1;
2170: ad_ddl.build_statement(' g_group_by_stmnt VARCHAR2(1000) := ', r);
2171: r := r + 1;
2172: build_order_clause_list(r, 'OGL');
2173: ad_ddl.build_statement(' '' ''; ', r);
2174: r := r + 1;
2175: ad_ddl.build_statement(' ', r);
2176: r := r + 1;
2177:

Line 2175: ad_ddl.build_statement(' ', r);

2171: r := r + 1;
2172: build_order_clause_list(r, 'OGL');
2173: ad_ddl.build_statement(' '' ''; ', r);
2174: r := r + 1;
2175: ad_ddl.build_statement(' ', r);
2176: r := r + 1;
2177:
2178: --BUG 5147886
2179: ad_ddl.build_statement(' g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',

Line 2179: ad_ddl.build_statement(' g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',

2175: ad_ddl.build_statement(' ', r);
2176: r := r + 1;
2177:
2178: --BUG 5147886
2179: ad_ddl.build_statement(' g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',
2180: r);
2181: r := r + 1;
2182: build_select_clause_list(r, 'NONPOSTED_SELECT');
2183: ad_ddl.build_statement(' '' ''; ', r);

Line 2183: ad_ddl.build_statement(' '' ''; ', r);

2179: ad_ddl.build_statement(' g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',
2180: r);
2181: r := r + 1;
2182: build_select_clause_list(r, 'NONPOSTED_SELECT');
2183: ad_ddl.build_statement(' '' ''; ', r);
2184: r := r + 1;
2185: ad_ddl.build_statement(' ', r);
2186: r := r + 1;
2187:

Line 2185: ad_ddl.build_statement(' ', r);

2181: r := r + 1;
2182: build_select_clause_list(r, 'NONPOSTED_SELECT');
2183: ad_ddl.build_statement(' '' ''; ', r);
2184: r := r + 1;
2185: ad_ddl.build_statement(' ', r);
2186: r := r + 1;
2187:
2188: ad_ddl.build_statement(' g_fem_nonposted_group_stmnt VARCHAR2(5000) := ',
2189: r);

Line 2188: ad_ddl.build_statement(' g_fem_nonposted_group_stmnt VARCHAR2(5000) := ',

2184: r := r + 1;
2185: ad_ddl.build_statement(' ', r);
2186: r := r + 1;
2187:
2188: ad_ddl.build_statement(' g_fem_nonposted_group_stmnt VARCHAR2(5000) := ',
2189: r);
2190: r := r + 1;
2191: build_select_clause_list(r, 'NONPOSTED_GROUP');
2192: ad_ddl.build_statement(' '' ''; ', r);

Line 2192: ad_ddl.build_statement(' '' ''; ', r);

2188: ad_ddl.build_statement(' g_fem_nonposted_group_stmnt VARCHAR2(5000) := ',
2189: r);
2190: r := r + 1;
2191: build_select_clause_list(r, 'NONPOSTED_GROUP');
2192: ad_ddl.build_statement(' '' ''; ', r);
2193: r := r + 1;
2194: ad_ddl.build_statement(' ', r);
2195: r := r + 1;
2196:

Line 2194: ad_ddl.build_statement(' ', r);

2190: r := r + 1;
2191: build_select_clause_list(r, 'NONPOSTED_GROUP');
2192: ad_ddl.build_statement(' '' ''; ', r);
2193: r := r + 1;
2194: ad_ddl.build_statement(' ', r);
2195: r := r + 1;
2196:
2197: --Santosh
2198: ad_ddl.build_statement(' g_fem_dims_dsload_order_clause VARCHAR2(1000) := ', r);

Line 2198: ad_ddl.build_statement(' g_fem_dims_dsload_order_clause VARCHAR2(1000) := ', r);

2194: ad_ddl.build_statement(' ', r);
2195: r := r + 1;
2196:
2197: --Santosh
2198: ad_ddl.build_statement(' g_fem_dims_dsload_order_clause VARCHAR2(1000) := ', r);
2199: r := r + 1;
2200: build_order_clause_list(r, 'DSLOAD');
2201: ad_ddl.build_statement(' '' ''; ', r);
2202: r := r + 1;

Line 2201: ad_ddl.build_statement(' '' ''; ', r);

2197: --Santosh
2198: ad_ddl.build_statement(' g_fem_dims_dsload_order_clause VARCHAR2(1000) := ', r);
2199: r := r + 1;
2200: build_order_clause_list(r, 'DSLOAD');
2201: ad_ddl.build_statement(' '' ''; ', r);
2202: r := r + 1;
2203: ad_ddl.build_statement(' ', r);
2204: r := r + 1;
2205:

Line 2203: ad_ddl.build_statement(' ', r);

2199: r := r + 1;
2200: build_order_clause_list(r, 'DSLOAD');
2201: ad_ddl.build_statement(' '' ''; ', r);
2202: r := r + 1;
2203: ad_ddl.build_statement(' ', r);
2204: r := r + 1;
2205:
2206: ad_ddl.build_statement('END GCS_XML_UTILITY_PKG;', r);
2207: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

Line 2206: ad_ddl.build_statement('END GCS_XML_UTILITY_PKG;', r);

2202: r := r + 1;
2203: ad_ddl.build_statement(' ', r);
2204: r := r + 1;
2205:
2206: ad_ddl.build_statement('END GCS_XML_UTILITY_PKG;', r);
2207: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
2208: 'GCS',
2209: 'GCS_XML_UTILITY_PKG',
2210: 1,

Line 2207: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

2203: ad_ddl.build_statement(' ', r);
2204: r := r + 1;
2205:
2206: ad_ddl.build_statement('END GCS_XML_UTILITY_PKG;', r);
2207: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
2208: 'GCS',
2209: 'GCS_XML_UTILITY_PKG',
2210: 1,
2211: r,