DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PRINTING_PKG dependencies on OKE_K_LINES_FULL_HV

Line 38: FROM OKE_K_LINES_FULL_HV

34: isTop_line varchar2(1) :='?';
35:
36: cursor c_isTop_line is
37: select 'x'
38: FROM OKE_K_LINES_FULL_HV
39: WHERE k_line_id= vk_line_id
40: AND parent_line_id is NULL
41: AND MAJOR_VERSION=vVersion;
42:

Line 46: FROM OKE_K_LINES_FULL_HV

42:
43: BEGIN
44: SELECT line_number
45: INTO l_linenum
46: FROM OKE_K_LINES_FULL_HV
47: WHERE k_line_id =vk_line_id
48: AND MAJOR_VERSION=vVersion;
49:
50: OPEN c_isTop_line;

Line 59: FROM OKE_K_LINES_FULL_HV

55: RETURN l_linenum;
56: ELSE
57: SELECT parent_line_id
58: INTO l_parent_id
59: FROM OKE_K_LINES_FULL_HV
60: WHERE k_line_id=vk_line_id
61: AND MAJOR_VERSION=vVersion;
62: RETURN (get_full_path_linenum(l_parent_id,vVersion)||'-->'||l_linenum);
63: