APPS.GCS_HIERARCHIES_PKG dependencies on GCS_CONS_RELATIONSHIPS_S

Line 710: (gcs_cons_relationships_s.nextval,

706: delta_owned,
707: dominant_parent_flag,
708: actual_ownership_flag)
709: VALUES
710: (gcs_cons_relationships_s.nextval,
711: p_hierarchy_id,
712: p_parent_entity_id,
713: p_original_entity_id,
714: 0,

Line 755: (gcs_cons_relationships_s.nextval,

751: delta_owned,
752: dominant_parent_flag,
753: actual_ownership_flag)
754: VALUES
755: (gcs_cons_relationships_s.nextval,
756: p_hierarchy_id,
757: p_parent_entity_id,
758: p_original_entity_id,
759: 0,

Line 801: (gcs_cons_relationships_s.nextval,

797: delta_owned,
798: dominant_parent_flag,
799: actual_ownership_flag)
800: VALUES
801: (gcs_cons_relationships_s.nextval,
802: p_hierarchy_id,
803: p_parent_entity_id,
804: p_original_entity_id,
805: 0,

Line 850: (gcs_cons_relationships_s.nextval,

846: delta_owned,
847: dominant_parent_flag,
848: actual_ownership_flag)
849: VALUES
850: (gcs_cons_relationships_s.nextval,
851: p_hierarchy_id,
852: p_parent_entity_id,
853: p_original_entity_id,
854: 0,

Line 1447: (gcs_cons_relationships_s.nextval,

1443: END_DATE,
1444: DOMINANT_PARENT_FLAG,
1445: ACTUAL_OWNERSHIP_FLAG)
1446: VALUES
1447: (gcs_cons_relationships_s.nextval,
1448: other_row.hierarchy_id,
1449: other_row.parent_entity_id,
1450: other_row.child_entity_id,
1451: other_row.ownership_percent,

Line 1511: (gcs_cons_relationships_s.nextval,

1507: END_DATE,
1508: DOMINANT_PARENT_FLAG,
1509: ACTUAL_OWNERSHIP_FLAG)
1510: VALUES
1511: (gcs_cons_relationships_s.nextval,
1512: l_hierarchy_id,
1513: l_parent_id,
1514: l_child_id,
1515: l_ownership,

Line 1548: (gcs_cons_relationships_s.nextval,

1544: END_DATE,
1545: DOMINANT_PARENT_FLAG,
1546: ACTUAL_OWNERSHIP_FLAG)
1547: VALUES
1548: (gcs_cons_relationships_s.nextval,
1549: l_hierarchy_id,
1550: l_parent_id,
1551: l_child_id,
1552: l_ownership,

Line 1591: SELECT gcs_cons_relationships_s.nextval,

1587: LAST_UPDATE_LOGIN,
1588: END_DATE,
1589: DOMINANT_PARENT_FLAG,
1590: ACTUAL_OWNERSHIP_FLAG)
1591: SELECT gcs_cons_relationships_s.nextval,
1592: r.hierarchy_id,
1593: r.parent_entity_id,
1594: r.child_entity_id,
1595: r.ownership_percent,

Line 1680: (gcs_cons_relationships_s.nextval,

1676: END_DATE,
1677: DOMINANT_PARENT_FLAG,
1678: ACTUAL_OWNERSHIP_FLAG)
1679: VALUES
1680: (gcs_cons_relationships_s.nextval,
1681: l_hierarchy_id,
1682: l_parent_id,
1683: l_child_id,
1684: l_ownership,

Line 1716: (gcs_cons_relationships_s.nextval,

1712: END_DATE,
1713: DOMINANT_PARENT_FLAG,
1714: ACTUAL_OWNERSHIP_FLAG)
1715: VALUES
1716: (gcs_cons_relationships_s.nextval,
1717: l_hierarchy_id,
1718: l_parent_id,
1719: l_child_id,
1720: l_ownership,

Line 1769: (gcs_cons_relationships_s.nextval,

1765: END_DATE,
1766: DOMINANT_PARENT_FLAG,
1767: ACTUAL_OWNERSHIP_FLAG)
1768: VALUES
1769: (gcs_cons_relationships_s.nextval,
1770: l_hierarchy_id,
1771: l_parent_id,
1772: l_child_id,
1773: l_ownership,

Line 1936: (gcs_cons_relationships_s.nextval,

1932: END_DATE,
1933: DOMINANT_PARENT_FLAG,
1934: ACTUAL_OWNERSHIP_FLAG)
1935: VALUES
1936: (gcs_cons_relationships_s.nextval,
1937: p_hier_id,
1938: p_parent_id,
1939: p_child_id,
1940: p_ownership,

Line 1978: (gcs_cons_relationships_s.nextval,

1974: END_DATE,
1975: DOMINANT_PARENT_FLAG,
1976: ACTUAL_OWNERSHIP_FLAG)
1977: VALUES
1978: (gcs_cons_relationships_s.nextval,
1979: p_hier_id,
1980: p_parent_id,
1981: p_child_id,
1982: p_ownership,

Line 2037: (gcs_cons_relationships_s.nextval,

2033: END_DATE,
2034: DOMINANT_PARENT_FLAG,
2035: ACTUAL_OWNERSHIP_FLAG)
2036: VALUES
2037: (gcs_cons_relationships_s.nextval,
2038: p_hier_id,
2039: p_parent_id,
2040: p_child_id,
2041: p_ownership,

Line 2157: SELECT gcs_cons_relationships_s.nextval,

2153: LAST_UPDATE_LOGIN,
2154: END_DATE,
2155: DOMINANT_PARENT_FLAG,
2156: ACTUAL_OWNERSHIP_FLAG)
2157: SELECT gcs_cons_relationships_s.nextval,
2158: p_hier_id,
2159: l_child_id,
2160: fea.DIM_ATTRIBUTE_NUMERIC_MEMBER,
2161: 100,