The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gms_adls_award_set_id_s.NEXTVAL
INTO x_award_set_id
FROM dual ;
SELECT line_num_reversed,
REVERSED_FLAG,
IND_COMPILED_SET_ID,
BILLABLE_FLAG,
AMOUNT
FROM PA_COST_DISTRIBUTION_LINES_ALL
WHERE LINE_NUM = p_dist_line_num
and expenditure_item_id = p_dist_id ;
update gms_award_distributions
set reversed_flag = 'Y'
where award_set_id = p_award_set_id
and document_type = 'EXP'
and adl_status = 'A'
and cdl_line_num = nvl(x_line_num_reversed, -9 )
and expenditure_item_id = p_dist_id ;
SELECT max(adl_line_num ) + 1
INTO x_adl_line_num
FROM gms_award_distributions
where award_set_id = p_award_set_id ;
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_type ,
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 ,--ETax Change:Replace the tax_id with classificationcode
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
x_new_award_set_id ,
decode(p_doc_type, 'EXP', x_adl_line_num, adl_line_num ) , -- ADL_LINE_NUM
funding_pattern_id,
distribution_value ,
decode(p_doc_type, 'EXP', x_amount, p_raw_cost ) ,-- p_raw_cost
p_doc_type,
project_id ,
task_id ,
award_id ,
--expenditure_type ,
decode(p_doc_type, 'EXP', p_dist_id, expenditure_item_id ),-- expenditure_item_id
decode(p_doc_type, 'EXP', p_dist_line_num, CDL_line_num ) ,-- cdl_line_num
decode(p_doc_type, 'EXP', x_ind_compiled_set_id, ind_compiled_set_id ) ,-- ind_compiled_set_id
gl_date ,
request_id ,
decode(p_doc_type, 'EXP', x_line_num_reversed, line_num_reversed ) ,-- line_num_reversed
resource_list_member_id ,
--output_vat_tax_id , --ETax Changes
output_tax_classification_code,
output_tax_exempt_flag ,
output_tax_exempt_reason_code ,
output_tax_exempt_number ,
adl_status ,
'N' , -- FC_STATUS
line_type ,
NVL(capitalized_flag,'N') ,
capitalizable_flag ,
decode(p_doc_type, 'EXP', x_reversed_flag, reversed_flag ) ,-- reversed_flag
'N' , --revenue_distributed_flag ,
'N' , --billed_flag
NULL , --bill_hold_flag
decode(p_doc_type, 'REQ', p_dist_id, NULL), -- distribution_id ,
decode(p_doc_type, 'PO', p_dist_id, NULL), -- po_distribution_id ,
decode(p_doc_type, 'AP', p_dist_id, NULL), -- invoice_distribution_id ,
parent_award_set_id ,
P_invoice_id ,
parent_adl_line_num ,
decode(p_doc_type, 'AP',p_dist_line_num,NULL) ,
null , -- burdenable_raw_cost
'N' , -- cost_distributed_flag ,
sysdate , -- last_update_date
nvl(fnd_global.user_id,0) , -- last_updated_by ,
nvl(fnd_global.user_id,0) , -- created_by ,
sysdate , -- creation_date ,
last_update_login ,
nvl( x_billable_flag, NVL(billable_flag,'Y') )
from GMS_AWARD_DISTRIBUTIONS
where AWARD_SET_ID = P_AWARD_SET_ID
AND ADL_STATUS = 'A'
AND rownum < 2 ;
update po_distributions_all
set award_id = x_new_award_set_id
where po_distribution_id = p_dist_id
and award_id = p_award_set_id
and exists ( select 'X'
from gms_award_distributions
where award_set_id = x_new_award_set_id
) ;
UPDATE ap_invoice_distributions_all
set award_id = x_new_award_set_id
WHERE invoice_id = p_invoice_id
and invoice_distribution_id = p_dist_id
and exists ( select 'X'
from gms_award_distributions
where award_set_id = x_new_award_set_id
) ;
/* Bug 5344693 : The following update is added to stamp the distribution_line_number correctly
on gms_award_distributions. */
UPDATE gms_award_distributions
set distribution_line_number = (select distribution_line_number
from ap_invoice_distributions_all
where invoice_id = p_invoice_id
and invoice_distribution_id = p_dist_id
and award_id = x_new_award_set_id )
where award_set_id = x_new_award_set_id
and invoice_id = p_invoice_id
and invoice_distribution_id = p_dist_id;
update po_req_distributions
set award_id = x_new_award_set_id
where distribution_id = p_dist_id
and award_id = p_award_set_id
and exists ( select 'X'
from gms_award_distributions
where award_set_id = x_new_award_set_id
) ;
IF x_adls_rec.last_update_date is NULL then
x_adls_rec.last_update_date := sysdate ;
IF x_adls_rec.last_updated_by is NULL THEN
x_adls_rec.last_updated_by := nvl(fnd_global.user_id,0) ;
IF x_adls_rec.last_update_login is NULL THEN
x_adls_rec.last_update_login := 0 ;
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_type ,
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 ,--ETax Changes Replacing the tax id changes with tax_classification code
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 )
Values ( x_adls_rec.award_set_id ,
x_adls_rec.adl_line_num,
x_adls_rec.funding_pattern_id,
x_adls_rec.distribution_value ,
x_adls_rec.raw_cost,
x_adls_rec.document_type,
x_adls_rec.project_id ,
x_adls_rec.task_id ,
x_adls_rec.award_id ,
--x_adls_rec.expenditure_type ,
x_adls_rec.expenditure_item_id ,
x_adls_rec.cdl_line_num ,
x_adls_rec.ind_compiled_set_id ,
x_adls_rec.gl_date ,
x_adls_rec.request_id ,
x_adls_rec.line_num_reversed ,
x_adls_rec.resource_list_member_id ,
--x_adls_rec.output_vat_tax_id , --Etax Changes
x_adls_rec.output_tax_classification_code,
x_adls_rec.output_tax_exempt_flag ,
x_adls_rec.output_tax_exempt_reason_code ,
x_adls_rec.output_tax_exempt_number ,
x_adls_rec.adl_status ,
nvl(x_adls_rec.fc_status,'N') ,
x_adls_rec.line_type ,
NVL(x_adls_rec.capitalized_flag,'N') ,
x_adls_rec.capitalizable_flag ,
x_adls_rec.reversed_flag ,
NVL(x_adls_rec.revenue_distributed_flag,'N') ,
NVL(x_adls_rec.billed_flag,'N') ,
x_adls_rec.bill_hold_flag ,
x_adls_rec.distribution_id ,
x_adls_rec.po_distribution_id ,
x_adls_rec.invoice_distribution_id ,
x_adls_rec.parent_award_set_id ,
x_adls_rec.invoice_id ,
x_adls_rec.parent_adl_line_num ,
x_adls_rec.distribution_line_number ,
x_adls_rec.burdenable_raw_cost ,
NVL(x_adls_rec.cost_distributed_flag,'N') ,
x_adls_rec.last_update_date ,
x_adls_rec.last_updated_by ,
x_adls_rec.created_by ,
x_adls_rec.creation_date ,
x_adls_rec.last_update_login ,
NVL(x_adls_rec.billable_flag, 'Y') ) ;
PROCEDURE update_adls( p_adls_rec gms_award_distributions%ROWTYPE ) IS
x_adls_rec gms_award_distributions%ROWTYPE ;
IF x_adls_rec.last_update_date is NULL then
x_adls_rec.last_update_date := sysdate ;
IF x_adls_rec.last_updated_by is NULL THEN
x_adls_rec.last_updated_by := fnd_global.user_id ;
UPDATE gms_award_distributions
SET funding_pattern_id = x_adls_rec.funding_pattern_id,
distribution_value = x_adls_rec.distribution_value,
document_type = x_adls_rec.document_type,
project_id = x_adls_rec.project_id,
task_id = x_adls_rec.task_id,
award_id = x_adls_rec.award_id ,
--expenditure_type = x_adls_rec.expenditure_type ,
expenditure_item_id = x_adls_rec.expenditure_item_id ,
cdl_line_num = x_adls_rec.cdl_line_num ,
ind_compiled_set_id = x_adls_rec.ind_compiled_set_id ,
gl_date = x_adls_rec.gl_date ,
request_id = x_adls_rec.request_id ,
line_num_reversed = x_adls_rec.line_num_reversed ,
resource_list_member_id = x_adls_rec.resource_list_member_id ,
--output_vat_tax_id = x_adls_rec.output_vat_tax_id ,
output_tax_classification_code = x_adls_rec.output_tax_classification_code,
output_tax_exempt_flag = x_adls_rec.output_tax_exempt_flag ,
output_tax_exempt_reason_code = x_adls_rec.output_tax_exempt_reason_code,
output_tax_exempt_number = x_adls_rec.output_tax_exempt_number ,
adl_status = x_adls_rec.adl_status ,
fc_status = x_adls_rec.fc_status ,
line_type = x_adls_rec.line_type ,
capitalized_flag = x_adls_rec.capitalized_flag ,
capitalizable_flag = x_adls_rec.capitalizable_flag ,
reversed_flag = x_adls_rec.reversed_flag,
revenue_distributed_flag = x_adls_rec.revenue_distributed_flag,
billed_flag = x_adls_rec.billed_flag,
bill_hold_flag = x_adls_rec.bill_hold_flag,
distribution_id = x_adls_rec.distribution_id,
po_distribution_id = x_adls_rec.po_distribution_id,
invoice_distribution_id = x_adls_rec.invoice_distribution_id,
parent_award_set_id = x_adls_rec.parent_award_set_id,
invoice_id = x_adls_rec.invoice_id,
parent_adl_line_num = x_adls_rec.parent_adl_line_num,
distribution_line_number = x_adls_rec.distribution_line_number,
burdenable_raw_cost = x_adls_rec.burdenable_raw_cost,
cost_distributed_flag = x_adls_rec.cost_distributed_flag,
last_update_date = x_adls_rec.last_update_date,
last_updated_by = x_adls_rec.last_updated_by,
created_by = x_adls_rec.created_by,
creation_date = x_adls_rec.creation_date,
last_update_login = x_adls_rec.last_update_login,
billable_flag = X_adls_rec.billable_flag
WHERE award_set_id = x_adls_rec.award_set_id and
adl_line_num = x_adls_rec.adl_line_num ;
x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :UPDATE ADLS',
x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
x_err_code => p_err_code, x_err_buff => p_err_buf
) ;
END update_adls ;
PROCEDURE delete_adls( p_distribution_set_id NUMBER ) is
p_err_code NUMBER ;
x_token_name1 => 'PROGRAM_NAME', x_token_val1 => 'GMS_AWARDS_DIST_PKG :DELETE ADLS',
x_token_name2 => 'OERRNO', x_token_val2 => SQLCODE,
x_token_name3 => 'OERRM', x_token_val3 => SQLERRM ,
x_err_code => p_err_code, x_err_buff => p_err_buf
) ;
END delete_adls ;
PROCEDURE delete_adls( p_doc_header_id IN NUMBER,
p_doc_distribution_id IN NUMBER,
p_doc_type IN VARCHAR2 ) is
BEGIN
IF p_doc_header_id is NULL and
p_doc_distribution_id is NULL THEN
return ;
-- Delete award distribution line for a given expenditure item.
-- =====
delete from gms_award_distributions adls
where document_type = 'EXP'
and expenditure_item_id in ( select expenditure_item_id
from pa_expenditure_items_all ei
where expenditure_item_id = p_doc_distribution_id ) ;
-- Delete award distribution line for a given expenditure.
-- =====
delete from gms_award_distributions adls
where document_type = 'EXP'
and expenditure_item_id in ( select expenditure_item_id
from pa_expenditure_items_all ei
where expenditure_id = p_doc_header_id ) ;
-- Delete award distribution line for a given encumbrance item.
-- =====
delete from gms_award_distributions adls
where document_type = 'ENC'
and expenditure_item_id in ( select encumbrance_item_id
from gms_encumbrance_items_all ei
where encumbrance_item_id = p_doc_distribution_id ) ;
-- Delete award distribution line for a given encumbrance.
-- =====
delete from gms_award_distributions adls
where document_type = 'ENC'
and expenditure_item_id in ( select encumbrance_item_id
from gms_encumbrance_items_all ei
where encumbrance_id = p_doc_header_id ) ;
END delete_adls ;
PROCEDURE update_billable_flag (p_expenditure_item_id in number)
IS
BEGIN
-- Commenting below code, Bug 1756179
/* Update pa_expenditure_items_all
set billable_flag = 'Y'
where expenditure_item_id = p_expenditure_item_id
and nvl(billable_flag ,'N') = 'N'; */
END update_billable_flag ;
SELECT ins.award_id
FROM gms_installments ins,
gms_summary_project_fundings pf
WHERE ins.installment_id = pf.installment_id
AND pf.project_id = p_project_id
AND ins.award_id = p_award_id ;
SELECT ins.award_id
FROM gms_installments ins,
gms_summary_project_fundings pf
WHERE ins.installment_id = pf.installment_id
AND pf.project_id = p_project_id
AND NOT EXISTS ( SELECT 1
FROM gms_installments ins2,
gms_summary_project_fundings pf2
WHERE ins2.installment_id = pf2.installment_id
AND pf2.project_id = pf.project_id
AND ins2.award_id <> ins.award_id ) ;
l_last_update_date gms_po_req_type_date;
l_last_updated_by gms_po_req_type_number;
l_last_update_login gms_po_req_type_number;
SELECT *
FROM gms_award_distributions
WHERE award_set_id = l_award_set_idX
AND adl_line_num = 1 ;
SELECT rl.requisition_header_id header_id,
rd.distribution_num distribution_num,
rd.distribution_id distribution_id,
rd.project_id project_id,
rd.task_id task_id,
rd.award_id award_set_id,
rd.last_update_date last_update_date,
rd.creation_date creation_date,
rd.last_updated_by last_updated_by,
rd.created_by created_by,
nvl(rd.last_update_login,0) last_update_login
FROM po_req_distributions_all rd,
po_requisition_lines_all rl,
pa_projects_all pp,
gms_project_types gpt
WHERE rl.requisition_header_id = p_header_id
AND rd.requisition_line_id = rl.requisition_line_id
AND rd.project_id = pp.project_id
AND pp.project_type = gpt.project_type
AND gpt.sponsored_flag = 'Y'
--
-- BUG : 3603758
-- Award Distribution is failing in PO and Req.
-- We need to skip records associated with the dummy award fo adls
-- creation.
AND NVL(rd.award_id,0) >= 0 ;
l_dummy_tab.DELETE ;
SELECT adl2.award_set_id
bulk collect into l_dummy_tab
FROM po_req_distributions_all rd,
po_requisition_lines_all rl,
gms_award_distributions adl2
WHERE rl.requisition_header_id = p_header_id
AND rd.requisition_line_id = rl.requisition_line_id
AND adl2.distribution_id = rd.distribution_id
AND adl2.document_type = 'REQ'
AND adl2.award_set_id = rd.award_id
AND adl2.adl_status = 'I' ;
UPDATE gms_award_distributions
set adl_status = 'A'
where award_set_id = l_dummy_tab(i) ;
l_dummy_tab.DELETE ;
SELECT adl2.award_set_id
bulk collect into l_dummy_tab
FROM po_req_distributions_all rd,
po_requisition_lines_all rl,
gms_award_distributions adl2
WHERE rl.requisition_header_id = p_header_id
AND rd.requisition_line_id = rl.requisition_line_id
AND adl2.distribution_id = rd.distribution_id
AND adl2.document_type = 'REQ'
AND adl2.award_set_id <> rd.award_id
AND adl2.adl_status = 'A' ;
UPDATE gms_award_distributions
set adl_status = 'I'
where award_set_id = l_dummy_tab(i) ;
l_dummy_tab.DELETE ;
SELECT rd2.distribution_id
bulk collect into l_dummy_tab
FROM po_req_distributions_all rd2,
po_requisition_lines_all rl,
pa_projects_all pp,
gms_project_types gpt
WHERE rl.requisition_header_id = p_header_id
AND rd2.requisition_line_id = rl.requisition_line_id
AND rd2.project_id = pp.project_id
and rd2.award_id is NOT NULL
AND pp.project_type = gpt.project_type
AND gpt.sponsored_flag = 'N' ;
UPDATE po_req_distributions_all rd
SET award_id = NULL
WHERE rd.distribution_id = l_dummy_tab(i) ;
l_dummy_tab.DELETE ;
l_last_update_date(l_count) := req_rec.last_update_date;
l_last_updated_by(l_count) := req_rec.last_updated_by;
l_last_update_login(l_count) := req_rec.last_update_login;
INSERT INTO gms_award_distributions ( award_set_id ,
adl_line_num ,
document_type ,
distribution_value ,
project_id ,
task_id ,
award_id ,
adl_status ,
fc_status ,
line_type ,
capitalized_flag ,
revenue_distributed_flag ,
billed_flag ,
distribution_id ,
burdenable_raw_cost ,
cost_distributed_flag ,
last_update_date ,
last_updated_by ,
created_by ,
creation_date ,
last_update_login ,
billable_flag )
VALUES ( l_new_award_set_id(i) ,
1, --adl_line_num ,
'REQ' , --document_type ,
100 ,
l_project_id(i) ,
l_task_id(i) ,
l_award_id(i) ,
'A', --adl_status ,
'N', --fc_status ,
'R', --line_type ,
'N' ,
'N' ,
'N' ,
l_distribution_id(i),
NULL, --burdenable_raw_cost ,
'N' ,
l_last_update_date(i) ,
l_last_updated_by(i) ,
l_created_by(i) ,
l_creation_date(i) ,
l_last_update_login(i) ,
'Y') ;
UPDATE po_req_distributions_all
SET award_id = l_new_award_set_id(k)
WHERE distribution_id = l_distribution_id(k);
SELECT pod.po_header_id header_id,
pod.distribution_num distribution_num,
pod.po_distribution_id distribution_id,
pod.project_id project_id,
pod.task_id task_id,
pod.award_id award_set_id,
pod.last_update_date last_update_date,
pod.creation_date creation_date,
pod.last_updated_by last_updated_by,
pod.created_by created_by,
nvl(pod.last_update_login,0) last_update_login
FROM po_distributions_all pod,
pa_projects_all p,
gms_project_types gpt
WHERE pod.po_header_id = p_header_id
AND pod.project_id = p.project_id
AND p.project_type = gpt.project_type
AND gpt.sponsored_flag = 'Y'
--
-- BUG : 3603758
-- Award Distribution is failing in PO and Req.
-- We need to skip records associated with the dummy award fo adls
-- creation.
AND NVL(pod.award_id,0) >= 0 ;
UPDATE gms_award_distributions adl
set adl.adl_status = 'A'
WHERE adl.document_type = 'PO'
AND adl.adl_status = 'I'
AND adl.award_set_id in ( SELECT adl2.award_set_id
FROM gms_award_distributions adl2,
po_distributions_all pod
WHERE pod.po_header_Id = p_header_id
AND pod.award_id is not null
AND adl2.award_set_id = pod.award_id
AND adl2.po_distribution_id =pod.po_distribution_id
AND adl2.document_type = 'PO'
AND adl2.adl_status = 'I' ) ;
UPDATE gms_award_distributions adl
set adl.adl_status = 'I'
WHERE adl.document_type = 'PO'
AND adl.adl_status = 'A'
AND adl.award_set_id in (SELECT adl2.award_set_id
FROM gms_award_distributions adl2,
po_distributions_all pod
WHERE pod.po_header_id = p_header_id
AND pod.award_id is not null
AND adl2.award_set_id <> pod.award_id
AND adl2.po_distribution_id =pod.po_distribution_id
AND adl2.document_type = 'PO'
AND adl2.adl_status = 'A' ) ;
UPDATE po_distributions_all pod
SET award_id = NULL
WHERE pod.po_header_id = p_header_id
AND pod.award_id is not NULL
AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id
FROM po_distributions_all pod2,
pa_projects_all p,
gms_project_types gpt
WHERE pod2.po_header_id = p_header_id
AND pod2.project_id = p.project_id
AND p.project_type = gpt.project_type
AND gpt.sponsored_flag = 'N' ) ;
l_last_update_date(l_count) := po_rec.last_update_date;
l_last_updated_by(l_count) := po_rec.last_updated_by;
l_last_update_login(l_count) := po_rec.last_update_login;
INSERT INTO gms_award_distributions ( award_set_id ,
adl_line_num,
document_type,
distribution_value,
project_id ,
task_id ,
award_id ,
adl_status ,
fc_status ,
line_type ,
capitalized_flag ,
revenue_distributed_flag ,
billed_flag ,
po_distribution_id ,
burdenable_raw_cost ,
cost_distributed_flag ,
last_update_date ,
last_updated_by ,
created_by ,
creation_date ,
last_update_login ,
billable_flag )
VALUES ( l_new_award_set_id(i) ,
1, --adl_line_num,
'PO' , --document_type,
100,
l_project_id(i) ,
l_task_id(i) ,
l_award_id(i) ,
'A', --adl_status ,
'N', --fc_status ,
'R', --line_type ,
'N' ,
'N' ,
'N' ,
l_distribution_id(i),
NULL, --burdenable_raw_cost ,
'N' ,
l_last_update_date(i) ,
l_last_updated_by(i) ,
l_created_by(i) ,
l_creation_date(i) ,
l_last_update_login(i) ,
'Y') ;
UPDATE po_distributions_all
SET award_id = l_new_award_set_id(k)
WHERE po_header_id = p_header_id
AND po_distribution_id = l_distribution_id(k) ;
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 , --ETax Changes
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 get_award_set_id ,
1,
funding_pattern_id,
distribution_value ,
raw_cost* -1 ,
'EXP',
project_id ,
task_id ,
award_id ,
p_backout_item_id,
cdl_line_num,
ind_compiled_set_id ,-- ind_compiled_set_id
NULL ,
request_id ,
NULL,
resource_list_member_id ,
--output_vat_tax_id ,--ETax Changes
output_tax_classification_code,
output_tax_exempt_flag ,
output_tax_exempt_reason_code ,
output_tax_exempt_number ,
adl_status ,
'N' , -- FC_STATUS
line_type ,
NVL(capitalized_flag,'N') ,
capitalizable_flag ,
NULL,
revenue_distributed_flag ,
billed_flag,
bill_hold_flag,
NULL, -- distribution_id ,
NULL, -- po_distribution_id ,
NULL, -- invoice_distribution_id ,
parent_award_set_id ,
NULL ,
parent_adl_line_num ,
NULL ,
null , -- burdenable_raw_cost,
'N' , -- cost_distributed_flag ,
sysdate , -- SYSDATE
p_user , -- last_updated_by ,
P_user , -- created_by ,
sysdate , -- creation_date ,
p_login ,
billable_flag
from GMS_AWARD_DISTRIBUTIONS
where expenditure_item_id = p_exp_item_id
and document_type = 'EXP'
and adl_status = 'A'
and adl_line_num = 1 ;