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_ENTITIES_PKG dependencies on FEM_ENTITIES_ATTR

Line 532: INSERT INTO fem_entities_attr

528: -- Get and insert the base org information
529: get_next_token(l_local_clob, current_loc, info_buffer);
530: entity_base_org_id := to_number(info_buffer);
531:
532: INSERT INTO fem_entities_attr
533: (attribute_id,
534: version_id,
535: entity_id,
536: value_set_id,

Line 565: INSERT INTO fem_entities_attr

561: entity_type_code := 'C';
562: END IF;
563:
564: -- Insert the entity type information
565: INSERT INTO fem_entities_attr
566: (attribute_id,
567: version_id,
568: entity_id,
569: value_set_id,

Line 595: INSERT INTO fem_entities_attr

591:
592: -- Get and insert the contact information
593: get_next_token(l_local_clob, current_loc, entity_contact);
594:
595: INSERT INTO fem_entities_attr
596: (attribute_id,
597: version_id,
598: entity_id,
599: value_set_id,

Line 626: INSERT INTO fem_entities_attr

622: -- Get and insert the logo information if provided
623: get_next_token(l_local_clob, current_loc, entity_logo);
624:
625: IF trim(entity_logo) IS NOT NULL THEN
626: INSERT INTO fem_entities_attr
627: (attribute_id,
628: version_id,
629: entity_id,
630: value_set_id,

Line 675: INSERT INTO fem_entities_attr

671: entity_name,
672: entity_desc);
673:
674: -- Now create a ledger based on the info, and get back the ledger_id
675: INSERT INTO fem_entities_attr
676: (attribute_id,
677: version_id,
678: entity_id,
679: value_set_id,

Line 707: INSERT INTO fem_entities_attr

703: get_next_token(l_local_clob, current_loc, info_buffer);
704: entity_trs_obj_id := to_number(info_buffer);
705:
706: IF entity_trs_obj_id IS NOT NULL THEN
707: INSERT INTO fem_entities_attr
708: (attribute_id,
709: version_id,
710: entity_id,
711: value_set_id,

Line 740: INSERT INTO fem_entities_attr

736: get_next_token(l_local_clob, current_loc, info_buffer);
737: entity_vrs_obj_id := to_number(info_buffer);
738:
739: IF entity_vrs_obj_id IS NOT NULL THEN
740: INSERT INTO fem_entities_attr
741: (attribute_id,
742: version_id,
743: entity_id,
744: value_set_id,

Line 776: INSERT INTO fem_entities_attr

772: -- Get the Ledger and set the attribute
773: get_next_token(l_local_clob, current_loc, info_buffer);
774: entity_ledger_id := to_number(info_buffer);
775:
776: INSERT INTO fem_entities_attr
777: (attribute_id,
778: version_id,
779: entity_id,
780: value_set_id,

Line 807: INSERT INTO fem_entities_attr

803: -- Get the Balances Rule and set the attribute
804: get_next_token(l_local_clob, current_loc, info_buffer);
805: entity_bal_rule_id := to_number(info_buffer);
806:
807: INSERT INTO fem_entities_attr
808: (attribute_id,
809: version_id,
810: entity_id,
811: value_set_id,

Line 843: INSERT INTO fem_entities_attr

839: get_next_token(l_local_clob, current_loc, entity_elim_name);
840:
841: SELECT FND_FLEX_VALUES_S.nextval INTO elim_entity_id FROM dual;
842:
843: INSERT INTO fem_entities_attr
844: (attribute_id,
845: version_id,
846: entity_id,
847: value_set_id,

Line 901: INSERT INTO fem_entities_attr

897: sysdate,
898: user_id,
899: login_id);
900:
901: INSERT INTO fem_entities_attr
902: (attribute_id,
903: version_id,
904: entity_id,
905: value_set_id,

Line 928: INSERT INTO fem_entities_attr

924: sysdate,
925: user_id,
926: login_id);
927:
928: INSERT INTO fem_entities_attr
929: (attribute_id,
930: version_id,
931: entity_id,
932: value_set_id,

Line 955: INSERT INTO fem_entities_attr

951: sysdate,
952: user_id,
953: login_id);
954:
955: INSERT INTO fem_entities_attr
956: (attribute_id,
957: version_id,
958: entity_id,
959: value_set_id,

Line 983: INSERT INTO fem_entities_attr

979: user_id,
980: login_id);
981:
982: IF trim(entity_logo) IS NOT NULL THEN
983: INSERT INTO fem_entities_attr
984: (attribute_id,
985: version_id,
986: entity_id,
987: value_set_id,

Line 1011: INSERT INTO fem_entities_attr

1007: user_id,
1008: login_id);
1009: END IF;
1010:
1011: INSERT INTO fem_entities_attr
1012: (attribute_id,
1013: version_id,
1014: entity_id,
1015: value_set_id,

Line 1043: INSERT INTO fem_entities_attr

1039: get_next_token(l_local_clob, current_loc, info_buffer);
1040: entity_cont_id := to_number(info_buffer);
1041:
1042: IF entity_cont_id IS NOT NULL THEN
1043: INSERT INTO fem_entities_attr
1044: (attribute_id,
1045: version_id,
1046: entity_id,
1047: value_set_id,

Line 1074: INSERT INTO fem_entities_attr

1070:
1071: END IF;
1072:
1073: -- Insert the source system information
1074: INSERT INTO fem_entities_attr
1075: (attribute_id,
1076: version_id,
1077: entity_id,
1078: value_set_id,

Line 1104: INSERT INTO fem_entities_attr

1100:
1101: -- Get and insert the security information
1102: get_next_token(l_local_clob, current_loc, entity_sec_by_role);
1103:
1104: INSERT INTO fem_entities_attr
1105: (attribute_id,
1106: version_id,
1107: entity_id,
1108: value_set_id,

Line 1133: INSERT INTO fem_entities_attr

1129: login_id);
1130:
1131: IF read_mode = 3 THEN
1132: -- consolidation entity
1133: INSERT INTO fem_entities_attr
1134: (attribute_id,
1135: version_id,
1136: entity_id,
1137: value_set_id,

Line 1226: INSERT INTO fem_entities_attr

1222: END LOOP;
1223: END IF;
1224:
1225: -- Insert the recon_leaf_node_flag information
1226: INSERT INTO fem_entities_attr
1227: (attribute_id,
1228: version_id,
1229: entity_id,
1230: value_set_id,

Line 1291: fem_entities_attr fea_src,

1287: 1,
1288: -- Bug fix : 5843592
1289: to_date('01-01-1900','dd-MM-yyyy')
1290: FROM fem_entities_b feb,
1291: fem_entities_attr fea_src,
1292: fem_entities_attr fea_ledger,
1293: fem_entities_attr fea_bal_rule,
1294: fem_entities_attr fea_trs,
1295: fem_entities_attr fea_vrs,

Line 1292: fem_entities_attr fea_ledger,

1288: -- Bug fix : 5843592
1289: to_date('01-01-1900','dd-MM-yyyy')
1290: FROM fem_entities_b feb,
1291: fem_entities_attr fea_src,
1292: fem_entities_attr fea_ledger,
1293: fem_entities_attr fea_bal_rule,
1294: fem_entities_attr fea_trs,
1295: fem_entities_attr fea_vrs,
1296: gcs_lex_map_rule_sets trs,

Line 1293: fem_entities_attr fea_bal_rule,

1289: to_date('01-01-1900','dd-MM-yyyy')
1290: FROM fem_entities_b feb,
1291: fem_entities_attr fea_src,
1292: fem_entities_attr fea_ledger,
1293: fem_entities_attr fea_bal_rule,
1294: fem_entities_attr fea_trs,
1295: fem_entities_attr fea_vrs,
1296: gcs_lex_map_rule_sets trs,
1297: gcs_lex_map_rule_sets vrs

Line 1294: fem_entities_attr fea_trs,

1290: FROM fem_entities_b feb,
1291: fem_entities_attr fea_src,
1292: fem_entities_attr fea_ledger,
1293: fem_entities_attr fea_bal_rule,
1294: fem_entities_attr fea_trs,
1295: fem_entities_attr fea_vrs,
1296: gcs_lex_map_rule_sets trs,
1297: gcs_lex_map_rule_sets vrs
1298: WHERE fea_ledger.entity_id = feb.entity_id

Line 1295: fem_entities_attr fea_vrs,

1291: fem_entities_attr fea_src,
1292: fem_entities_attr fea_ledger,
1293: fem_entities_attr fea_bal_rule,
1294: fem_entities_attr fea_trs,
1295: fem_entities_attr fea_vrs,
1296: gcs_lex_map_rule_sets trs,
1297: gcs_lex_map_rule_sets vrs
1298: WHERE fea_ledger.entity_id = feb.entity_id
1299: AND fea_ledger.attribute_id = ledger_attr_id

Line 1351: fem_entities_attr fea_src,

1347: 1,
1348: -- Bug fix : 5843592
1349: to_date('01-01-1900','dd-MM-yyyy')
1350: FROM fem_entities_b feb,
1351: fem_entities_attr fea_src,
1352: fem_entities_attr fea_ledger,
1353: fem_entities_attr fea_bal_rule,
1354: fem_entities_attr fea_trs,
1355: fem_entities_attr fea_vrs,

Line 1352: fem_entities_attr fea_ledger,

1348: -- Bug fix : 5843592
1349: to_date('01-01-1900','dd-MM-yyyy')
1350: FROM fem_entities_b feb,
1351: fem_entities_attr fea_src,
1352: fem_entities_attr fea_ledger,
1353: fem_entities_attr fea_bal_rule,
1354: fem_entities_attr fea_trs,
1355: fem_entities_attr fea_vrs,
1356: gcs_lex_map_rule_sets trs,

Line 1353: fem_entities_attr fea_bal_rule,

1349: to_date('01-01-1900','dd-MM-yyyy')
1350: FROM fem_entities_b feb,
1351: fem_entities_attr fea_src,
1352: fem_entities_attr fea_ledger,
1353: fem_entities_attr fea_bal_rule,
1354: fem_entities_attr fea_trs,
1355: fem_entities_attr fea_vrs,
1356: gcs_lex_map_rule_sets trs,
1357: gcs_lex_map_rule_sets vrs

Line 1354: fem_entities_attr fea_trs,

1350: FROM fem_entities_b feb,
1351: fem_entities_attr fea_src,
1352: fem_entities_attr fea_ledger,
1353: fem_entities_attr fea_bal_rule,
1354: fem_entities_attr fea_trs,
1355: fem_entities_attr fea_vrs,
1356: gcs_lex_map_rule_sets trs,
1357: gcs_lex_map_rule_sets vrs
1358: WHERE fea_ledger.entity_id = feb.entity_id

Line 1355: fem_entities_attr fea_vrs,

1351: fem_entities_attr fea_src,
1352: fem_entities_attr fea_ledger,
1353: fem_entities_attr fea_bal_rule,
1354: fem_entities_attr fea_trs,
1355: fem_entities_attr fea_vrs,
1356: gcs_lex_map_rule_sets trs,
1357: gcs_lex_map_rule_sets vrs
1358: WHERE fea_ledger.entity_id = feb.entity_id
1359: AND fea_ledger.attribute_id = ledger_attr_id