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_COMP_PRIVATE_PKG dependencies on RG_XFER_UTILS_PKG

Line 497: RG_XFER_UTILS_PKG.display_log(

493: LedgerId NUMBER;
494: LedgerCurrency VARCHAR2(15);
495: LedgerName VARCHAR2(100);
496: BEGIN
497: RG_XFER_UTILS_PKG.display_log(
498: MsgLevel => G_ML_Full,
499: MsgName => 'RG_XFER_L_ENTER_ROUTINE',
500: Token1 => 'ROUTINE',
501: Token1Val => 'copy_axis_contents',

Line 529: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(

525: DBMS_SQL.column_value(CursorId, 2, LedgerId);
526: DBMS_SQL.column_value(CursorId, 3, LedgerCurrency);
527:
528: IF (LedgerId IS NOT NULL) THEN
529: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(
530: LedgerId, LedgerName, LedgerCurrency);
531: END IF;
532:
533: IF (LedgerId = G_Error) THEN

Line 535: RG_XFER_UTILS_PKG.display_warning(

531: END IF;
532:
533: IF (LedgerId = G_Error) THEN
534: /* Error: ledger not present in target db */
535: RG_XFER_UTILS_PKG.display_warning(
536: MsgName => 'RG_XFER_SUB_COMP_NOT_EXIST',
537: Token1 => 'SUB_COMP_TYPE',
538: Token1Val => 'RG_XFER_LEDGERS',
539: Token1Xlate => TRUE,

Line 562: RG_XFER_UTILS_PKG.substitute_tokens(

558:
559: /* Insert the row */
560: SQLString := AxisContentsString ||G_LinkName|| ' WHERE rowid = :row_id';
561:
562: RG_XFER_UTILS_PKG.substitute_tokens(
563: SQLString,
564: Token1=> ':ledger_id',
565: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
566: Token2=> ':alc_ledger_currency',

Line 565: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),

561:
562: RG_XFER_UTILS_PKG.substitute_tokens(
563: SQLString,
564: Token1=> ':ledger_id',
565: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
566: Token2=> ':alc_ledger_currency',
567: Token2Val=> LedgerCurrency);
568:
569: RG_XFER_UTILS_PKG.insert_rows(

Line 569: RG_XFER_UTILS_PKG.insert_rows(

565: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
566: Token2=> ':alc_ledger_currency',
567: Token2Val=> LedgerCurrency);
568:
569: RG_XFER_UTILS_PKG.insert_rows(
570: SQLString,
571: TargetAxisSetId,
572: UseCOAId=> FALSE,
573: UseRowId=> TRUE,

Line 583: RG_XFER_UTILS_PKG.display_log(

579: END IF;
580: END LOOP;
581: DBMS_SQL.close_cursor(CursorId);
582:
583: RG_XFER_UTILS_PKG.display_log(
584: MsgLevel => G_ML_Full,
585: MsgName => 'RG_XFER_L_EXIT_ROUTINE',
586: Token1 => 'ROUTINE',
587: Token1Val => 'copy_axis_contents');

Line 623: RG_XFER_UTILS_PKG.display_log(

619: LedgerId NUMBER;
620: LedgerName VARCHAR2(30);
621: ElemTargetIdStr VARCHAR2(30);
622: BEGIN
623: RG_XFER_UTILS_PKG.display_log(
624: MsgLevel => G_ML_Full,
625: MsgName => 'RG_XFER_L_ENTER_ROUTINE',
626: Token1 => 'ROUTINE',
627: Token1Val => 'copy_axis_details',

Line 635: AxisSegmentName := RG_XFER_UTILS_PKG.get_varchar2(

631: Token3Val => TO_CHAR(SourceAxisSetId),
632: Token4 => 'PARAM3',
633: Token4Val => TO_CHAR(TargetAxisSetId));
634:
635: AxisSegmentName := RG_XFER_UTILS_PKG.get_varchar2(
636: 'SELECT segment_name FROM rg_report_axis_sets@' ||
637: G_LinkName || ' WHERE axis_set_id = ' ||
638: TO_CHAR(SourceAxisSetId), 30);
639:

Line 660: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(

656:
657: IF (AxisSegmentName = 'LEDGER_SEGMENT') THEN
658: LedgerId := TO_NUMBER(OverrideVal);
659: IF (OverrideVal IS NOT NULL) THEN
660: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(
661: LedgerId, LedgerName, OverrideCurr);
662: END IF;
663:
664: IF (LedgerId = G_Error) THEN

Line 666: RG_XFER_UTILS_PKG.display_warning(

662: END IF;
663:
664: IF (LedgerId = G_Error) THEN
665: /* Error: ledger not present in target db */
666: RG_XFER_UTILS_PKG.display_warning(
667: MsgName => 'RG_XFER_SUB_COMP_NOT_EXIST',
668: Token1 => 'SUB_COMP_TYPE',
669: Token1Val => 'RG_XFER_LEDGERS',
670: Token1Xlate => TRUE,

Line 685: CurrencyCode := RG_XFER_UTILS_PKG.get_varchar2(

681:
682: OverrideVal := TO_CHAR(LedgerId);
683: END IF;
684:
685: CurrencyCode := RG_XFER_UTILS_PKG.get_varchar2(
686: 'SELECT unit_of_measure_id FROM rg_report_axes@'||
687: G_LinkName || ' WHERE axis_set_id = ' ||
688: TO_CHAR(SourceAxisSetId) ||
689: ' AND axis_seq = ' || TO_CHAR(AxisSeq),

Line 692: IF (NOT RG_XFER_UTILS_PKG.currency_exists(CurrencyCode)) THEN

688: TO_CHAR(SourceAxisSetId) ||
689: ' AND axis_seq = ' || TO_CHAR(AxisSeq),
690: 15);
691: IF (CurrencyCode IS NOT NULL) THEN
692: IF (NOT RG_XFER_UTILS_PKG.currency_exists(CurrencyCode)) THEN
693: /* Error: currency not defined in target database */
694: RG_XFER_UTILS_PKG.display_warning(
695: MsgName => 'RG_XFER_SUB_COMP_NOT_EXIST',
696: Token1 => 'SUB_COMP_TYPE',

Line 694: RG_XFER_UTILS_PKG.display_warning(

690: 15);
691: IF (CurrencyCode IS NOT NULL) THEN
692: IF (NOT RG_XFER_UTILS_PKG.currency_exists(CurrencyCode)) THEN
693: /* Error: currency not defined in target database */
694: RG_XFER_UTILS_PKG.display_warning(
695: MsgName => 'RG_XFER_SUB_COMP_NOT_EXIST',
696: Token1 => 'SUB_COMP_TYPE',
697: Token1Val => 'RG_XFER_CURRENCY',
698: Token1Xlate => TRUE,

Line 732: RG_XFER_UTILS_PKG.substitute_tokens(

728: SQLString := AxesString || G_LinkName || ' WHERE axis_set_id = ' ||
729: TO_CHAR(SourceAxisSetId) || ' AND axis_seq = ' ||
730: TO_CHAR(AxisSeq);
731:
732: RG_XFER_UTILS_PKG.substitute_tokens(
733: SQLString,
734: Token1=> ':currency_code',
735: Token1Val=> CurrencyCode,
736: Token2=> ':segment_override_value',

Line 742: RG_XFER_UTILS_PKG.substitute_tokens(

738: Token3=> ':override_alc_ledger_currency',
739: Token3Val=> OverrideCurr);
740:
741: /* Begin XBRL processing */
742: RG_XFER_UTILS_PKG.substitute_tokens(
743: SQLString, Token1=> ':elem_id', Token1Val=> ElemTargetIdStr);
744: /* End XBRL processing */
745:
746: RG_XFER_UTILS_PKG.insert_rows(

Line 746: RG_XFER_UTILS_PKG.insert_rows(

742: RG_XFER_UTILS_PKG.substitute_tokens(
743: SQLString, Token1=> ':elem_id', Token1Val=> ElemTargetIdStr);
744: /* End XBRL processing */
745:
746: RG_XFER_UTILS_PKG.insert_rows(
747: SQLString, TargetAxisSetId, UseCOAId=> FALSE);
748:
749: /* Copy axis contents */
750: copy_axis_contents(

Line 758: RG_XFER_UTILS_PKG.insert_rows(

754: SourceAxisSetId,
755: TargetAxisSetId);
756:
757: /* Copy calculations */
758: RG_XFER_UTILS_PKG.insert_rows(
759: CalculationsString || G_LinkName ||
760: ' WHERE axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
761: ' AND axis_seq = ' || TO_CHAR(AxisSeq),
762: TargetAxisSetId, UseCOAId=>FALSE);

Line 766: TargetExceptionId := RG_XFER_UTILS_PKG.get_new_id(

762: TargetAxisSetId, UseCOAId=>FALSE);
763:
764: IF (AxisSetType = 'RG_COLUMN_SET') THEN
765: /* Copy exception flags */
766: TargetExceptionId := RG_XFER_UTILS_PKG.get_new_id(
767: 'RG_REPORT_EXCEPTION_FLAGS_S');
768: SQLString := ExceptionFlagsString || G_LinkName ||
769: ' WHERE axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
770: ' AND axis_seq = ' || TO_CHAR(AxisSeq);

Line 771: RG_XFER_UTILS_PKG.substitute_tokens(

767: 'RG_REPORT_EXCEPTION_FLAGS_S');
768: SQLString := ExceptionFlagsString || G_LinkName ||
769: ' WHERE axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
770: ' AND axis_seq = ' || TO_CHAR(AxisSeq);
771: RG_XFER_UTILS_PKG.substitute_tokens(
772: SQLString,
773: Token1=> ':exception_id',
774: Token1Val=> TO_CHAR(TargetExceptionId));
775: RG_XFER_UTILS_PKG.insert_rows(

Line 775: RG_XFER_UTILS_PKG.insert_rows(

771: RG_XFER_UTILS_PKG.substitute_tokens(
772: SQLString,
773: Token1=> ':exception_id',
774: Token1Val=> TO_CHAR(TargetExceptionId));
775: RG_XFER_UTILS_PKG.insert_rows(
776: SQLString, TargetAxisSetId, UseCOAId=>FALSE);
777:
778: TempCursorId := DBMS_SQL.open_cursor;
779: DBMS_SQL.parse(

Line 791: RG_XFER_UTILS_PKG.substitute_tokens(

787: IF (ExecuteValue > 0) THEN
788: DBMS_SQL.column_value(TempCursorId, 1, SourceExceptionId);
789: SQLString := ExceptionsString || G_LinkName ||
790: ' WHERE exception_id = ' || TO_CHAR(SourceExceptionId);
791: RG_XFER_UTILS_PKG.substitute_tokens(
792: SQLString,
793: Token1=> ':exception_id',
794: Token1Val=> TO_CHAR(TargetExceptionId));
795: RG_XFER_UTILS_PKG.insert_rows(

Line 795: RG_XFER_UTILS_PKG.insert_rows(

791: RG_XFER_UTILS_PKG.substitute_tokens(
792: SQLString,
793: Token1=> ':exception_id',
794: Token1Val=> TO_CHAR(TargetExceptionId));
795: RG_XFER_UTILS_PKG.insert_rows(
796: SQLString,
797: TargetAxisSetId,
798: UseCOAId=>FALSE);
799: END IF;

Line 810: RG_XFER_UTILS_PKG.display_log(

806: END IF;
807: END LOOP;
808: DBMS_SQL.close_cursor(CursorId);
809:
810: RG_XFER_UTILS_PKG.display_log(
811: MsgLevel => G_ML_Full,
812: MsgName => 'RG_XFER_L_EXIT_ROUTINE',
813: Token1 => 'ROUTINE',
814: Token1Val => 'copy_axis_details');

Line 837: RG_XFER_UTILS_PKG.display_log(

833: SQLString VARCHAR2(200) := 'UPDATE rg_report_axis_sets ' ||
834: 'SET column_set_header = :header ' ||
835: 'WHERE axis_set_id = :id';
836: BEGIN
837: RG_XFER_UTILS_PKG.display_log(
838: MsgLevel => G_ML_Full,
839: MsgName => 'RG_XFER_L_ENTER_ROUTINE',
840: Token1 => 'ROUTINE',
841: Token1Val => 'copy_column_set_header',

Line 867: RG_XFER_UTILS_PKG.display_log(

863: DBMS_SQL.bind_variable(CursorId, ':id', TargetColumnSetId);
864: ExecuteValue := DBMS_SQL.execute(CursorId);
865: DBMS_SQL.close_cursor(CursorId);
866:
867: RG_XFER_UTILS_PKG.display_log(
868: MsgLevel => G_ML_Full,
869: MsgName => 'RG_XFER_L_EXIT_ROUTINE',
870: Token1 => 'ROUTINE',
871: Token1Val => 'copy_column_set_header');

Line 897: RG_XFER_UTILS_PKG.display_log(

893: LedgerId NUMBER;
894: LedgerCurrency VARCHAR2(15);
895: LedgerName VARCHAR2(100);
896: BEGIN
897: RG_XFER_UTILS_PKG.display_log(
898: MsgLevel => G_ML_Full,
899: MsgName => 'RG_XFER_L_ENTER_ROUTINE',
900: Token1 => 'ROUTINE',
901: Token1Val => 'copy_axis_contents',

Line 926: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(

922: DBMS_SQL.column_value(CursorId, 2, LedgerId);
923: DBMS_SQL.column_value(CursorId, 3, LedgerCurrency);
924:
925: IF (LedgerId IS NOT NULL) THEN
926: RG_XFER_UTILS_PKG.get_target_ldg_from_source_ldg(
927: LedgerId, LedgerName, LedgerCurrency);
928: END IF;
929:
930: IF (LedgerId = G_Error) THEN

Line 932: RG_XFER_UTILS_PKG.display_warning(

928: END IF;
929:
930: IF (LedgerId = G_Error) THEN
931: /* Error: ledger not present in target db */
932: RG_XFER_UTILS_PKG.display_warning(
933: MsgName => 'RG_XFER_SUB_COMP_NOT_EXIST',
934: Token1 => 'SUB_COMP_TYPE',
935: Token1Val => 'RG_XFER_LEDGERS',
936: Token1Xlate => TRUE,

Line 952: RG_XFER_UTILS_PKG.substitute_tokens(

948: /* Insert the row */
949: SQLString := ContentOverridesString || G_LinkName||
950: ' WHERE rowid = :row_id';
951:
952: RG_XFER_UTILS_PKG.substitute_tokens(
953: SQLString,
954: Token1=> ':ledger_id',
955: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
956: Token2=> ':alc_ledger_currency',

Line 955: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),

951:
952: RG_XFER_UTILS_PKG.substitute_tokens(
953: SQLString,
954: Token1=> ':ledger_id',
955: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
956: Token2=> ':alc_ledger_currency',
957: Token2Val=> LedgerCurrency);
958:
959: RG_XFER_UTILS_PKG.insert_rows(

Line 959: RG_XFER_UTILS_PKG.insert_rows(

955: Token1Val=> RG_XFER_UTILS_PKG.token_from_id(LedgerId),
956: Token2=> ':alc_ledger_currency',
957: Token2Val=> LedgerCurrency);
958:
959: RG_XFER_UTILS_PKG.insert_rows(
960: SQLString,
961: TargetContentSetId,
962: UseCOAId=> FALSE,
963: UseRowId=> TRUE,

Line 973: RG_XFER_UTILS_PKG.display_log(

969: END IF;
970: END LOOP;
971: DBMS_SQL.close_cursor(CursorId);
972:
973: RG_XFER_UTILS_PKG.display_log(
974: MsgLevel => G_ML_Full,
975: MsgName => 'RG_XFER_L_EXIT_ROUTINE',
976: Token1 => 'ROUTINE',
977: Token1Val => 'copy_content_set_details');

Line 1011: RG_XFER_UTILS_PKG.display_string(SQLString);

1007: ' WHERE a.axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
1008: ' AND a.axis_seq = ' || TO_CHAR(AxisSeq) ||
1009: ' AND a.element_id = e.element_id';
1010:
1011: RG_XFER_UTILS_PKG.display_string(SQLString);
1012:
1013: CursorId := DBMS_SQL.open_cursor;
1014: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
1015: DBMS_SQL.define_column(CursorId, 1, Id);

Line 1040: RG_XFER_UTILS_PKG.display_string(SQLString);

1036: 'FROM '||
1037: ' RG_XBRL_TAXONOMIES' || '@'|| G_LinkName || ' ref_table ' ||
1038: 'WHERE ref_table.taxonomy_id ' || '= '|| TO_CHAR(SourceTaxId);
1039:
1040: RG_XFER_UTILS_PKG.display_string(SQLString);
1041: CursorId := DBMS_SQL.open_cursor;
1042: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
1043: DBMS_SQL.define_column(CursorId, 1, RefObjectName, 240);
1044: ExecuteValue := DBMS_SQL.execute_and_fetch(CursorId);

Line 1053: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, TaxAlias);

1049: END IF;
1050: DBMS_SQL.close_cursor(CursorId);
1051: TaxAlias := RefObjectName;
1052:
1053: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, TaxAlias);
1054: ValueString := '''' || TempValue || '''';
1055:
1056: SQLString := 'SELECT taxonomy_id ' ||
1057: 'FROM rg_xbrl_taxonomies ' ||

Line 1059: TaxTargetId := RG_XFER_UTILS_PKG.component_exists(SQLString);

1055:
1056: SQLString := 'SELECT taxonomy_id ' ||
1057: 'FROM rg_xbrl_taxonomies ' ||
1058: 'WHERE taxonomy_alias = ' || ValueString;
1059: TaxTargetId := RG_XFER_UTILS_PKG.component_exists(SQLString);
1060:
1061: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, SourceIdName);
1062: ValueString := '''' || TempValue || '''';
1063:

Line 1061: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, SourceIdName);

1057: 'FROM rg_xbrl_taxonomies ' ||
1058: 'WHERE taxonomy_alias = ' || ValueString;
1059: TaxTargetId := RG_XFER_UTILS_PKG.component_exists(SQLString);
1060:
1061: RG_XFER_UTILS_PKG.copy_adjust_string(TempValue, SourceIdName);
1062: ValueString := '''' || TempValue || '''';
1063:
1064: SQLString := 'SELECT element_id ' ||
1065: ' FROM rg_xbrl_elements ' ||

Line 1069: RG_XFER_UTILS_PKG.display_string(SQLString);

1065: ' FROM rg_xbrl_elements ' ||
1066: ' WHERE taxonomy_id = ' || TO_CHAR(TaxTargetId) ||
1067: ' AND element_identifier ' || '=' || ValueString;
1068:
1069: RG_XFER_UTILS_PKG.display_string(SQLString);
1070:
1071: CursorId := DBMS_SQL.open_cursor;
1072: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
1073: DBMS_SQL.define_column(CursorId, 1, TargetId);

Line 1091: G_Error := RG_XFER_UTILS_PKG.G_Error;

1087: BEGIN
1088: /* Initialize variables on package access. */
1089:
1090: /* Error codes */
1091: G_Error := RG_XFER_UTILS_PKG.G_Error;
1092: G_Warning := RG_XFER_UTILS_PKG.G_Warning;
1093:
1094: /* The message levels */
1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;

Line 1092: G_Warning := RG_XFER_UTILS_PKG.G_Warning;

1088: /* Initialize variables on package access. */
1089:
1090: /* Error codes */
1091: G_Error := RG_XFER_UTILS_PKG.G_Error;
1092: G_Warning := RG_XFER_UTILS_PKG.G_Warning;
1093:
1094: /* The message levels */
1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;
1096: G_ML_Normal := RG_XFER_UTILS_PKG.G_ML_Normal;

Line 1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;

1091: G_Error := RG_XFER_UTILS_PKG.G_Error;
1092: G_Warning := RG_XFER_UTILS_PKG.G_Warning;
1093:
1094: /* The message levels */
1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;
1096: G_ML_Normal := RG_XFER_UTILS_PKG.G_ML_Normal;
1097: G_ML_Full := RG_XFER_UTILS_PKG.G_ML_Full;
1098:
1099: END RG_XFER_COMP_PRIVATE_PKG;

Line 1096: G_ML_Normal := RG_XFER_UTILS_PKG.G_ML_Normal;

1092: G_Warning := RG_XFER_UTILS_PKG.G_Warning;
1093:
1094: /* The message levels */
1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;
1096: G_ML_Normal := RG_XFER_UTILS_PKG.G_ML_Normal;
1097: G_ML_Full := RG_XFER_UTILS_PKG.G_ML_Full;
1098:
1099: END RG_XFER_COMP_PRIVATE_PKG;

Line 1097: G_ML_Full := RG_XFER_UTILS_PKG.G_ML_Full;

1093:
1094: /* The message levels */
1095: G_ML_Minimal := RG_XFER_UTILS_PKG.G_ML_Minimal;
1096: G_ML_Normal := RG_XFER_UTILS_PKG.G_ML_Normal;
1097: G_ML_Full := RG_XFER_UTILS_PKG.G_ML_Full;
1098:
1099: END RG_XFER_COMP_PRIVATE_PKG;