APPS.OKC_DBTREE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

      node_updated   BOOLEAN;

Line: 56

  node_updated := FALSE;

Line: 66

                 node_updated := TRUE;

Line: 75

  IF NOT node_updated THEN
       IControlTable.EXTEND;

Line: 197

PROCEDURE DeleteControlRec
                (p_tree_id        IN   NUMBER
                 ,p_node_number   IN   NUMBER)
IS
    i             NUMBER := 0;

Line: 207

		IControlTable.DELETE(i);

Line: 215

	raise_application_error(-20195,'Failure inDeleteControlRec: ' || to_char(p_tree_id)
					|| ':' || to_char(p_node_number), TRUE);

Line: 218

END   DeleteControlRec;

Line: 243

		(p_delete_flag		IN	BOOLEAN
		,p_Package_name	 OUT NOCOPY VARCHAR2
		,p_program_name	 OUT NOCOPY VARCHAR2
		,p_entry_point	 OUT NOCOPY NUMBER
		,p_error_type	 OUT NOCOPY VARCHAR2
		,p_error_msg	 OUT NOCOPY VARCHAR2
		)
IS
BEGIN
	null;

Line: 319

       okc_dbtree_pvt.DeleteControlRec(p_tree_id, tDataTable(x).tree_node_id);

Line: 320

       tDataTable.DELETE(x);

Line: 353

        select  id,
                name,
                public_yn,
                created_by,
                creation_date,
                okc_query.GetChildCount(id) numchildren
         from   okc_k_groups_v g
        where   NOT EXISTS (select  1
                              from  okc_k_grpings_v p
                             where  p.included_cgp_id = g.id)
          AND   ( (g.public_yn = decode(gflag,'U','Y',gflag,'A','Y'))
                 OR (g.public_yn = decode(gflag,'P','N') AND created_by = 10589)
                 OR (gflag = 'A' AND created_by = 10589)
                )
        ORDER BY g.name;

Line: 373

        select  id,
                name,
                public_yn,
                created_by,
                creation_date,
                okc_query.GetChildCount(id) numchildren
         from   okc_k_groups_v g
        where   NOT EXISTS (select  1
                              from  okc_k_grpings_v p
                             where  p.included_cgp_id = g.id)
          AND   ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
                 OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
                 OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
                )
        ORDER BY g.name;

Line: 394

        select  id,
                name,
                public_yn,
                created_by,
                creation_date,
                okc_query.GetChildCount(id) numchildren
         from   okc_k_groups_v g
        where   NOT EXISTS (
				select  1
				from  okc_k_grpings_v p, okc_k_groups_v g1
				where  p.included_cgp_id = g.id
				and	g1.id = p.cgp_parent_id
				and 	g1.public_yn = 'Y'

				UNION

				select  1
				from  okc_k_grpings_v p, okc_k_groups_v g1
				where  p.included_cgp_id = g.id
				and	g1.id = p.cgp_parent_id
				AND   g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
			   )
          AND   ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
                 OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
                 OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
                )
        ORDER BY g.name;

Line: 613

          select  'GRP' rec_type,
                  g.id node_id,
                  g.included_cgp_id occur_id,
                  t.name node_name,
			   b.public_yn,
                  okc_query.GetChildCount(b.id) numchildren
           from   okc_k_grpings g,
                  okc_k_groups_b b,
                  okc_k_groups_tl t
          where   g.cgp_parent_id = p_grp_id
            and   g.included_cgp_id IS NOT NULL
            and   g.included_cgp_id = b.id
            and   b.id = t.id
            and   t.language = USERENV('LANG')
--    UNION
--          select  'KHDR' rec_type,
--                  g.id node_id,
--                  g.included_chr_id occur_id,
--                  b.contract_number node_name,
--                  okc_query.GetChildCount(b.id) numchildren
--           from   okc_k_grpings g,
--                  okc_k_headers_b b,
--                  okc_k_headers_tl t
--          where   g.cgp_parent_id = p_grp_id
--            and   g.included_chr_id IS NOT NULL
--            and   g.included_chr_id = b.id
--            and   b.id = t.id
--            and   t.language = USERENV('LANG')
   order by 4;