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.RG_XFER_COMPONENTS_PKG dependencies on DBMS_SQL

Line 680: CursorId := DBMS_SQL.open_cursor;

676: SQLString := SQLString || TableName || '@' || G_LinkName || WhereClause;
677: RG_XFER_UTILS_PKG.display_string(SQLString);
678:
679: /* Execute the SQL stmt */
680: CursorId := DBMS_SQL.open_cursor;
681: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);
683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP

Line 681: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

677: RG_XFER_UTILS_PKG.display_string(SQLString);
678:
679: /* Execute the SQL stmt */
680: CursorId := DBMS_SQL.open_cursor;
681: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);
683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP
685: /* For each component, call the routine recursively to do the copy */

Line 682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);

678:
679: /* Execute the SQL stmt */
680: CursorId := DBMS_SQL.open_cursor;
681: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);
683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP
685: /* For each component, call the routine recursively to do the copy */
686: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

Line 683: ExecuteValue := DBMS_SQL.execute(CursorId);

679: /* Execute the SQL stmt */
680: CursorId := DBMS_SQL.open_cursor;
681: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);
683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP
685: /* For each component, call the routine recursively to do the copy */
686: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
687: DBMS_SQL.column_value(CursorId, 1, CompName);

Line 686: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

682: DBMS_SQL.define_column(CursorId, 1, CompName, 30);
683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP
685: /* For each component, call the routine recursively to do the copy */
686: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
687: DBMS_SQL.column_value(CursorId, 1, CompName);
688: /* Redundant check to ensure that the name is NOT NULL. If the
689: * name is NULL for some reason, then the routine will try to
690: * copy all components again, and will cause errors. */

Line 687: DBMS_SQL.column_value(CursorId, 1, CompName);

683: ExecuteValue := DBMS_SQL.execute(CursorId);
684: LOOP
685: /* For each component, call the routine recursively to do the copy */
686: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
687: DBMS_SQL.column_value(CursorId, 1, CompName);
688: /* Redundant check to ensure that the name is NOT NULL. If the
689: * name is NULL for some reason, then the routine will try to
690: * copy all components again, and will cause errors. */
691: IF (CompName IS NOT NULL) THEN

Line 705: IF (DBMS_SQL.last_row_count = 0) THEN

701: END IF;
702: END LOOP;
703:
704: /* Print messages if no matching rows found */
705: IF (DBMS_SQL.last_row_count = 0) THEN
706: RG_XFER_UTILS_PKG.display_message(MsgName => 'RG_XFER_NO_MATCH_ROWS');
707: RG_XFER_UTILS_PKG.display_message(MsgName => 'RG_XFER_BLANK');
708: END IF;
709:

Line 710: DBMS_SQL.close_cursor(CursorId);

706: RG_XFER_UTILS_PKG.display_message(MsgName => 'RG_XFER_NO_MATCH_ROWS');
707: RG_XFER_UTILS_PKG.display_message(MsgName => 'RG_XFER_BLANK');
708: END IF;
709:
710: DBMS_SQL.close_cursor(CursorId);
711:
712: END IF;
713: END IF;
714:

Line 867: CursorId := DBMS_SQL.open_cursor;

863: 'WHERE main_table.name' || '='|| ValueString ||
864: ' AND main_table.taxonomy_id = ref_table.taxonomy_id';
865:
866: RG_XFER_UTILS_PKG.display_string(SQLString);
867: CursorId := DBMS_SQL.open_cursor;
868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);
871: IF (ExecuteValue > 0) THEN

Line 868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

864: ' AND main_table.taxonomy_id = ref_table.taxonomy_id';
865:
866: RG_XFER_UTILS_PKG.display_string(SQLString);
867: CursorId := DBMS_SQL.open_cursor;
868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);
871: IF (ExecuteValue > 0) THEN
872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);

Line 869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);

865:
866: RG_XFER_UTILS_PKG.display_string(SQLString);
867: CursorId := DBMS_SQL.open_cursor;
868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);
871: IF (ExecuteValue > 0) THEN
872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);
873: ELSE

Line 870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);

866: RG_XFER_UTILS_PKG.display_string(SQLString);
867: CursorId := DBMS_SQL.open_cursor;
868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);
871: IF (ExecuteValue > 0) THEN
872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);
873: ELSE
874: RefObjectName := '';

Line 872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);

868: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
869: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
870: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);
871: IF (ExecuteValue > 0) THEN
872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);
873: ELSE
874: RefObjectName := '';
875: END IF;
876: DBMS_SQL.close_cursor(CursorId);

Line 876: DBMS_SQL.close_cursor(CursorId);

872: DBMS_SQL.column_value(CursorId, 1, RefObjectName);
873: ELSE
874: RefObjectName := '';
875: END IF;
876: DBMS_SQL.close_cursor(CursorId);
877: TaxAlias := RefObjectName;
878:
879: /* Check if a taxonomy with the same alias already exists in target db */
880: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, TaxAlias);

Line 1685: CursorId := DBMS_SQL.open_cursor;

1681: Token3 => 'PARAM2',
1682: Token3Val => TO_CHAR(TargetDisplaySetId));
1683:
1684: /* Get all the detail records for this display set. */
1685: CursorId := DBMS_SQL.open_cursor;
1686: DBMS_SQL.parse(CursorId,
1687: 'SELECT report_display_id FROM rg_report_displays@' ||
1688: G_LinkName || ' WHERE report_display_set_id =' ||
1689: TO_CHAR(SourceDisplaySetId),

Line 1686: DBMS_SQL.parse(CursorId,

1682: Token3Val => TO_CHAR(TargetDisplaySetId));
1683:
1684: /* Get all the detail records for this display set. */
1685: CursorId := DBMS_SQL.open_cursor;
1686: DBMS_SQL.parse(CursorId,
1687: 'SELECT report_display_id FROM rg_report_displays@' ||
1688: G_LinkName || ' WHERE report_display_set_id =' ||
1689: TO_CHAR(SourceDisplaySetId),
1690: DBMS_SQL.v7);

Line 1690: DBMS_SQL.v7);

1686: DBMS_SQL.parse(CursorId,
1687: 'SELECT report_display_id FROM rg_report_displays@' ||
1688: G_LinkName || ' WHERE report_display_set_id =' ||
1689: TO_CHAR(SourceDisplaySetId),
1690: DBMS_SQL.v7);
1691: DBMS_SQL.define_column(CursorId, 1, DisplayId);
1692: ExecuteValue := DBMS_SQL.execute(CursorId);
1693: LOOP
1694: /* Loop through each detail record, and copy it. */

Line 1691: DBMS_SQL.define_column(CursorId, 1, DisplayId);

1687: 'SELECT report_display_id FROM rg_report_displays@' ||
1688: G_LinkName || ' WHERE report_display_set_id =' ||
1689: TO_CHAR(SourceDisplaySetId),
1690: DBMS_SQL.v7);
1691: DBMS_SQL.define_column(CursorId, 1, DisplayId);
1692: ExecuteValue := DBMS_SQL.execute(CursorId);
1693: LOOP
1694: /* Loop through each detail record, and copy it. */
1695: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

Line 1692: ExecuteValue := DBMS_SQL.execute(CursorId);

1688: G_LinkName || ' WHERE report_display_set_id =' ||
1689: TO_CHAR(SourceDisplaySetId),
1690: DBMS_SQL.v7);
1691: DBMS_SQL.define_column(CursorId, 1, DisplayId);
1692: ExecuteValue := DBMS_SQL.execute(CursorId);
1693: LOOP
1694: /* Loop through each detail record, and copy it. */
1695: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
1696: DBMS_SQL.column_value(CursorId, 1, DisplayId);

Line 1695: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

1691: DBMS_SQL.define_column(CursorId, 1, DisplayId);
1692: ExecuteValue := DBMS_SQL.execute(CursorId);
1693: LOOP
1694: /* Loop through each detail record, and copy it. */
1695: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
1696: DBMS_SQL.column_value(CursorId, 1, DisplayId);
1697:
1698: /* Copy row group, if any */
1699: DisplayGroupName := RG_XFER_UTILS_PKG.get_source_ref_object_name(

Line 1696: DBMS_SQL.column_value(CursorId, 1, DisplayId);

1692: ExecuteValue := DBMS_SQL.execute(CursorId);
1693: LOOP
1694: /* Loop through each detail record, and copy it. */
1695: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
1696: DBMS_SQL.column_value(CursorId, 1, DisplayId);
1697:
1698: /* Copy row group, if any */
1699: DisplayGroupName := RG_XFER_UTILS_PKG.get_source_ref_object_name(
1700: 'RG_REPORT_DISPLAYS', 'RG_REPORT_DISPLAY_GROUPS',

Line 1797: DBMS_SQL.close_cursor(CursorId);

1793: /* No more rows */
1794: EXIT;
1795: END IF;
1796: END LOOP;
1797: DBMS_SQL.close_cursor(CursorId);
1798:
1799: RG_XFER_UTILS_PKG.display_log(
1800: MsgLevel => G_ML_Full,
1801: MsgName => 'RG_XFER_L_EXIT_ROUTINE',

Line 2566: CursorId := DBMS_SQL.open_cursor;

2562: TargetParameterSetId := RG_XFER_UTILS_PKG.get_new_id(
2563: 'RG_REPORT_PARAMETERS_S');
2564:
2565: /* Get all the parameters for the report */
2566: CursorId := DBMS_SQL.open_cursor;
2567: DBMS_SQL.parse(CursorId,
2568: 'SELECT par.data_type, par.parameter_id, ' ||
2569: 'par.parameter_set_id, par.entered_currency, '||
2570: 'par.ledger_currency, ' ||

Line 2567: DBMS_SQL.parse(CursorId,

2563: 'RG_REPORT_PARAMETERS_S');
2564:
2565: /* Get all the parameters for the report */
2566: CursorId := DBMS_SQL.open_cursor;
2567: DBMS_SQL.parse(CursorId,
2568: 'SELECT par.data_type, par.parameter_id, ' ||
2569: 'par.parameter_set_id, par.entered_currency, '||
2570: 'par.ledger_currency, ' ||
2571: 'par.parameter_num FROM rg_report_parameters@' ||

Line 2575: DBMS_SQL.v7);

2571: 'par.parameter_num FROM rg_report_parameters@' ||
2572: G_LinkName || ' par, rg_reports@' || G_LinkName ||
2573: ' rp WHERE par.parameter_set_id = rp.parameter_set_id '||
2574: 'AND rp.report_id =' || TO_CHAR(ReportId),
2575: DBMS_SQL.v7);
2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);

Line 2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);

2572: G_LinkName || ' par, rg_reports@' || G_LinkName ||
2573: ' rp WHERE par.parameter_set_id = rp.parameter_set_id '||
2574: 'AND rp.report_id =' || TO_CHAR(ReportId),
2575: DBMS_SQL.v7);
2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);

Line 2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);

2573: ' rp WHERE par.parameter_set_id = rp.parameter_set_id '||
2574: 'AND rp.report_id =' || TO_CHAR(ReportId),
2575: DBMS_SQL.v7);
2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);

Line 2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);

2574: 'AND rp.report_id =' || TO_CHAR(ReportId),
2575: DBMS_SQL.v7);
2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);
2582: ExecuteValue := DBMS_SQL.execute(CursorId);

Line 2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);

2575: DBMS_SQL.v7);
2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);
2582: ExecuteValue := DBMS_SQL.execute(CursorId);
2583: LOOP

Line 2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);

2576: DBMS_SQL.define_column(CursorId, 1, DataType, 1);
2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);
2582: ExecuteValue := DBMS_SQL.execute(CursorId);
2583: LOOP
2584: /* For each record, check if the parameters exist in the target database.

Line 2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);

2577: DBMS_SQL.define_column(CursorId, 2, ParameterId);
2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);
2582: ExecuteValue := DBMS_SQL.execute(CursorId);
2583: LOOP
2584: /* For each record, check if the parameters exist in the target database.
2585: * If a parameter does not exist, then skip the record. */

Line 2582: ExecuteValue := DBMS_SQL.execute(CursorId);

2578: DBMS_SQL.define_column(CursorId, 3, SourceParameterSetId);
2579: DBMS_SQL.define_column(CursorId, 4, EnteredCurrency, 15);
2580: DBMS_SQL.define_column(CursorId, 5, LedgerCurrency, 15);
2581: DBMS_SQL.define_column(CursorId, 6, ParameterNum);
2582: ExecuteValue := DBMS_SQL.execute(CursorId);
2583: LOOP
2584: /* For each record, check if the parameters exist in the target database.
2585: * If a parameter does not exist, then skip the record. */
2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

Line 2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

2582: ExecuteValue := DBMS_SQL.execute(CursorId);
2583: LOOP
2584: /* For each record, check if the parameters exist in the target database.
2585: * If a parameter does not exist, then skip the record. */
2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);

Line 2587: DBMS_SQL.column_value(CursorId, 1, DataType);

2583: LOOP
2584: /* For each record, check if the parameters exist in the target database.
2585: * If a parameter does not exist, then skip the record. */
2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);

Line 2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);

2584: /* For each record, check if the parameters exist in the target database.
2585: * If a parameter does not exist, then skip the record. */
2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);
2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);

Line 2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);

2585: * If a parameter does not exist, then skip the record. */
2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);
2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);
2593:

Line 2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);

2586: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);
2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);
2593:
2594: IF (DataType = 'B') THEN

Line 2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);

2587: DBMS_SQL.column_value(CursorId, 1, DataType);
2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);
2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);
2593:
2594: IF (DataType = 'B') THEN
2595: /* Check budget */

Line 2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);

2588: DBMS_SQL.column_value(CursorId, 2, ParameterId);
2589: DBMS_SQL.column_value(CursorId, 3, SourceParameterSetId);
2590: DBMS_SQL.column_value(CursorId, 4, EnteredCurrency);
2591: DBMS_SQL.column_value(CursorId, 5, LedgerCurrency);
2592: DBMS_SQL.column_value(CursorId, 6, ParameterNum);
2593:
2594: IF (DataType = 'B') THEN
2595: /* Check budget */
2596: RG_XFER_UTILS_PKG.get_target_id_from_source_id(

Line 2711: DBMS_SQL.close_cursor(CursorId);

2707: RowsFound := FALSE;
2708: EXIT;
2709: END IF;
2710: END LOOP;
2711: DBMS_SQL.close_cursor(CursorId);
2712:
2713: RG_XFER_UTILS_PKG.display_log(
2714: MsgLevel => G_ML_Full,
2715: MsgName => 'RG_XFER_L_EXIT_ROUTINE',

Line 2889: CursorId := DBMS_SQL.open_cursor;

2885: Token3 => 'PARAM2',
2886: Token3Val => TO_CHAR(TargetReportSetId));
2887:
2888: /* Get all the reports for the report set */
2889: CursorId := DBMS_SQL.open_cursor;
2890: DBMS_SQL.parse(CursorId,
2891: 'SELECT report_request_id FROM rg_report_requests@' ||
2892: G_LinkName || ' WHERE report_set_id =' ||
2893: TO_CHAR(SourceReportSetId),

Line 2890: DBMS_SQL.parse(CursorId,

2886: Token3Val => TO_CHAR(TargetReportSetId));
2887:
2888: /* Get all the reports for the report set */
2889: CursorId := DBMS_SQL.open_cursor;
2890: DBMS_SQL.parse(CursorId,
2891: 'SELECT report_request_id FROM rg_report_requests@' ||
2892: G_LinkName || ' WHERE report_set_id =' ||
2893: TO_CHAR(SourceReportSetId),
2894: DBMS_SQL.v7);

Line 2894: DBMS_SQL.v7);

2890: DBMS_SQL.parse(CursorId,
2891: 'SELECT report_request_id FROM rg_report_requests@' ||
2892: G_LinkName || ' WHERE report_set_id =' ||
2893: TO_CHAR(SourceReportSetId),
2894: DBMS_SQL.v7);
2895: DBMS_SQL.define_column(CursorId, 1, ReportRequestId);
2896: ExecuteValue := DBMS_SQL.execute(CursorId);
2897: LOOP
2898: /* For each record, copy the report, if it is not there already.

Line 2895: DBMS_SQL.define_column(CursorId, 1, ReportRequestId);

2891: 'SELECT report_request_id FROM rg_report_requests@' ||
2892: G_LinkName || ' WHERE report_set_id =' ||
2893: TO_CHAR(SourceReportSetId),
2894: DBMS_SQL.v7);
2895: DBMS_SQL.define_column(CursorId, 1, ReportRequestId);
2896: ExecuteValue := DBMS_SQL.execute(CursorId);
2897: LOOP
2898: /* For each record, copy the report, if it is not there already.
2899: * If there is an error while copying the report, then skip the

Line 2896: ExecuteValue := DBMS_SQL.execute(CursorId);

2892: G_LinkName || ' WHERE report_set_id =' ||
2893: TO_CHAR(SourceReportSetId),
2894: DBMS_SQL.v7);
2895: DBMS_SQL.define_column(CursorId, 1, ReportRequestId);
2896: ExecuteValue := DBMS_SQL.execute(CursorId);
2897: LOOP
2898: /* For each record, copy the report, if it is not there already.
2899: * If there is an error while copying the report, then skip the
2900: * record. */

Line 2901: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN

2897: LOOP
2898: /* For each record, copy the report, if it is not there already.
2899: * If there is an error while copying the report, then skip the
2900: * record. */
2901: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2902: DBMS_SQL.column_value(CursorId, 1, ReportRequestId);
2903: /* Copy report */
2904: ReportName := RG_XFER_UTILS_PKG.get_source_ref_object_name(
2905: 'RG_REPORT_REQUESTS', 'RG_REPORTS',

Line 2902: DBMS_SQL.column_value(CursorId, 1, ReportRequestId);

2898: /* For each record, copy the report, if it is not there already.
2899: * If there is an error while copying the report, then skip the
2900: * record. */
2901: IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
2902: DBMS_SQL.column_value(CursorId, 1, ReportRequestId);
2903: /* Copy report */
2904: ReportName := RG_XFER_UTILS_PKG.get_source_ref_object_name(
2905: 'RG_REPORT_REQUESTS', 'RG_REPORTS',
2906: 'REPORT_REQUEST_ID', TO_CHAR(ReportRequestId),

Line 2958: DBMS_SQL.close_cursor(CursorId);

2954: /* No more rows */
2955: EXIT;
2956: END IF;
2957: END LOOP;
2958: DBMS_SQL.close_cursor(CursorId);
2959:
2960: RG_XFER_UTILS_PKG.display_log(
2961: MsgLevel => G_ML_Full,
2962: MsgName => 'RG_XFER_L_EXIT_ROUTINE',

Line 3056: CursorId := DBMS_SQL.open_cursor;

3052: ' tax.taxonomy_id <> ' || to_char(parent_tax_id);
3053:
3054: RG_XFER_UTILS_PKG.display_string(SQLString);
3055:
3056: CursorId := DBMS_SQL.open_cursor;
3057:
3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);
3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);

Line 3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3054: RG_XFER_UTILS_PKG.display_string(SQLString);
3055:
3056: CursorId := DBMS_SQL.open_cursor;
3057:
3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);
3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);
3061: child_cnt := 0;
3062: ExecuteValue := DBMS_SQL.execute(CursorId);

Line 3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);

3055:
3056: CursorId := DBMS_SQL.open_cursor;
3057:
3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);
3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);
3061: child_cnt := 0;
3062: ExecuteValue := DBMS_SQL.execute(CursorId);
3063:

Line 3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);

3056: CursorId := DBMS_SQL.open_cursor;
3057:
3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);
3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);
3061: child_cnt := 0;
3062: ExecuteValue := DBMS_SQL.execute(CursorId);
3063:
3064: LOOP

Line 3062: ExecuteValue := DBMS_SQL.execute(CursorId);

3058: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3059: DBMS_SQL.define_column(CursorId, 1, src_tax_id);
3060: DBMS_SQL.define_column(CursorId, 2, src_tax_alias, 240);
3061: child_cnt := 0;
3062: ExecuteValue := DBMS_SQL.execute(CursorId);
3063:
3064: LOOP
3065: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3066: IF (ExecuteValue > 0) THEN

Line 3065: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);

3061: child_cnt := 0;
3062: ExecuteValue := DBMS_SQL.execute(CursorId);
3063:
3064: LOOP
3065: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3066: IF (ExecuteValue > 0) THEN
3067: child_cnt := child_cnt + 1;
3068: DBMS_SQL.column_value(CursorId, 1, src_tax_id);
3069: DBMS_SQL.column_value(CursorId, 2, src_tax_alias);

Line 3068: DBMS_SQL.column_value(CursorId, 1, src_tax_id);

3064: LOOP
3065: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3066: IF (ExecuteValue > 0) THEN
3067: child_cnt := child_cnt + 1;
3068: DBMS_SQL.column_value(CursorId, 1, src_tax_id);
3069: DBMS_SQL.column_value(CursorId, 2, src_tax_alias);
3070: arr_child_tax_id(child_cnt) := src_tax_id;
3071: arr_child_tax_alias(child_cnt) := src_tax_alias;
3072: arr_child_done_flag(child_cnt) := 0;

Line 3069: DBMS_SQL.column_value(CursorId, 2, src_tax_alias);

3065: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3066: IF (ExecuteValue > 0) THEN
3067: child_cnt := child_cnt + 1;
3068: DBMS_SQL.column_value(CursorId, 1, src_tax_id);
3069: DBMS_SQL.column_value(CursorId, 2, src_tax_alias);
3070: arr_child_tax_id(child_cnt) := src_tax_id;
3071: arr_child_tax_alias(child_cnt) := src_tax_alias;
3072: arr_child_done_flag(child_cnt) := 0;
3073: ELSE

Line 3077: DBMS_SQL.close_cursor(CursorId);

3073: ELSE
3074: EXIT;
3075: END IF;
3076: END LOOP;
3077: DBMS_SQL.close_cursor(CursorId);
3078:
3079: /* all childs are created */
3080:
3081: IF (child_cnt = 0) THEN

Line 3104: CursorId := DBMS_SQL.open_cursor;

3100: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3101:
3102: RG_XFER_UTILS_PKG.display_string(SQLString);
3103:
3104: CursorId := DBMS_SQL.open_cursor;
3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3106: ExecuteValue := DBMS_SQL.execute(CursorId);
3107: DBMS_SQL.close_cursor(CursorId);
3108:

Line 3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3101:
3102: RG_XFER_UTILS_PKG.display_string(SQLString);
3103:
3104: CursorId := DBMS_SQL.open_cursor;
3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3106: ExecuteValue := DBMS_SQL.execute(CursorId);
3107: DBMS_SQL.close_cursor(CursorId);
3108:
3109: /* populate multiple rows in rg_xbrl_elements */

Line 3106: ExecuteValue := DBMS_SQL.execute(CursorId);

3102: RG_XFER_UTILS_PKG.display_string(SQLString);
3103:
3104: CursorId := DBMS_SQL.open_cursor;
3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3106: ExecuteValue := DBMS_SQL.execute(CursorId);
3107: DBMS_SQL.close_cursor(CursorId);
3108:
3109: /* populate multiple rows in rg_xbrl_elements */
3110: SQLString :=

Line 3107: DBMS_SQL.close_cursor(CursorId);

3103:
3104: CursorId := DBMS_SQL.open_cursor;
3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3106: ExecuteValue := DBMS_SQL.execute(CursorId);
3107: DBMS_SQL.close_cursor(CursorId);
3108:
3109: /* populate multiple rows in rg_xbrl_elements */
3110: SQLString :=
3111: 'SELECT ' ||

Line 3121: CursorId := DBMS_SQL.open_cursor;

3117: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3118:
3119: RG_XFER_UTILS_PKG.display_string(SQLString);
3120:
3121: CursorId := DBMS_SQL.open_cursor;
3122:
3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);

Line 3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3119: RG_XFER_UTILS_PKG.display_string(SQLString);
3120:
3121: CursorId := DBMS_SQL.open_cursor;
3122:
3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);

Line 3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);

3121: CursorId := DBMS_SQL.open_cursor;
3122:
3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);

Line 3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);

3122:
3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);

Line 3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);

3123: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);

Line 3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);

3124:
3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);

Line 3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);

3125: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);

Line 3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);

3126: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);

Line 3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);

3127: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3135:

Line 3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);

3128: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3135:
3136: ExecuteValue := DBMS_SQL.execute(CursorId);

Line 3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);

3129: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3135:
3136: ExecuteValue := DBMS_SQL.execute(CursorId);
3137:

Line 3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);

3130: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3131: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3135:
3136: ExecuteValue := DBMS_SQL.execute(CursorId);
3137:
3138: LOOP

Line 3136: ExecuteValue := DBMS_SQL.execute(CursorId);

3132: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3133: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3134: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3135:
3136: ExecuteValue := DBMS_SQL.execute(CursorId);
3137:
3138: LOOP
3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3140: IF (ExecuteValue > 0) THEN

Line 3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);

3135:
3136: ExecuteValue := DBMS_SQL.execute(CursorId);
3137:
3138: LOOP
3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3140: IF (ExecuteValue > 0) THEN
3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);

Line 3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);

3137:
3138: LOOP
3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3140: IF (ExecuteValue > 0) THEN
3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);

Line 3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);

3138: LOOP
3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3140: IF (ExecuteValue > 0) THEN
3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);

Line 3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);

3139: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3140: IF (ExecuteValue > 0) THEN
3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);

Line 3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);

3140: IF (ExecuteValue > 0) THEN
3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);

Line 3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);

3141: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);

Line 3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);

3142: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);

Line 3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);

3143: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --

Line 3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);

3144: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --
3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');

Line 3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);

3145: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --
3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3153: --

Line 3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);

3146: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3147: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --
3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3153: --
3154: INSERT INTO RG_XBRL_ELEMENTS (

Line 3172: DBMS_SQL.close_cursor(CursorId);

3168: EXIT;
3169: END IF;
3170: END LOOP;
3171:
3172: DBMS_SQL.close_cursor(CursorId);
3173:
3174: /* populate multiple rows in rg_xbrl_map_elements */
3175:
3176: SQLString :=

Line 3190: CursorId := DBMS_SQL.open_cursor;

3186: ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);
3187:
3188: RG_XFER_UTILS_PKG.display_string(SQLString);
3189:
3190: CursorId := DBMS_SQL.open_cursor;
3191: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3192: ExecuteValue := DBMS_SQL.execute(CursorId);
3193: DBMS_SQL.close_cursor(CursorId);
3194:

Line 3191: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3187:
3188: RG_XFER_UTILS_PKG.display_string(SQLString);
3189:
3190: CursorId := DBMS_SQL.open_cursor;
3191: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3192: ExecuteValue := DBMS_SQL.execute(CursorId);
3193: DBMS_SQL.close_cursor(CursorId);
3194:
3195: parent_done_flag := 1;

Line 3192: ExecuteValue := DBMS_SQL.execute(CursorId);

3188: RG_XFER_UTILS_PKG.display_string(SQLString);
3189:
3190: CursorId := DBMS_SQL.open_cursor;
3191: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3192: ExecuteValue := DBMS_SQL.execute(CursorId);
3193: DBMS_SQL.close_cursor(CursorId);
3194:
3195: parent_done_flag := 1;
3196: RETURN;

Line 3193: DBMS_SQL.close_cursor(CursorId);

3189:
3190: CursorId := DBMS_SQL.open_cursor;
3191: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3192: ExecuteValue := DBMS_SQL.execute(CursorId);
3193: DBMS_SQL.close_cursor(CursorId);
3194:
3195: parent_done_flag := 1;
3196: RETURN;
3197:

Line 3246: CursorId := DBMS_SQL.open_cursor;

3242: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3243:
3244: RG_XFER_UTILS_PKG.display_string(SQLString);
3245:
3246: CursorId := DBMS_SQL.open_cursor;
3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3248: ExecuteValue := DBMS_SQL.execute(CursorId);
3249: DBMS_SQL.close_cursor(CursorId);
3250:

Line 3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3243:
3244: RG_XFER_UTILS_PKG.display_string(SQLString);
3245:
3246: CursorId := DBMS_SQL.open_cursor;
3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3248: ExecuteValue := DBMS_SQL.execute(CursorId);
3249: DBMS_SQL.close_cursor(CursorId);
3250:
3251: /* populate multiple rows in rg_xbrl_elements */

Line 3248: ExecuteValue := DBMS_SQL.execute(CursorId);

3244: RG_XFER_UTILS_PKG.display_string(SQLString);
3245:
3246: CursorId := DBMS_SQL.open_cursor;
3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3248: ExecuteValue := DBMS_SQL.execute(CursorId);
3249: DBMS_SQL.close_cursor(CursorId);
3250:
3251: /* populate multiple rows in rg_xbrl_elements */
3252:

Line 3249: DBMS_SQL.close_cursor(CursorId);

3245:
3246: CursorId := DBMS_SQL.open_cursor;
3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3248: ExecuteValue := DBMS_SQL.execute(CursorId);
3249: DBMS_SQL.close_cursor(CursorId);
3250:
3251: /* populate multiple rows in rg_xbrl_elements */
3252:
3253: SQLString :=

Line 3263: CursorId := DBMS_SQL.open_cursor;

3259: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3260:
3261: RG_XFER_UTILS_PKG.display_string(SQLString);
3262:
3263: CursorId := DBMS_SQL.open_cursor;
3264:
3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);

Line 3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3261: RG_XFER_UTILS_PKG.display_string(SQLString);
3262:
3263: CursorId := DBMS_SQL.open_cursor;
3264:
3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);

Line 3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);

3263: CursorId := DBMS_SQL.open_cursor;
3264:
3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);

Line 3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);

3264:
3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);

Line 3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);

3265: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);

Line 3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);

3266:
3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);

Line 3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);

3267: DBMS_SQL.define_column(CursorId, 1, src_element_identifier,240);
3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);

Line 3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);

3268: DBMS_SQL.define_column(CursorId, 2, src_element_name, 240);
3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);

Line 3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);

3269: DBMS_SQL.define_column(CursorId, 3, src_element_type,240);
3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3277:

Line 3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);

3270: DBMS_SQL.define_column(CursorId, 4, src_element_group, 240);
3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3277:
3278: ExecuteValue := DBMS_SQL.execute(CursorId);

Line 3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);

3271: DBMS_SQL.define_column(CursorId, 5, src_element_descr,3000);
3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3277:
3278: ExecuteValue := DBMS_SQL.execute(CursorId);
3279:

Line 3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);

3272: DBMS_SQL.define_column(CursorId, 6, src_element_label, 240);
3273: DBMS_SQL.define_column(CursorId, 7, src_parent_identifier,240);
3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3277:
3278: ExecuteValue := DBMS_SQL.execute(CursorId);
3279:
3280: LOOP

Line 3278: ExecuteValue := DBMS_SQL.execute(CursorId);

3274: DBMS_SQL.define_column(CursorId, 8, src_has_child_flag,1);
3275: DBMS_SQL.define_column(CursorId, 9, src_has_parent_flag,1);
3276: DBMS_SQL.define_column(CursorId, 10, src_hierarchy_level);
3277:
3278: ExecuteValue := DBMS_SQL.execute(CursorId);
3279:
3280: LOOP
3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3282: IF (ExecuteValue > 0) THEN

Line 3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);

3277:
3278: ExecuteValue := DBMS_SQL.execute(CursorId);
3279:
3280: LOOP
3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3282: IF (ExecuteValue > 0) THEN
3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);

Line 3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);

3279:
3280: LOOP
3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3282: IF (ExecuteValue > 0) THEN
3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);

Line 3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);

3280: LOOP
3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3282: IF (ExecuteValue > 0) THEN
3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);

Line 3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);

3281: ExecuteValue := DBMS_SQL.fetch_rows(CursorId);
3282: IF (ExecuteValue > 0) THEN
3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);

Line 3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);

3282: IF (ExecuteValue > 0) THEN
3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);

Line 3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);

3283: DBMS_SQL.column_value(CursorId, 1, src_element_identifier);
3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);

Line 3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);

3284: DBMS_SQL.column_value(CursorId, 2, src_element_name);
3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);

Line 3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);

3285: DBMS_SQL.column_value(CursorId, 3, src_element_type);
3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --

Line 3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);

3286: DBMS_SQL.column_value(CursorId, 4, src_element_group);
3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --
3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');

Line 3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);

3287: DBMS_SQL.column_value(CursorId, 5, src_element_descr);
3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --
3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3295: --

Line 3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);

3288: DBMS_SQL.column_value(CursorId, 6, src_element_label);
3289: DBMS_SQL.column_value(CursorId, 7, src_parent_identifier);
3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --
3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3295: --
3296: INSERT INTO RG_XBRL_ELEMENTS (

Line 3314: DBMS_SQL.close_cursor(CursorId);

3310: EXIT;
3311: END IF;
3312: END LOOP;
3313:
3314: DBMS_SQL.close_cursor(CursorId);
3315:
3316: /* populate multiple rows in rg_xbrl_map_elements */
3317:
3318: SQLString :=

Line 3332: CursorId := DBMS_SQL.open_cursor;

3328: ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);
3329:
3330: RG_XFER_UTILS_PKG.display_string(SQLString);
3331:
3332: CursorId := DBMS_SQL.open_cursor;
3333: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3334: ExecuteValue := DBMS_SQL.execute(CursorId);
3335: DBMS_SQL.close_cursor(CursorId);
3336:

Line 3333: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3329:
3330: RG_XFER_UTILS_PKG.display_string(SQLString);
3331:
3332: CursorId := DBMS_SQL.open_cursor;
3333: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3334: ExecuteValue := DBMS_SQL.execute(CursorId);
3335: DBMS_SQL.close_cursor(CursorId);
3336:
3337: END IF;

Line 3334: ExecuteValue := DBMS_SQL.execute(CursorId);

3330: RG_XFER_UTILS_PKG.display_string(SQLString);
3331:
3332: CursorId := DBMS_SQL.open_cursor;
3333: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3334: ExecuteValue := DBMS_SQL.execute(CursorId);
3335: DBMS_SQL.close_cursor(CursorId);
3336:
3337: END IF;
3338:

Line 3335: DBMS_SQL.close_cursor(CursorId);

3331:
3332: CursorId := DBMS_SQL.open_cursor;
3333: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3334: ExecuteValue := DBMS_SQL.execute(CursorId);
3335: DBMS_SQL.close_cursor(CursorId);
3336:
3337: END IF;
3338:
3339: /* update rg_xbrl_map_elements for the parent with a child */

Line 3367: CursorId := DBMS_SQL.open_cursor;

3363: 'WHERE map.taxonomy_id = ' || to_char(dest_taxonomy_id) || ')';
3364:
3365: RG_XFER_UTILS_PKG.display_string(SQLString);
3366:
3367: CursorId := DBMS_SQL.open_cursor;
3368: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3369: ExecuteValue := DBMS_SQL.execute(CursorId);
3370: DBMS_SQL.close_cursor(CursorId);
3371:

Line 3368: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);

3364:
3365: RG_XFER_UTILS_PKG.display_string(SQLString);
3366:
3367: CursorId := DBMS_SQL.open_cursor;
3368: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3369: ExecuteValue := DBMS_SQL.execute(CursorId);
3370: DBMS_SQL.close_cursor(CursorId);
3371:
3372: --ELSE

Line 3369: ExecuteValue := DBMS_SQL.execute(CursorId);

3365: RG_XFER_UTILS_PKG.display_string(SQLString);
3366:
3367: CursorId := DBMS_SQL.open_cursor;
3368: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3369: ExecuteValue := DBMS_SQL.execute(CursorId);
3370: DBMS_SQL.close_cursor(CursorId);
3371:
3372: --ELSE
3373: -- parent_done_flag := 0;

Line 3370: DBMS_SQL.close_cursor(CursorId);

3366:
3367: CursorId := DBMS_SQL.open_cursor;
3368: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3369: ExecuteValue := DBMS_SQL.execute(CursorId);
3370: DBMS_SQL.close_cursor(CursorId);
3371:
3372: --ELSE
3373: -- parent_done_flag := 0;
3374: -- RETURN;