APPS.GCS_WEBADI_PKG dependencies on GCS_HIER_MEMBERS_T

Line 1569: INSERT INTO gcs_hier_members_t

1565: END IF;
1566:
1567: IF (p_mvs_flag = 'Y') THEN
1568: -- add root nodes
1569: INSERT INTO gcs_hier_members_t
1570: (sequence_num,
1571: parent_vs_display_code,
1572: parent_display_code,
1573: child_vs_display_code,

Line 1592: FROM gcs_hier_members_t

1588: l_user_id,
1589: SYSDATE,
1590: l_user_id,
1591: l_login_id
1592: FROM gcs_hier_members_t
1593: WHERE sequence_num = p_sequence_num;
1594:
1595: END IF;
1596:

Line 1648: FROM gcs_hier_members_t

1644: SELECT DISTINCT p_hierarchy_name,
1645: child_vs_display_code,
1646: USERENV('LANG'),
1647: 'LOAD'
1648: FROM gcs_hier_members_t
1649: WHERE sequence_num = p_sequence_num;
1650:
1651: BEGIN
1652: INSERT INTO fem_hier_value_sets_t

Line 1658: FROM gcs_hier_members_t

1654: SELECT DISTINCT p_hierarchy_name,
1655: parent_vs_display_code,
1656: USERENV('LANG'),
1657: 'LOAD'
1658: FROM gcs_hier_members_t
1659: WHERE sequence_num = p_sequence_num;
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: NULL;

Line 1688: FROM gcs_hier_members_t

1684: rownum, -- bugfix : 5411156
1685: NULL,
1686: ''LOAD'',
1687: USERENV(''LANG'')
1688: FROM gcs_hier_members_t
1689: WHERE sequence_num = :3 ';
1690:
1691: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
1692: fnd_log.STRING(fnd_log.level_statement,

Line 1736: ' dim_table, gcs_hier_members_t intf_table' ||

1732: ' dim_table.parent_value_set_display_code, dim_table.child_value_set_display_code, dim_table.status ' ||
1733: ' FROM ' ||
1734: g_dimension_info(p_dimension_varchar_label)
1735: .hier_t_table_name ||
1736: ' dim_table, gcs_hier_members_t intf_table' ||
1737: ' WHERE intf_table.parent_display_code = dim_table.parent_display_code ' ||
1738: ' AND intf_table.child_display_code = dim_table.child_display_code ' ||
1739: ' AND intf_table.sequence_num = :1 ' BULK COLLECT
1740: INTO l_err_parent_display_code, l_err_child_display_code, l_err_parent_vs_display_code, l_err_child_vs_display_code, l_err_status

Line 1827: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;

1823:
1824: END IF;
1825:
1826: -- delete submitted data for this run
1827: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1828:
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,
1830: g_pkg_name || '.' || l_api_name || ' EXIT');
1831: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1846: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;

1842: ROLLBACK TO dh_import_start;
1843:
1844: x_retcode := '2';
1845:
1846: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1847:
1848: FND_FILE.PUT_LINE(FND_FILE.LOG,
1849: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1850: x_errbuf);

Line 1862: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;

1858:
1859: x_errbuf := SQLERRM;
1860: x_retcode := '2';
1861:
1862: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1863:
1864: FND_FILE.PUT_LINE(FND_FILE.LOG,
1865: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1866: x_errbuf);