[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select period_name, closing_status,
period_type, period_year, period_num
from gl_period_statuses
where application_id = app_id
and set_of_books_id = sob_id
and
(
start_date between to_date(pstart_date, 'YYYYMMDD') and
to_date(pend_date, 'YYYYMMDD')
OR
end_date between to_date(pstart_date, 'YYYYMMDD') and
to_date(pend_date, 'YYYYMMDD')
OR
to_date(pstart_date, 'YYYYMMDD') between start_date and end_date
OR
to_date(pend_date, 'YYYYMMDD') between start_date and end_date
)
and adjustment_period_flag = 'N'
order by period_year, period_num;
select meaning from ar_lookups where lookup_type = t
and lookup_code = c;
| last_update_login |
| |
| EXCEPTIONS RAISED |
| |
| KNOWN BUGS |
| |
| NOTES |
| |
| HISTORY |
| 2/11/93 Nigel Smith Created |
| |
*----------------------------------------------------------------------------*/
PROCEDURE set_who_information( user_id in number,
request_id in number,
program_application_id in number,
program_id in number,
last_update_login in number ) IS
BEGIN
debug( '>> SET_WHO_INFORMATION( ' ||
to_char(user_id) || ', ' ||
to_char( request_id ) || ', ' ||
to_char(program_application_id ) || ', ' ||
to_char( program_id ) || ', ' ||
to_char( last_update_login ) || ' )' );
profile.last_update_login := fnd_global.conc_login_id;
| 03/23/93 Nigel Smith Select from fnd_messages now uses application_id|
| and language id from session profiles |
| 03/10/00 Tara Welby Add substrb |
| |
*----------------------------------------------------------------------------*/
function fnd_message( md_options in number, msg_name in varchar2 ) return varchar2 is
/*----------------------------------------------------------------------------*
| PRIVATE CURSOR |
| fnd_message_c |
| |
| DESCRIPTION |
| Gets the message_number and message_text from fnd_messages |
| |
*----------------------------------------------------------------------------*/
/* bug2995947 : Replaced profile.language_code with userenv('LANG')
in order to get proper language message text */
cursor fnd_message_c( app_id in number, msg_name in varchar2 ) IS
select message_number, message_text
from fnd_new_messages
where application_id = app_id
and language_code = userenv('LANG')
and message_name = msg_name;
select period_name,
start_date,
end_date,
closing_status,
period_type,
period_year,
period_num,
quarter_num
from gl_period_statuses ps
--begin anuj
/* Multi-Org Access Control Changes for SSA;Begin;anukumar;09/11/2002*/
select period_name,
start_date,
end_date,
closing_status,
period_type,
period_year,
period_num,
quarter_num
from gl_period_statuses ps,
ar_system_parameters p
where ps.set_of_books_id = p.set_of_books_id
and application_id = 222
and adjustment_period_flag = 'N'
and trunc(gl_date) between start_date and end_date
order by period_num
;
select decode(max(period_name),
'', 0,
1)
into pg_period(to_char(l_gl_date,'j'))
from gl_period_statuses
where application_id = p_application_id
and set_of_books_id = p_set_of_books_id
and adjustment_period_flag = 'N'
and l_gl_date between start_date and end_date
and closing_status in ('O', 'F', 'N') ;
select decode(max(period_name),
'', 0,
1)
into pg_period_open(to_char(l_gl_date,'j'))
from gl_period_statuses
where application_id = p_application_id
and set_of_books_id = p_set_of_books_id
and adjustment_period_flag = 'N'
and l_gl_date between start_date and end_date
and closing_status in ('O', 'F');
select decode(max(period_name),
'', 0,
1)
into num_return_value
from gl_period_statuses
where application_id = p_application_id
and set_of_books_id = p_set_of_books_id
and adjustment_period_flag = 'N'
and l_gl_date between start_date and end_date
and closing_status in ('O', 'F', 'N');
select decode(max(period_name),
'', 0,
1)
into num_return_value
from gl_period_statuses
where application_id = p_application_id
and set_of_books_id = p_set_of_books_id
and adjustment_period_flag = 'N'
and l_gl_date between start_date and end_date
and closing_status in ('O', 'F');
SELECT min(start_date)
INTO candidate_gl_date
FROM gl_period_statuses
WHERE application_id = h_application_id
AND set_of_books_id = h_set_of_books_id
AND adjustment_period_flag = 'N'
AND closing_status IN ('O','F','N')
AND start_date >= l_gl_date;
select max(d.end_date)
into candidate_gl_date
from gl_period_statuses d,
gl_period_statuses s
where d.application_id = s.application_id
and d.set_of_books_id = s.set_of_books_id
and d.adjustment_period_flag = 'N'
and d.end_date < sysdate
and d.closing_status = 'O'
and s.application_id = h_application_id
and s.set_of_books_id = h_set_of_books_id
and s.adjustment_period_flag = 'N'
and s.closing_status = 'F'
and sysdate between s.start_date and s.end_date;
select max(end_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'O'
and start_date < l_trx_date;
select min(start_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'O'
and start_date >= l_trx_date;
select min(start_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'F'
and start_date >= l_trx_date;
select max(end_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'O'
and start_date < sysdate;
select min(start_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'O'
and start_date >= sysdate;
select max(start_date), max(end_date)
into candidate_start_gl_date,
candidate_end_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'O';
select min(start_date)
into candidate_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'F'
and start_date >= sysdate;
select max(start_date), max(end_date)
into candidate_start_gl_date,
candidate_end_gl_date
from gl_period_statuses
where application_id = h_application_id
and set_of_books_id = h_set_of_books_id
and adjustment_period_flag = 'N'
and closing_status = 'F';
SELECT tax.customer_trx_line_id,
tax.customer_trx_id
FROM ra_customer_trx_lines tax,
ra_customer_trx_lines line,
ar_vat_tax v1,
ar_vat_tax v2
WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
AND line.customer_trx_line_id = p_customer_trx_line_id
AND tax.line_number = p_tax_line_number
AND tax.vat_tax_id = v1.vat_tax_id
AND v1.tax_code = v2.tax_code
AND v2.vat_tax_id = p_vat_tax_id;
SELECT tax.customer_trx_line_id,
tax.customer_trx_id
FROM ra_customer_trx_lines tax,
ra_customer_trx_lines line,
ar_vat_tax v1,
ar_vat_tax v2
WHERE tax.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
AND line.customer_trx_line_id = p_customer_trx_line_id
AND tax.vat_tax_id = v1.vat_tax_id
AND v1.tax_code = v2.tax_code
AND v2.vat_tax_id = p_vat_tax_id
AND not exists ( select 'x' from ra_customer_trx_lines v, ar_vat_tax v3
where v.link_to_cust_trx_line_id = line.previous_customer_trx_line_id
and v.vat_tax_id = v3.vat_tax_id
and v3.tax_code = v1.tax_code
and v.customer_trx_line_id <> tax.customer_trx_line_id );
SELECT 'x' from ra_customer_trx_lines line, ra_customer_trx hdr, ra_cust_trx_types type
where line.customer_trx_id = hdr.customer_trx_id
and line.customer_trx_line_id = p_customer_trx_line_id
and hdr.previous_customer_trx_id is not null
and hdr.cust_trx_type_id = type.cust_trx_type_id
and type.type = 'CM';
select min(org_id) into l_default_org_id from ar_system_parameters;
ARP_STANDARD.sysparm.last_updated_by := l_gr.last_updated_by;
ARP_STANDARD.sysparm.last_update_date := l_gr.last_update_date;
ARP_STANDARD.sysparm.last_update_login := l_gr.last_update_login;