209: SYSDATE,
210: 0,
211: SYSDATE,
212: 0,
213: fnd_global.login_id);
214:
215: IF ( parent_value_set_id = child_value_set_id ) THEN
216: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
217: ( flex_value_set_id,
233: SYSDATE,
234: 0,
235: SYSDATE,
236: 0,
237: fnd_global.login_id);
238: END IF;
239:
240: END IF;
241:
276: SYSDATE,
277: 0,
278: SYSDATE,
279: 0,
280: fnd_global.login_id );
281:
282: IF ( parent_value_set_id = child_value_set_id ) THEN
283: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
284: ( flex_value_set_id,
300: SYSDATE,
301: 0,
302: SYSDATE,
303: 0,
304: fnd_global.login_id);
305: END IF;
306: END IF;
307: END IF;
308: RETURN (1);
644: FROM fii_financial_dimensions_v m
645: WHERE m.dimension_short_name= r.dimension_short_name);
646: sid number;
647: BEGIN
648: FND_GLOBAL.APPS_INITIALIZE(user_id, resp_id, appl_id);
649:
650: OPEN find_dim_value_sets_cur;
651: LOOP
652: FETCH find_dim_value_sets_cur INTO fdvsid;
795: RETURN cvalue;
796: ELSIF (ct=0) then
797: cvalue := dvalue;
798: ELSE
799: cvalue := cvalue||fnd_global.newline||dvalue;
800: END IF;
801: ct:= ct+1;
802: END LOOP;
803: CLOSE find_value_attr_cur;
928: SYSDATE,
929: 0,
930: SYSDATE,
931: 0,
932: fnd_global.login_id);
933:
934: END insert_fnd_norm_hier_rec;
935:
936: