APPS.GCS_ENTRY_PKG dependencies on GCS_ENTRY_HEADERS_S

Line 173: SELECT hierarchy_id, gcs_entry_headers_s.NEXTVAL BULK COLLECT

169: END IF;
170:
171: -- Retreive the hierarchies , present in teh chosen hierarchy group
172: -- Create a new entry ID for each of the hierarchy
173: SELECT hierarchy_id, gcs_entry_headers_s.NEXTVAL BULK COLLECT
174: INTO l_hierarchy_id, l_entry_id
175: FROM gcs_hier_grp_members
176: WHERE hierarchy_grp_id = p_hierarchy_grp_id;
177:

Line 997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;

993: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
994: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
995: END IF;
996: IF p_entry_id IS NULL THEN
997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;
998: END IF;
999: get_entry_header(p_category_code => p_category_code,
1000: p_xlate_flag => p_xlate_flag,
1001: p_entry_id => p_entry_id,