eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_T dependencies on EDW_GL_ACCT1_M

Line 21: value edw_gl_acct1_m.l1_pk%TYPE,

17: g_all varchar2(100);
18:
19:
20: TYPE t_value_desc_pair_rec IS RECORD (
21: value edw_gl_acct1_m.l1_pk%TYPE,
22: name edw_gl_acct1_m.l1_name%TYPE,
23: type edw_gl_acct1_m.l1_type%TYPE,
24: description edw_gl_acct1_m.l1_description%TYPE);
25:

Line 22: name edw_gl_acct1_m.l1_name%TYPE,

18:
19:
20: TYPE t_value_desc_pair_rec IS RECORD (
21: value edw_gl_acct1_m.l1_pk%TYPE,
22: name edw_gl_acct1_m.l1_name%TYPE,
23: type edw_gl_acct1_m.l1_type%TYPE,
24: description edw_gl_acct1_m.l1_description%TYPE);
25:
26: TYPE t_vbh_level_table IS TABLE OF t_value_desc_pair_rec

Line 23: type edw_gl_acct1_m.l1_type%TYPE,

19:
20: TYPE t_value_desc_pair_rec IS RECORD (
21: value edw_gl_acct1_m.l1_pk%TYPE,
22: name edw_gl_acct1_m.l1_name%TYPE,
23: type edw_gl_acct1_m.l1_type%TYPE,
24: description edw_gl_acct1_m.l1_description%TYPE);
25:
26: TYPE t_vbh_level_table IS TABLE OF t_value_desc_pair_rec
27: INDEX BY BINARY_INTEGER;

Line 24: description edw_gl_acct1_m.l1_description%TYPE);

20: TYPE t_value_desc_pair_rec IS RECORD (
21: value edw_gl_acct1_m.l1_pk%TYPE,
22: name edw_gl_acct1_m.l1_name%TYPE,
23: type edw_gl_acct1_m.l1_type%TYPE,
24: description edw_gl_acct1_m.l1_description%TYPE);
25:
26: TYPE t_vbh_level_table IS TABLE OF t_value_desc_pair_rec
27: INDEX BY BINARY_INTEGER;
28: g_vbh_level_table t_vbh_level_table;

Line 378: p_pk IN edw_gl_acct1_m.l1_name%TYPE,

374: VBHDEBUG(' ');
375: END;
376:
377: procedure insert_default_value(
378: p_pk IN edw_gl_acct1_m.l1_name%TYPE,
379: p_pk_key IN edw_gl_acct1_m.l1_pk_key%TYPE,
380: p_name IN edw_gl_acct1_m.l1_name%TYPE,
381: p_desc IN edw_gl_acct1_m.l1_description%TYPE) as
382: l_cursor_id integer;

Line 379: p_pk_key IN edw_gl_acct1_m.l1_pk_key%TYPE,

375: END;
376:
377: procedure insert_default_value(
378: p_pk IN edw_gl_acct1_m.l1_name%TYPE,
379: p_pk_key IN edw_gl_acct1_m.l1_pk_key%TYPE,
380: p_name IN edw_gl_acct1_m.l1_name%TYPE,
381: p_desc IN edw_gl_acct1_m.l1_description%TYPE) as
382: l_cursor_id integer;
383: l_insert_stmt varchar2(5000);

Line 380: p_name IN edw_gl_acct1_m.l1_name%TYPE,

376:
377: procedure insert_default_value(
378: p_pk IN edw_gl_acct1_m.l1_name%TYPE,
379: p_pk_key IN edw_gl_acct1_m.l1_pk_key%TYPE,
380: p_name IN edw_gl_acct1_m.l1_name%TYPE,
381: p_desc IN edw_gl_acct1_m.l1_description%TYPE) as
382: l_cursor_id integer;
383: l_insert_stmt varchar2(5000);
384: l_rows_inserted integer :=0;

Line 381: p_desc IN edw_gl_acct1_m.l1_description%TYPE) as

377: procedure insert_default_value(
378: p_pk IN edw_gl_acct1_m.l1_name%TYPE,
379: p_pk_key IN edw_gl_acct1_m.l1_pk_key%TYPE,
380: p_name IN edw_gl_acct1_m.l1_name%TYPE,
381: p_desc IN edw_gl_acct1_m.l1_description%TYPE) as
382: l_cursor_id integer;
383: l_insert_stmt varchar2(5000);
384: l_rows_inserted integer :=0;
385:

Line 656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,

652: ---------------------------------------------------------------------------
653: PROCEDURE update_dimension(
654: p_CursorID IN integer,
655: p_hierachy_no IN number,
656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,
657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 657: p_type IN edw_gl_acct1_m.l1_type%TYPE,

653: PROCEDURE update_dimension(
654: p_CursorID IN integer,
655: p_hierachy_no IN number,
656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,
657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,

654: p_CursorID IN integer,
655: p_hierachy_no IN number,
656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,
657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,

655: p_hierachy_no IN number,
656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,
657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,

656: p_pk IN edw_gl_acct1_m.l1_pk%TYPE,
657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,

657: p_type IN edw_gl_acct1_m.l1_type%TYPE,
658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,

658: p_level2 IN edw_gl_acct1_m.l1_pk%TYPE,
659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,

659: p_level2_name IN edw_gl_acct1_m.l1_name%TYPE,
660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,

660: p_level2_type IN edw_gl_acct1_m.l1_type%TYPE,
661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,

661: p_level2_desc IN edw_gl_acct1_m.l1_description%TYPE,
662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,

662: p_level3 IN edw_gl_acct1_m.l1_pk%TYPE,
663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,

663: p_level3_name IN edw_gl_acct1_m.l1_name%TYPE,
664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,

664: p_level3_type IN edw_gl_acct1_m.l1_type%TYPE,
665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,

665: p_level3_desc IN edw_gl_acct1_m.l1_description%TYPE,
666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,

666: p_level4 IN edw_gl_acct1_m.l1_pk%TYPE,
667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,

667: p_level4_name IN edw_gl_acct1_m.l1_name%TYPE,
668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,

668: p_level4_type IN edw_gl_acct1_m.l1_type%TYPE,
669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,

669: p_level4_desc IN edw_gl_acct1_m.l1_description%TYPE,
670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,

670: p_level5 IN edw_gl_acct1_m.l1_pk%TYPE,
671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,

671: p_level5_name IN edw_gl_acct1_m.l1_name%TYPE,
672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,

672: p_level5_type IN edw_gl_acct1_m.l1_type%TYPE,
673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,

673: p_level5_desc IN edw_gl_acct1_m.l1_description%TYPE,
674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,

674: p_level6 IN edw_gl_acct1_m.l1_pk%TYPE,
675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,

675: p_level6_name IN edw_gl_acct1_m.l1_name%TYPE,
676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,

676: p_level6_type IN edw_gl_acct1_m.l1_type%TYPE,
677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,

677: p_level6_desc IN edw_gl_acct1_m.l1_description%TYPE,
678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,

678: p_level7 IN edw_gl_acct1_m.l1_pk%TYPE,
679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,

679: p_level7_name IN edw_gl_acct1_m.l1_name%TYPE,
680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,

680: p_level7_type IN edw_gl_acct1_m.l1_type%TYPE,
681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,

681: p_level7_desc IN edw_gl_acct1_m.l1_description%TYPE,
682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,

682: p_level8 IN edw_gl_acct1_m.l1_pk%TYPE,
683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,

683: p_level8_name IN edw_gl_acct1_m.l1_name%TYPE,
684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,

684: p_level8_type IN edw_gl_acct1_m.l1_type%TYPE,
685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,

685: p_level8_desc IN edw_gl_acct1_m.l1_description%TYPE,
686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,

686: p_level9 IN edw_gl_acct1_m.l1_pk%TYPE,
687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,

687: p_level9_name IN edw_gl_acct1_m.l1_name%TYPE,
688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,

688: p_level9_type IN edw_gl_acct1_m.l1_type%TYPE,
689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,

689: p_level9_desc IN edw_gl_acct1_m.l1_description%TYPE,
690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,

690: p_level10 IN edw_gl_acct1_m.l1_pk%TYPE,
691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,

691: p_level10_name IN edw_gl_acct1_m.l1_name%TYPE,
692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,

692: p_level10_type IN edw_gl_acct1_m.l1_type%TYPE,
693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,

693: p_level10_desc IN edw_gl_acct1_m.l1_description%TYPE,
694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,

694: p_level11 IN edw_gl_acct1_m.l1_pk%TYPE,
695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,

695: p_level11_name IN edw_gl_acct1_m.l1_name%TYPE,
696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,

696: p_level11_type IN edw_gl_acct1_m.l1_type%TYPE,
697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,

697: p_level11_desc IN edw_gl_acct1_m.l1_description%TYPE,
698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,

698: p_level12 IN edw_gl_acct1_m.l1_pk%TYPE,
699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,

699: p_level12_name IN edw_gl_acct1_m.l1_name%TYPE,
700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,

700: p_level12_type IN edw_gl_acct1_m.l1_type%TYPE,
701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,

701: p_level12_desc IN edw_gl_acct1_m.l1_description%TYPE,
702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,

702: p_level13 IN edw_gl_acct1_m.l1_pk%TYPE,
703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,

Line 707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,

703: p_level13_name IN edw_gl_acct1_m.l1_name%TYPE,
704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,

Line 708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,

704: p_level13_type IN edw_gl_acct1_m.l1_type%TYPE,
705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,

Line 709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,

705: p_level13_desc IN edw_gl_acct1_m.l1_description%TYPE,
706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,

Line 710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,

706: p_level14 IN edw_gl_acct1_m.l1_pk%TYPE,
707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,
714: p_all_name in edw_gl_acct1_m.all_name%TYPE,

Line 711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,

707: p_level14_name IN edw_gl_acct1_m.l1_name%TYPE,
708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,
714: p_all_name in edw_gl_acct1_m.all_name%TYPE,
715: p_RowsUpdated IN OUT NOCOPY INTEGER

Line 712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,

708: p_level14_type IN edw_gl_acct1_m.l1_type%TYPE,
709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,
714: p_all_name in edw_gl_acct1_m.all_name%TYPE,
715: p_RowsUpdated IN OUT NOCOPY INTEGER
716: ) AS

Line 713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,

709: p_level14_desc IN edw_gl_acct1_m.l1_description%TYPE,
710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,
714: p_all_name in edw_gl_acct1_m.all_name%TYPE,
715: p_RowsUpdated IN OUT NOCOPY INTEGER
716: ) AS
717:

Line 714: p_all_name in edw_gl_acct1_m.all_name%TYPE,

710: p_level15 IN edw_gl_acct1_m.l1_pk%TYPE,
711: p_level15_name IN edw_gl_acct1_m.l1_name%TYPE,
712: p_level15_type IN edw_gl_acct1_m.l1_type%TYPE,
713: p_level15_desc IN edw_gl_acct1_m.l1_description%TYPE,
714: p_all_name in edw_gl_acct1_m.all_name%TYPE,
715: p_RowsUpdated IN OUT NOCOPY INTEGER
716: ) AS
717:
718: l_CursorID INTEGER;

Line 1041: value edw_gl_acct1_m.l1_pk%TYPE,

1037:
1038: FUNCTION PROCESS_ROOT (p_root_value varchar, p_hieno integer, p_curid in integer)
1039: RETURN INTEGER IS
1040: TYPE t_value_desc_pair_rec IS RECORD (
1041: value edw_gl_acct1_m.l1_pk%TYPE,
1042: name edw_gl_acct1_m.l1_name%TYPE,
1043: type edw_gl_acct1_m.l1_type%TYPE,
1044: description edw_gl_acct1_m.l1_description%TYPE);
1045:

Line 1042: name edw_gl_acct1_m.l1_name%TYPE,

1038: FUNCTION PROCESS_ROOT (p_root_value varchar, p_hieno integer, p_curid in integer)
1039: RETURN INTEGER IS
1040: TYPE t_value_desc_pair_rec IS RECORD (
1041: value edw_gl_acct1_m.l1_pk%TYPE,
1042: name edw_gl_acct1_m.l1_name%TYPE,
1043: type edw_gl_acct1_m.l1_type%TYPE,
1044: description edw_gl_acct1_m.l1_description%TYPE);
1045:
1046: l_descLookup_timestamp Date:=Null;

Line 1043: type edw_gl_acct1_m.l1_type%TYPE,

1039: RETURN INTEGER IS
1040: TYPE t_value_desc_pair_rec IS RECORD (
1041: value edw_gl_acct1_m.l1_pk%TYPE,
1042: name edw_gl_acct1_m.l1_name%TYPE,
1043: type edw_gl_acct1_m.l1_type%TYPE,
1044: description edw_gl_acct1_m.l1_description%TYPE);
1045:
1046: l_descLookup_timestamp Date:=Null;
1047:

Line 1044: description edw_gl_acct1_m.l1_description%TYPE);

1040: TYPE t_value_desc_pair_rec IS RECORD (
1041: value edw_gl_acct1_m.l1_pk%TYPE,
1042: name edw_gl_acct1_m.l1_name%TYPE,
1043: type edw_gl_acct1_m.l1_type%TYPE,
1044: description edw_gl_acct1_m.l1_description%TYPE);
1045:
1046: l_descLookup_timestamp Date:=Null;
1047:
1048: TYPE t_cur_description IS ref cursor;

Line 1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;

1300: l_table_counter INTEGER;
1301: l_hierachy_no NUMBER;
1302: l_rowsUpdated INTEGER;
1303: l_root_value edw_vbh_temp1.parent%TYPE;
1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;
1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;
1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;
1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;
1308: l_temp_table_name varchar2(30);

Line 1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;

1301: l_hierachy_no NUMBER;
1302: l_rowsUpdated INTEGER;
1303: l_root_value edw_vbh_temp1.parent%TYPE;
1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;
1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;
1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;
1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;
1308: l_temp_table_name varchar2(30);
1309: l_value_stmt varchar2(1000);

Line 1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;

1302: l_rowsUpdated INTEGER;
1303: l_root_value edw_vbh_temp1.parent%TYPE;
1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;
1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;
1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;
1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;
1308: l_temp_table_name varchar2(30);
1309: l_value_stmt varchar2(1000);
1310: l_root_counter Integer :=0;

Line 1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;

1303: l_root_value edw_vbh_temp1.parent%TYPE;
1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;
1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;
1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;
1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;
1308: l_temp_table_name varchar2(30);
1309: l_value_stmt varchar2(1000);
1310: l_root_counter Integer :=0;
1311: l_check_sob_id number;

Line 1323: value edw_gl_acct1_m.l1_pk%TYPE,

1319: l_progress_status boolean;
1320:
1321:
1322: TYPE t_value_desc_pair_rec IS RECORD (
1323: value edw_gl_acct1_m.l1_pk%TYPE,
1324: name edw_gl_acct1_m.l1_name%TYPE,
1325: type edw_gl_acct1_m.l1_type%TYPE,
1326: description edw_gl_acct1_m.l1_description%TYPE);
1327: l_root_value_desc_pair t_value_desc_pair_rec;

Line 1324: name edw_gl_acct1_m.l1_name%TYPE,

1320:
1321:
1322: TYPE t_value_desc_pair_rec IS RECORD (
1323: value edw_gl_acct1_m.l1_pk%TYPE,
1324: name edw_gl_acct1_m.l1_name%TYPE,
1325: type edw_gl_acct1_m.l1_type%TYPE,
1326: description edw_gl_acct1_m.l1_description%TYPE);
1327: l_root_value_desc_pair t_value_desc_pair_rec;
1328:

Line 1325: type edw_gl_acct1_m.l1_type%TYPE,

1321:
1322: TYPE t_value_desc_pair_rec IS RECORD (
1323: value edw_gl_acct1_m.l1_pk%TYPE,
1324: name edw_gl_acct1_m.l1_name%TYPE,
1325: type edw_gl_acct1_m.l1_type%TYPE,
1326: description edw_gl_acct1_m.l1_description%TYPE);
1327: l_root_value_desc_pair t_value_desc_pair_rec;
1328:
1329: Type t_vbh_root_table is table of edw_vbh_roots.root_value1%type

Line 1326: description edw_gl_acct1_m.l1_description%TYPE);

1322: TYPE t_value_desc_pair_rec IS RECORD (
1323: value edw_gl_acct1_m.l1_pk%TYPE,
1324: name edw_gl_acct1_m.l1_name%TYPE,
1325: type edw_gl_acct1_m.l1_type%TYPE,
1326: description edw_gl_acct1_m.l1_description%TYPE);
1327: l_root_value_desc_pair t_value_desc_pair_rec;
1328:
1329: Type t_vbh_root_table is table of edw_vbh_roots.root_value1%type
1330: index by binary_integer;