APPS.JTF_NOTES_PKG dependencies on JTF_OBJECTS_B

Line 535: l_select_id jtf_objects_b.select_id%TYPE;

531: FUNCTION get_note_context_value( p_note_context_type IN VARCHAR2
532: , p_note_context_type_id IN NUMBER )
533: RETURN VARCHAR2 IS
534: l_note_context_value VARCHAR2(240);
535: l_select_id jtf_objects_b.select_id%TYPE;
536: l_select_name jtf_objects_b.select_name%TYPE;
537: l_tablename jtf_objects_b.from_table%TYPE;
538: l_where_clause jtf_objects_b.where_clause%TYPE;
539: v_cursor NUMBER;

Line 536: l_select_name jtf_objects_b.select_name%TYPE;

532: , p_note_context_type_id IN NUMBER )
533: RETURN VARCHAR2 IS
534: l_note_context_value VARCHAR2(240);
535: l_select_id jtf_objects_b.select_id%TYPE;
536: l_select_name jtf_objects_b.select_name%TYPE;
537: l_tablename jtf_objects_b.from_table%TYPE;
538: l_where_clause jtf_objects_b.where_clause%TYPE;
539: v_cursor NUMBER;
540: v_create_string VARCHAR2(3000);

Line 537: l_tablename jtf_objects_b.from_table%TYPE;

533: RETURN VARCHAR2 IS
534: l_note_context_value VARCHAR2(240);
535: l_select_id jtf_objects_b.select_id%TYPE;
536: l_select_name jtf_objects_b.select_name%TYPE;
537: l_tablename jtf_objects_b.from_table%TYPE;
538: l_where_clause jtf_objects_b.where_clause%TYPE;
539: v_cursor NUMBER;
540: v_create_string VARCHAR2(3000);
541: v_numrows NUMBER;

Line 538: l_where_clause jtf_objects_b.where_clause%TYPE;

534: l_note_context_value VARCHAR2(240);
535: l_select_id jtf_objects_b.select_id%TYPE;
536: l_select_name jtf_objects_b.select_name%TYPE;
537: l_tablename jtf_objects_b.from_table%TYPE;
538: l_where_clause jtf_objects_b.where_clause%TYPE;
539: v_cursor NUMBER;
540: v_create_string VARCHAR2(3000);
541: v_numrows NUMBER;
542: