APPS.ENI_PROD_VALUESET dependencies on ENI_VSET_HRCHY_TEMP

Line 70: FROM eni_vset_hrchy_temp

66: AND a.category_id = b.category_id
67: AND b.structure_id = l_struct_id
68: INTERSECT
69: SELECT child_code nodes
70: FROM eni_vset_hrchy_temp
71: WHERE hrchy_flag = 'P'
72: -- AND parent_code is not null
73: START with child_code = l_top_node
74: CONNECT BY child_code = prior parent_code;

Line 198: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';

194: -- Once we figure out if the top node is selected or not, the flag
195: -- is set to "Y". All transactions following that would look at
196: -- hrchy_flag = "Y"
197:
198: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';
199:
200: INSERT INTO ENI_VSET_HRCHY_TEMP(
201: CHILD_CODE,
202: PARENT_CODE,

Line 200: INSERT INTO ENI_VSET_HRCHY_TEMP(

196: -- hrchy_flag = "Y"
197:
198: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_VSET_HRCHY_TEMP';
199:
200: INSERT INTO ENI_VSET_HRCHY_TEMP(
201: CHILD_CODE,
202: PARENT_CODE,
203: SUMMARY_FLAG,
204: child_value_id,

Line 271: INSERT INTO ENI_VSET_HRCHY_TEMP (

267: -- into the temp table
268:
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating hierarchy in temp table under the top node');
270:
271: INSERT INTO ENI_VSET_HRCHY_TEMP (
272: CHILD_CODE,
273: PARENT_CODE,
274: SUMMARY_FLAG,
275: CHILD_VALUE_ID,

Line 288: FROM ENI_VSET_HRCHY_TEMP H

284: ENABLED_FLAG,
285: START_DATE_ACTIVE,
286: END_DATE_ACTIVE,
287: 'Y'
288: FROM ENI_VSET_HRCHY_TEMP H
289: CONNECT BY PRIOR CHILD_CODE = PARENT_CODE
290: START WITH CHILD_CODE = l_top_node;
291:
292: else

Line 299: UPDATE eni_vset_hrchy_temp

295: -- if top node is not null, change the hrchy_flag to "Y"
296: -- this is so that with or without the top node, we can look
297: -- at the same where clause
298:
299: UPDATE eni_vset_hrchy_temp
300: SET hrchy_flag = 'Y'
301: WHERE hrchy_flag = 'P';
302: end if;
303: