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.LNS_LOAN_HISTORY_PUB dependencies on DBMS_SQL

Line 15: l_cursorID := DBMS_SQL.OPEN_CURSOR;

11: l_dummy INTEGER;
12: l_index NUMBER;
13:
14: BEGIN
15: l_cursorID := DBMS_SQL.OPEN_CURSOR;
16:
17: --l_select_col_stmt := 'select column_name, data_type from dba_tab_columns' || ' where table_name = :tab_name and owner = ''LNS'' order by column_id';
18: l_select_col_stmt := 'select col.column_name, col.data_type from all_tab_columns col where col.table_name = ad_zd_table.ev_view(:tab_name) and col.owner = ''LNS'' order by col.column_id';
19:

Line 22: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);

18: l_select_col_stmt := 'select col.column_name, col.data_type from all_tab_columns col where col.table_name = ad_zd_table.ev_view(:tab_name) and col.owner = ''LNS'' order by col.column_id';
19:
20: l_select_val_stmt := 'select';
21:
22: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);
23: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);
24:
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);

Line 23: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);

19:
20: l_select_val_stmt := 'select';
21:
22: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);
23: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);
24:
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);
27:

Line 25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);

21:
22: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);
23: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);
24:
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);
27:
28: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
29:

Line 26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);

22: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);
23: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);
24:
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);
27:
28: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
29:
30: l_index := 1;

Line 28: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

24:
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
26: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);
27:
28: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
29:
30: l_index := 1;
31: LOOP
32: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN

Line 32: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN

28: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
29:
30: l_index := 1;
31: LOOP
32: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
33: EXIT;
34: END IF;
35:
36: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_column_name);

Line 36: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_column_name);

32: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
33: EXIT;
34: END IF;
35:
36: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_column_name);
37: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_data_type);
38:
39: IF (l_column_name NOT IN ('CREATED_BY', 'CREATION_DATE',
40: 'LAST_UPDATED_BY', 'LAST_UPDATE_DATE', 'LAST_UPDATE_LOGIN'

Line 37: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_data_type);

33: EXIT;
34: END IF;
35:
36: DBMS_SQL.COLUMN_VALUE(l_cursorID, 1, l_column_name);
37: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_data_type);
38:
39: IF (l_column_name NOT IN ('CREATED_BY', 'CREATION_DATE',
40: 'LAST_UPDATED_BY', 'LAST_UPDATE_DATE', 'LAST_UPDATE_LOGIN'
41: , 'OBJECT_VERSION_NUMBER')) THEN

Line 78: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

74: END LOOP;
75:
76: l_index := G_VALUE_LIST.count;
77:
78: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
79:
80: IF (length(l_select_val_stmt) > 6) THEN
81:
82: l_select_val_stmt := l_select_val_stmt || ' from ' || p_table_name || ' where ';

Line 85: l_cursorID := DBMS_SQL.OPEN_CURSOR;

81:
82: l_select_val_stmt := l_select_val_stmt || ' from ' || p_table_name || ' where ';
83: l_select_val_stmt := l_select_val_stmt || p_primary_key_name || ' = :p_id';
84:
85: l_cursorID := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(l_cursorID, l_select_val_stmt, DBMS_SQL.V7);
87:
88: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':p_id', p_id);
89:

Line 86: DBMS_SQL.PARSE(l_cursorID, l_select_val_stmt, DBMS_SQL.V7);

82: l_select_val_stmt := l_select_val_stmt || ' from ' || p_table_name || ' where ';
83: l_select_val_stmt := l_select_val_stmt || p_primary_key_name || ' = :p_id';
84:
85: l_cursorID := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(l_cursorID, l_select_val_stmt, DBMS_SQL.V7);
87:
88: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':p_id', p_id);
89:
90: FOR i in 1..l_index LOOP

Line 88: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':p_id', p_id);

84:
85: l_cursorID := DBMS_SQL.OPEN_CURSOR;
86: DBMS_SQL.PARSE(l_cursorID, l_select_val_stmt, DBMS_SQL.V7);
87:
88: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':p_id', p_id);
89:
90: FOR i in 1..l_index LOOP
91:
92: IF (p_mode = 'PRE') THEN

Line 93: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).old_value, 2000);

89:
90: FOR i in 1..l_index LOOP
91:
92: IF (p_mode = 'PRE') THEN
93: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).old_value, 2000);
94: ELSE
95: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).new_value, 2000);
96: END IF;
97: END LOOP;

Line 95: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).new_value, 2000);

91:
92: IF (p_mode = 'PRE') THEN
93: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).old_value, 2000);
94: ELSE
95: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).new_value, 2000);
96: END IF;
97: END LOOP;
98:
99: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

Line 99: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);

95: DBMS_SQL.DEFINE_COLUMN(l_cursorID, i, G_VALUE_LIST(i).new_value, 2000);
96: END IF;
97: END LOOP;
98:
99: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
100:
101: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
102: RAISE NO_DATA_FOUND;
103: END IF;

Line 101: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN

97: END LOOP;
98:
99: l_dummy := DBMS_SQL.EXECUTE(l_cursorID);
100:
101: IF DBMS_SQL.FETCH_ROWS(l_cursorID) = 0 THEN
102: RAISE NO_DATA_FOUND;
103: END IF;
104:
105: FOR i in 1..l_index LOOP

Line 107: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).old_value);

103: END IF;
104:
105: FOR i in 1..l_index LOOP
106: IF (p_mode = 'PRE') THEN
107: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).old_value);
108: ELSE
109: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).new_value);
110: END IF;
111: END LOOP;

Line 109: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).new_value);

105: FOR i in 1..l_index LOOP
106: IF (p_mode = 'PRE') THEN
107: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).old_value);
108: ELSE
109: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).new_value);
110: END IF;
111: END LOOP;
112:
113: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 113: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

109: DBMS_SQL.COLUMN_VALUE(l_cursorID, i, G_VALUE_LIST(i).new_value);
110: END IF;
111: END LOOP;
112:
113: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
114: ELSE
115: raise FND_API.G_EXC_ERROR;
116: -- NO TABLE INFORMATION FOUND. RAISE ERROR HERE
117: END IF;

Line 128: dbms_sql.close_cursor(l_cursorID);

124: END LOOP;
125: */
126: exception
127: when others then
128: dbms_sql.close_cursor(l_cursorID);
129: raise;
130: end get_record_snapshot;
131:
132: procedure log_changes(p_loan_id NUMBER) AS