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:
19: l_select_val_stmt := 'select';

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

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:
19: l_select_val_stmt := 'select';
20:
21: DBMS_SQL.PARSE(l_cursorID, l_select_col_stmt, DBMS_SQL.V7);
22: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':tab_name', p_table_name);
23:
24: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 1, l_column_name, 30);
25: DBMS_SQL.DEFINE_COLUMN(l_cursorID, 2, l_data_type, 106);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 77: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

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

Line 84: l_cursorID := DBMS_SQL.OPEN_CURSOR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 112: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

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

Line 127: dbms_sql.close_cursor(l_cursorID);

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