[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT into gms_award_distributions
( award_set_id ,
adl_line_num,
funding_pattern_id,
distribution_value ,
raw_cost,
document_type,
project_id ,
task_id ,
award_id ,
expenditure_item_id ,
cdl_line_num ,
ind_compiled_set_id ,
gl_date ,
request_id ,
line_num_reversed ,
resource_list_member_id ,
output_tax_classification_code ,
output_tax_exempt_flag ,
output_tax_exempt_reason_code ,
output_tax_exempt_number ,
adl_status ,
fc_status ,
line_type ,
capitalized_flag ,
capitalizable_flag ,
reversed_flag ,
revenue_distributed_flag ,
billed_flag ,
bill_hold_flag ,
distribution_id ,
po_distribution_id ,
invoice_distribution_id ,
parent_award_set_id ,
invoice_id ,
parent_adl_line_num ,
distribution_line_number ,
burdenable_raw_cost ,
cost_distributed_flag ,
last_update_date ,
last_updated_by ,
created_by ,
creation_date ,
last_update_login ,
billable_flag
)
SELECT gms_awards_dist_pkg.get_award_set_id ,
1, --adl_line_num,
funding_pattern_id,
distribution_value ,
raw_cost,
'PO' , --document_type,
project_id ,
task_id ,
award_id ,
NULL, --expenditure_item_id ,
cdl_line_num ,
NULL, --ind_compiled_set_id ,
gl_date ,
p_interface_obj.distribution_num(i), --request_id ,
line_num_reversed ,
NULL, --resource_list_member_id ,
output_tax_classification_code ,
output_tax_exempt_flag ,
output_tax_exempt_reason_code ,
output_tax_exempt_number ,
'A', --adl_status ,
'N', --fc_status ,
line_type ,
capitalized_flag ,
capitalizable_flag ,
reversed_flag ,
revenue_distributed_flag ,
billed_flag ,
bill_hold_flag ,
NULL, --distribution_id ,
p_interface_obj.distribution_id(i), --po_distribution_id ,
NULL, --invoice_distribution_id ,
parent_award_set_id ,
NULL, --invoice_id ,
parent_adl_line_num ,
NULL, --distribution_line_number ,
NULL, --burdenable_raw_cost ,
cost_distributed_flag ,
SYSDATE, --last_update_date ,
fnd_global.user_id , --last_updated_by ,
fnd_global.user_id , --created_by ,
SYSDATE, --creation_date ,
last_update_login ,
billable_flag
from gms_award_distributions
where award_set_id = p_interface_obj.award_set_id_in(i)
and adl_line_num = 1 ;
select award_set_id
into l_dummy
from gms_award_distributions
where po_distribution_id = p_interface_obj.distribution_id(i)
and document_type = 'PO'
and adl_status = 'A'
and fc_status = 'N' ;
select *
from gms_award_distributions
where award_set_id = p_award_set_id
and adl_line_num = 1 ;
l_adls_rec.last_update_date := SYSDATE ;
l_adls_rec.last_updated_by := fnd_global.user_id ;
update po_distributions_all
set award_id = l_adls_rec.award_set_id
where po_distribution_id = p_distribution_id ;
--po_distributions_grp.update_award_id_po( p_api_version => p_api_version,
-- p_commit => p_commit,
-- p_init_msg_list => p_init_msg_list,
-- p_validation_level => p_validation_level,
-- x_msg_count => l_msg_count,
-- x_msg_data => l_msg_data,
-- x_return_status => l_return_status,
-- p_award_set_id => l_adls_rec.award_set_id,
-- p_distribution_id => p_distribution_id ) ;
select awd.award_number
from gms_awards_all awd,
gms_award_distributions adl
where adl.award_id = awd.award_id
and adl.award_set_id = p_award_set_id
and adl.adl_line_num = 1 ;
select award_id
into l_award_id
from gms_awards_all
where award_number = p_award_number ;
select gpt.sponsored_flag , pt.project_type_class_code
from pa_projects_all p,
gms_project_types gpt ,
pa_project_types pt
where p.project_id = NVL(p_project_id,0)
and p.project_type = gpt.project_type
and p.project_type = pt.project_type ;
l_adl_rec.last_update_date := SYSDATE;
l_adl_rec.last_updated_by := fnd_global.user_id;
l_adl_rec.last_update_login := 0;
select awd.award_number
into l_award_number
from gms_awards_all awd,
gms_award_distributions adl
where adl.award_set_id = p_award_set_id
and adl.award_id = awd.award_id
and adl.adl_line_num = 1 ;
select award_id
into l_award_id
from gms_awards_all
where award_number = p_award_number ;
l_adl_rec.last_update_date := sysdate ;
l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
l_adl_rec.last_update_login := 0;
l_update_flag varchar2(1) ;
l_api_name varchar2(50) := 'UPDATE_PO_ADL' ;
select award_set_id,
adl_line_num,
funding_pattern_id,
distribution_value,
document_type,
project_id,
task_id,
award_id,
ind_compiled_set_id,
gl_date,
request_id,
line_num_reversed,
resource_list_member_id,
output_tax_classification_code,
output_tax_exempt_flag,
output_tax_exempt_reason_code,
output_tax_exempt_number,
adl_status,
fc_status,
line_type,
capitalized_flag,
capitalizable_flag,
reversed_flag,
revenue_distributed_flag,
billed_flag,
bill_hold_flag,
distribution_id,
po_distribution_id,
invoice_distribution_id,
invoice_id,
distribution_line_number,
burdenable_raw_cost,
cost_distributed_flag,
last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login,
billable_flag
from gms_award_distributions
where award_set_id = p_award_set_id_in
and document_type = 'PO'
and po_distribution_id = p_po_distribution_id
and adl_line_num = 1 ;
l_update_flag := 'Y' ;
l_adl_rec.last_update_date,
l_adl_rec.last_updated_by,
l_adl_rec.created_by,
l_adl_rec.creation_date,
l_adl_rec.last_update_login,
l_adl_rec.billable_flag ;
l_update_flag := 'N' ;
If p_award_number is NULL and l_update_flag = 'Y' THEN
DELETE_PO_ADL
( p_api_version => p_api_version,
p_commit => p_commit,
p_init_msg_list => p_init_msg_list,
p_validation_level=> p_validation_level,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_award_set_id_in => p_award_set_id_in,
p_po_distribution_id => p_po_distribution_id ) ;
ELSIF p_award_number is not NULL and l_update_flag = 'Y' THEN
l_adl_rec.project_id := p_project_id ;
select award_id
into l_award_id
from gms_awards_all
where award_number = p_award_number ;
l_adl_rec.last_update_date := sysdate ;
l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
gms_awards_dist_pkg.update_adls(l_adl_rec) ;
PROCEDURE DELETE_PO_ADL
( p_api_version in number,
p_commit in varchar2,
p_init_msg_list in varchar2,
p_validation_level in number,
x_msg_count out nocopy number,
x_msg_data out nocopy varchar2,
x_return_status out nocopy varchar2,
p_award_set_id_in in number,
p_po_distribution_id in number ) IS
l_msg_count number ;
l_api_name varchar2(50) := 'DELETE_PO_ADL' ;
delete from gms_award_distributions
where award_set_id = p_award_set_id_in
and document_type = 'PO'
and adl_line_num = 1
and po_distribution_id is NULL ;
delete from gms_award_distributions
where award_set_id = p_award_set_id_in
and document_type = 'PO'
and adl_line_num = 1
and po_distribution_id = p_po_distribution_id ;
END DELETE_PO_ADL ;
select pt.sponsored_flag
from pa_projects_all b,
gms_project_types pt
where b.project_id = p_project_id
and b.project_type = pt.project_type
and pt.sponsored_flag = 'Y' ;