APPS.JG_GL_ACCT_HIER_PKG dependencies on JG_ZZ_GL_ACCT_HIER_GT

Line 373: FROM JG_ZZ_GL_ACCT_HIER_GT

369: -- With a single top parent, should be able to go from detail up to the
370: -- top parent with an unique path.
371: CURSOR get_parent_vals IS
372: SELECT parent_value, parent_value_description, hierarchy_level
373: FROM JG_ZZ_GL_ACCT_HIER_GT
374: START WITH child_value = p_detail_acct
375: AND flex_value_set_id = p_value_set_id
376: -- AND summary_flag = 'Y'
377: -- AND hierarchy_level IS NOT NULL

Line 519: nvl((SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt

515: CURSOR next_level_flex(v_level NUMBER) IS
516: SELECT f.flex_value, f.description, f.enabled_flag, f.summary_flag,
517: substr(f.compiled_value_attributes,5,1) account_type,
518: f.flex_value_set_id, f.start_date_active, f.end_date_active,
519: nvl((SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt
520: WHERE gt.summary_flag = 'Y'
521: AND nvl(gt.hierarchy_level, -1) = v_level
522: AND gt.child_value = f.flex_value
523: AND EXISTS( SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt2

Line 523: AND EXISTS( SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt2

519: nvl((SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt
520: WHERE gt.summary_flag = 'Y'
521: AND nvl(gt.hierarchy_level, -1) = v_level
522: AND gt.child_value = f.flex_value
523: AND EXISTS( SELECT distinct 1 FROM JG_ZZ_GL_ACCT_HIER_GT gt2
524: WHERE gt2.PARENT_VALUE = gt.CHILD_VALUE)),0) record_exists
525: FROM FND_FLEX_VALUES_VL f
526: WHERE flex_value_set_id = p_value_set_id
527: AND flex_value IN (SELECT gt.child_value

Line 528: FROM JG_ZZ_GL_ACCT_HIER_GT gt

524: WHERE gt2.PARENT_VALUE = gt.CHILD_VALUE)),0) record_exists
525: FROM FND_FLEX_VALUES_VL f
526: WHERE flex_value_set_id = p_value_set_id
527: AND flex_value IN (SELECT gt.child_value
528: FROM JG_ZZ_GL_ACCT_HIER_GT gt
529: WHERE gt.summary_flag = 'Y'
530: AND nvl(gt.hierarchy_level, -1) = v_level);
531:
532: CURSOR flex_child(v_flex_parent VARCHAR2) IS

Line 563: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT

559: IF (val_rec.summary_flag = 'Y') THEN
560: IF (val_rec.enabled_flag = 'Y') THEN
561:
562: FOR child_rec IN flex_child(val_rec.flex_value) LOOP
563: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT
564: (parent_value,
565: parent_value_description,
566: child_value,
567: summary_flag,

Line 589: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT

585: END IF;
586:
587: -- Detail value
588: ELSIF (val_rec.summary_flag = 'N') THEN
589: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT
590: (parent_value,
591: parent_value_description,
592: child_value,
593: summary_flag,

Line 624: UPDATE JG_ZZ_GL_ACCT_HIER_GT

620:
621: FOR child_rec IN flex_child(val_rec.flex_value) LOOP
622:
623: IF (val_rec.record_exists = 1) THEN
624: UPDATE JG_ZZ_GL_ACCT_HIER_GT
625: SET hierarchy_level = l_level + 1
626: WHERE parent_value = val_rec.flex_value
627: AND child_value = child_rec.flex_value
628: AND flex_value_set_id = p_value_set_id;

Line 632: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT

628: AND flex_value_set_id = p_value_set_id;
629:
630: ELSE
631:
632: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT
633: (parent_value,
634: parent_value_description,
635: child_value,
636: summary_flag,

Line 659: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT

655: END IF;
656:
657: -- Detail value
658: /*ELSIF (val_rec.summary_flag = 'N') THEN
659: INSERT INTO JG_ZZ_GL_ACCT_HIER_GT
660: (parent_value,
661: parent_value_description,
662: child_value,
663: summary_flag,