[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_vat_tax_id ,
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_vat_tax_id ,
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' ;
delete from gms_award_distributions adl
where ( award_set_id , po_distribution_id) in
( select pod.award_id, po_distribution_id
from po_distributions_all pod
where pod.po_header_id = p_in_rec.entity_ids(i)
and pod.award_id is not NULL )
and document_type = 'PO' ;
select awd.award_number
into l_award_number
from gms_awards_all awd, gms_award_distributions adl
where adl.award_set_id = l_award_set_id
and adl.award_id = awd.award_id ;