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

Line 87: source_cursor := dbms_sql.open_cursor;

83: l_return integer;
84: --
85: begin
86: if p_ota_event_id is not null then
87: source_cursor := dbms_sql.open_cursor;
88: dbms_sql.parse(source_cursor,
89: 'select title,course_start_date
90: from ota_events
91: where event_id = '||to_char(p_ota_event_id),

Line 88: dbms_sql.parse(source_cursor,

84: --
85: begin
86: if p_ota_event_id is not null then
87: source_cursor := dbms_sql.open_cursor;
88: dbms_sql.parse(source_cursor,
89: 'select title,course_start_date
90: from ota_events
91: where event_id = '||to_char(p_ota_event_id),
92: dbms_sql.v7);

Line 92: dbms_sql.v7);

88: dbms_sql.parse(source_cursor,
89: 'select title,course_start_date
90: from ota_events
91: where event_id = '||to_char(p_ota_event_id),
92: dbms_sql.v7);
93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then

Line 93: dbms_sql.define_column(source_cursor,1,l_event_title,80);

89: 'select title,course_start_date
90: from ota_events
91: where event_id = '||to_char(p_ota_event_id),
92: dbms_sql.v7);
93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);

Line 94: dbms_sql.define_column(source_cursor,2,l_course_start_date);

90: from ota_events
91: where event_id = '||to_char(p_ota_event_id),
92: dbms_sql.v7);
93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);
98: dbms_sql.column_value(source_cursor,2,l_course_start_date);

Line 95: l_return := dbms_sql.execute(source_cursor);

91: where event_id = '||to_char(p_ota_event_id),
92: dbms_sql.v7);
93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);
98: dbms_sql.column_value(source_cursor,2,l_course_start_date);
99: end if;

Line 96: if dbms_sql.fetch_rows(source_cursor) >0 then

92: dbms_sql.v7);
93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);
98: dbms_sql.column_value(source_cursor,2,l_course_start_date);
99: end if;
100: --

Line 97: dbms_sql.column_value(source_cursor,1,l_event_title);

93: dbms_sql.define_column(source_cursor,1,l_event_title,80);
94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);
98: dbms_sql.column_value(source_cursor,2,l_course_start_date);
99: end if;
100: --
101: p_event_title := l_event_title;

Line 98: dbms_sql.column_value(source_cursor,2,l_course_start_date);

94: dbms_sql.define_column(source_cursor,2,l_course_start_date);
95: l_return := dbms_sql.execute(source_cursor);
96: if dbms_sql.fetch_rows(source_cursor) >0 then
97: dbms_sql.column_value(source_cursor,1,l_event_title);
98: dbms_sql.column_value(source_cursor,2,l_course_start_date);
99: end if;
100: --
101: p_event_title := l_event_title;
102: p_course_start_date := l_course_start_date;

Line 104: dbms_sql.close_cursor(source_cursor);

100: --
101: p_event_title := l_event_title;
102: p_course_start_date := l_course_start_date;
103: --
104: dbms_sql.close_cursor(source_cursor);
105: end if;
106: --
107: if p_ota_booking_id is not null then
108: source_cursor := dbms_sql.open_cursor;

Line 108: source_cursor := dbms_sql.open_cursor;

104: dbms_sql.close_cursor(source_cursor);
105: end if;
106: --
107: if p_ota_booking_id is not null then
108: source_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(source_cursor,
110: 'select event_title
111: , course_start_date
112: , delegate_full_name

Line 109: dbms_sql.parse(source_cursor,

105: end if;
106: --
107: if p_ota_booking_id is not null then
108: source_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(source_cursor,
110: 'select event_title
111: , course_start_date
112: , delegate_full_name
113: from ota_delegate_bookings_v

Line 115: dbms_sql.v7);

111: , course_start_date
112: , delegate_full_name
113: from ota_delegate_bookings_v
114: where booking_id = '||to_char(p_ota_booking_id),
115: dbms_sql.v7);
116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);

Line 116: dbms_sql.define_column(source_cursor,1,l_event_title,80);

112: , delegate_full_name
113: from ota_delegate_bookings_v
114: where booking_id = '||to_char(p_ota_booking_id),
115: dbms_sql.v7);
116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then

Line 117: dbms_sql.define_column(source_cursor,2,l_course_start_date);

113: from ota_delegate_bookings_v
114: where booking_id = '||to_char(p_ota_booking_id),
115: dbms_sql.v7);
116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);

Line 118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);

114: where booking_id = '||to_char(p_ota_booking_id),
115: dbms_sql.v7);
116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);

Line 119: l_return := dbms_sql.execute(source_cursor);

115: dbms_sql.v7);
116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);
123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);

Line 120: if dbms_sql.fetch_rows(source_cursor) >0 then

116: dbms_sql.define_column(source_cursor,1,l_event_title,80);
117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);
123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);
124: end if;

Line 121: dbms_sql.column_value(source_cursor,1,l_event_title);

117: dbms_sql.define_column(source_cursor,2,l_course_start_date);
118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);
123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);
124: end if;
125: --

Line 122: dbms_sql.column_value(source_cursor,2,l_course_start_date);

118: dbms_sql.define_column(source_cursor,3,l_delegate_full_name,240);
119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);
123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);
124: end if;
125: --
126: p_event_title := l_event_title;

Line 123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);

119: l_return := dbms_sql.execute(source_cursor);
120: if dbms_sql.fetch_rows(source_cursor) >0 then
121: dbms_sql.column_value(source_cursor,1,l_event_title);
122: dbms_sql.column_value(source_cursor,2,l_course_start_date);
123: dbms_sql.column_value(source_cursor,3,l_delegate_full_name);
124: end if;
125: --
126: p_event_title := l_event_title;
127: p_course_start_date := l_course_start_date;

Line 130: dbms_sql.close_cursor(source_cursor);

126: p_event_title := l_event_title;
127: p_course_start_date := l_course_start_date;
128: p_delegate_full_name := l_delegate_full_name;
129: --
130: dbms_sql.close_cursor(source_cursor);
131: end if;
132: end;
133: --
134: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,