DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PRINTING_PKG dependencies on OKE_K_LINES_FULL_V

Line 82: FROM OKE_K_LINES_FULL_V

78: isTop_line varchar2(1) :='?';
79:
80: cursor c_isTop_line is
81: select 'x'
82: FROM OKE_K_LINES_FULL_V
83: WHERE k_line_id= vk_line_id
84: AND parent_line_id is NULL;
85:
86: BEGIN

Line 89: FROM OKE_K_LINES_FULL_V

85:
86: BEGIN
87: SELECT line_number
88: INTO l_linenum
89: FROM OKE_K_LINES_FULL_V
90: WHERE k_line_id =vk_line_id;
91:
92: OPEN c_isTop_line;
93: FETCH c_isTop_line INTO isTop_line;

Line 101: FROM OKE_K_LINES_FULL_V

97: RETURN l_linenum;
98: ELSE
99: SELECT parent_line_id
100: INTO l_parent_id
101: FROM OKE_K_LINES_FULL_V
102: WHERE k_line_id=vk_line_id;
103: RETURN (get_full_path_linenum(l_parent_id)||'-->'||l_linenum);
104:
105: END IF;