The following lines contain the word 'select', 'insert', 'update' or 'delete':
last_updated_by NUMBER(15); --|
last_update_login NUMBER(15); --|Standard Who Columns
SELECT DECODE(P_cost_budget_type_code,NULL,default_cost_budget_type_code, P_cost_budget_type_code),
DECODE(P_rev_budget_type_code,NULL,default_rev_budget_type_code,P_rev_budget_type_code),
DECODE(P_cost_plan_type_id,NULL,default_cost_plan_type_id,
P_cost_plan_type_id), /* Added for Fin plan impact */
DECODE(P_rev_plan_type_id,NULL,default_rev_plan_type_id,
P_rev_plan_type_id) /* Added for Fin plan impact */
INTO l_cost_budget_type_code,
l_rev_budget_type_code,
l_cost_plan_type_id,
l_rev_plan_type_id
FROM pa_billing_extensions
WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
/* Added this select for Fin plan Impact */
BEGIN
SELECT 'x'
INTO dummy
FROM dual
WHERE EXISTS( SELECT *
FROM pa_fin_plan_types_b f
WHERE f.fin_plan_type_id=l_cost_plan_type_id );
SELECT 'x'
INTO dummy
FROM pa_budget_types
WHERE budget_type_code = l_cost_budget_type_code
AND budget_amount_code = 'C';
/* Added this select for Fin plan Impact */
BEGIN
SELECT 'x'
INTO dummy
FROM dual
WHERE EXISTS( SELECT *
FROM pa_fin_plan_types_b f
WHERE f.fin_plan_type_id=l_rev_plan_type_id );
SELECT 'x'
INTO dummy
FROM pa_budget_types
WHERE budget_type_code = l_rev_budget_type_code
AND budget_amount_code = 'R';
/* Added this select for Fin plan Impact */
BEGIN
SELECT v.budget_version_id
INTO l_cost_plan_version_id
FROM pa_budget_versions v
WHERE v.project_id = X2_project_id
AND v.current_flag = 'Y'
AND v.budget_status_code = 'B'
AND v.fin_plan_type_id = l_cost_plan_type_id
AND v.version_type IN ('COST','ALL');
SELECT budget_version_id
INTO l_cost_budget_version_id
FROM pa_budget_versions pbv
WHERE project_id = X2_project_id
AND budget_type_code = l_cost_budget_type_code
AND budget_status_code = 'B'
AND current_flag = 'Y';
/* Added this select for Fin plan Impact */
BEGIN
SELECT v.budget_version_id
INTO l_rev_plan_version_id
FROM pa_budget_versions v
WHERE v.project_id = X2_project_id
AND v.current_flag = 'Y'
AND v.budget_status_code = 'B'
AND v.fin_plan_type_id = l_rev_plan_type_id
AND v.version_type IN ('REVENUE','ALL');
SELECT budget_version_id
INTO l_rev_budget_version_id
FROM pa_budget_versions pbv
WHERE project_id = X2_project_id
AND budget_type_code = l_rev_budget_type_code
AND budget_status_code = 'B'
AND current_flag = 'Y';
insert_message
(X_inserting_procedure_name =>'pa_billing_pub.get_budget_amount',
X_attribute1 => l_cost_budget_type_code,
X_attribute2 => l_rev_budget_type_code,
X_message => status,
X_error_message=>err_msg,
X_status=>err_status);
SELECT ei.expenditure_item_id eid,
decode( X_which_amount, 'I', nvl(rdl.bill_amount,0),
'R', nvl(rdl.amount,0),
'C', nvl(ei.raw_cost,0),
'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
FROM pa_tasks t,
pa_expenditure_items_all ei,
pa_expenditure_items_all ei2,
pa_cust_rev_dist_lines rdl
WHERE
ei.task_id = t.task_Id
AND (t.top_task_id = X_top_task_id
OR X_top_task_id IS NULL)
AND rdl.project_id between nvl(X_project_id, 0)
and nvl(X_project_id, 9999999999)
AND (ei.system_linkage_function||'' = X_system_linkage
OR X_system_linkage IS NULL)
AND rdl.request_id = X_request_id
AND (EXISTS
(select '1'
from pa_cost_base_exp_types cb
where cb.expenditure_type = ei.expenditure_type
and cb.cost_base = X_cost_base
and cb.cost_plus_structure = X_CP_structure
and cb.cost_base_type = X_CB_type)
OR
( X_cost_base IS NULL
OR X_CP_structure IS NULL
OR X_CB_type IS NULL))
AND ei.expenditure_item_id = rdl.expenditure_item_id
AND rdl.line_num = decode( X_which_amount, 'C', 1,
'B', 1, rdl.line_num)
AND ei.adjusted_expenditure_item_id = ei2.expenditure_item_id (+)
AND ((X_calling_place = 'ADJ'
AND (rdl.line_num_reversed IS NOT NULL
OR (ei.adjusted_expenditure_item_id IS NOT NULL
and ei2.request_id <> X_request_id)))
OR (X_calling_place = 'REG'
AND (rdl.line_num_reversed IS NULL
and rdl.reversed_flag IS NULL
and (ei.adjusted_expenditure_item_id IS NULL
or ei2.request_id = X_request_id))));
SELECT ei.expenditure_item_id eid,
decode( X_which_amount, 'I', nvl(rdl.bill_amount,0),
'R', nvl(rdl.amount,0),
'C', nvl(ei.raw_cost,0),
'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
FROM pa_tasks t,
pa_expenditure_items_all ei2,
pa_expenditure_items_all ei,
pa_cust_rev_dist_lines rdl2,
pa_cust_rev_dist_lines rdl,
pa_draft_invoice_items pdii,
pa_draft_invoices pdi
WHERE
ei.task_id = t.task_Id
AND (t.top_task_id = X_top_task_id
OR X_top_task_id IS NULL)
AND pdi.project_id between nvl(X_project_id, 0)
and nvl(X_project_id, 9999999999)
AND (ei.system_linkage_function||'' = X_system_linkage
OR X_system_linkage IS NULL)
AND pdii.project_id = rdl.project_id
AND pdii.draft_invoice_num = rdl.draft_invoice_num
AND pdii.line_num = rdl.draft_invoice_item_line_num
AND pdii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
AND pdii.project_id = pdi.project_id
AND pdii.draft_invoice_num = pdi.draft_invoice_num
AND pdi.request_id = X_request_id
AND ei.adjusted_expenditure_item_id = ei2.expenditure_item_id (+)
AND ei2.expenditure_item_id = rdl2.expenditure_item_id (+)
AND (EXISTS
(select '1'
from pa_cost_base_exp_types cb
where cb.expenditure_type = ei.expenditure_type
and cb.cost_base = X_cost_base
and cb.cost_plus_structure = X_CP_structure
and cb.cost_base_type = X_CB_type)
OR
( X_cost_base IS NULL
OR X_CP_structure IS NULL
OR X_CB_type IS NULL))
AND ei.expenditure_item_id = rdl.expenditure_item_id
AND rdl.line_num = decode( X_which_amount, 'C', 1,
'B', 1, rdl.line_num)
AND ((X_calling_place = 'ADJ'
AND (rdl.line_num_reversed IS NOT NULL
OR (ei.adjusted_expenditure_item_id IS NOT NULL
and rdl2.draft_invoice_num <> rdl.draft_invoice_num)))
OR (X_calling_place = 'REG'
AND (rdl.line_num_reversed IS NULL
and rdl.reversed_flag IS NULL
and (ei.adjusted_expenditure_item_id IS NULL
or rdl2.draft_invoice_num = rdl.draft_invoice_num))));
SELECT ei.expenditure_item_id eid,
decode(X_which_amount, 'C', nvl(ei.raw_cost,0),
'B', nvl(ei.burden_cost,0),
nvl(ei.burden_cost,0)) amt,
decode(ei.adjusted_expenditure_item_id, NULL, 'N','Y') ei_adj
FROM pa_expenditure_items_all ei,
/* pa_expenditure_items_all ei2, commented for Bug#2499051*/
pa_tasks t
WHERE
ei.task_id = t.task_Id
AND (t.top_task_id = X_top_task_id
OR X_top_task_id IS NULL)
AND t.project_id = X_project_id
AND (ei.system_linkage_function = X_system_linkage
OR X_system_linkage IS NULL)
AND (EXISTS
(select '1'
from pa_cost_base_exp_types cb
where cb.expenditure_type = ei.expenditure_type
and cb.cost_base = X_cost_base
and cb.cost_plus_structure = X_CP_structure
and cb.cost_base_type = X_CB_type)
OR
( X_cost_base IS NULL
OR X_CP_structure IS NULL
OR X_CB_type IS NULL))
AND (ei.request_id = X_request_id
OR X_request_id IS NULL);
PROCEDURE insert_message(X_inserting_procedure_name VARCHAR2,
X_message VARCHAR2,
X_attribute1 VARCHAR2 DEFAULT NULL,
X_attribute2 VARCHAR2 DEFAULT NULL,
X_attribute3 VARCHAR2 DEFAULT NULL,
X_attribute4 VARCHAR2 DEFAULT NULL,
X_attribute5 VARCHAR2 DEFAULT NULL,
X_attribute6 VARCHAR2 DEFAULT NULL,
X_attribute7 VARCHAR2 DEFAULT NULL,
X_attribute8 VARCHAR2 DEFAULT NULL,
X_attribute9 VARCHAR2 DEFAULT NULL,
X_attribute10 VARCHAR2 DEFAULT NULL,
X_attribute11 VARCHAR2 DEFAULT NULL,
X_attribute12 VARCHAR2 DEFAULT NULL,
X_attribute13 VARCHAR2 DEFAULT NULL,
X_attribute14 VARCHAR2 DEFAULT NULL,
X_attribute15 VARCHAR2 DEFAULT NULL,
X_error_message OUT NOCOPY VARCHAR2,
X_status OUT NOCOPY NUMBER) IS
x_last_updated_by NUMBER(15); --|
x_last_update_login NUMBER(15); --|Standard Who Columns
PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_message: ');
x_last_updated_by := FND_GLOBAL.USER_ID;
x_last_update_login := FND_GLOBAL.LOGIN_ID;
SELECT max(BM.line_num)
INTO xo_line_num
FROM PA_BILLING_MESSAGES BM
WHERE BM.project_id = pa_billing.GlobVars.ProjectId
AND nvl(BM.task_Id,0) = nvl(pa_billing.GlobVars.TaskId,0)
AND BM.calling_place = pa_billing.GlobVars.CallingPlace
AND BM.calling_process = pa_billing.GlobVars.CallingProcess
AND BM.request_id = pa_billing.GlobVars.ReqId;
INSERT INTO PA_BILLING_MESSAGES
(inserting_procedure_name,
Billing_Assignment_Id,
Project_Id,
Task_Id,
calling_place,
calling_process,
request_id,
line_Num,
message,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES (
X_inserting_procedure_name,
pa_billing.GlobVars.BillingAssignmentId,
pa_billing.GlobVars.ProjectId,
pa_billing.GlobVars.TaskId,
pa_billing.GlobVars.CallingPlace,
pa_billing.GlobVars.CallingProcess,
pa_billing.GlobVars.ReqId,
xo_line_num,
X_message,
sysdate,
x_created_by,
sysdate,
x_last_updated_by,
x_last_update_login,
X_attribute1,
X_attribute2,
X_attribute3,
X_attribute4,
X_attribute5,
X_attribute6,
X_attribute7,
X_attribute8,
X_attribute9,
X_attribute10,
X_attribute11,
X_attribute12,
X_attribute13,
X_attribute14,
X_attribute15);
PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_message: ');
END insert_message;
PROCEDURE insert_event (X_rev_amt REAL DEFAULT NULL,
X_bill_amt REAL DEFAULT NULL,
X_project_id NUMBER DEFAULT NULL,
X_event_type VARCHAR2 DEFAULT NULL,
X_top_task_id NUMBER DEFAULT NULL,
X_organization_id NUMBER DEFAULT NULL,
X_completion_date DATE DEFAULT NULL,
X_event_description VARCHAR2 DEFAULT NULL,
X_event_num_reversed NUMBER DEFAULT NULL,
X_attribute_category VARCHAR2 DEFAULT NULL,
X_attribute1 VARCHAR2 DEFAULT NULL,
X_attribute2 VARCHAR2 DEFAULT NULL,
X_attribute3 VARCHAR2 DEFAULT NULL,
X_attribute4 VARCHAR2 DEFAULT NULL,
X_attribute5 VARCHAR2 DEFAULT NULL,
X_attribute6 VARCHAR2 DEFAULT NULL,
X_attribute7 VARCHAR2 DEFAULT NULL,
X_attribute8 VARCHAR2 DEFAULT NULL,
X_attribute9 VARCHAR2 DEFAULT NULL,
X_attribute10 VARCHAR2 DEFAULT NULL,
X_audit_amount1 IN NUMBER DEFAULT NULL,
X_audit_amount2 IN NUMBER DEFAULT NULL,
X_audit_amount3 IN NUMBER DEFAULT NULL,
X_audit_amount4 IN NUMBER DEFAULT NULL,
X_audit_amount5 IN NUMBER DEFAULT NULL,
X_audit_amount6 IN NUMBER DEFAULT NULL,
X_audit_amount7 IN NUMBER DEFAULT NULL,
X_audit_amount8 IN NUMBER DEFAULT NULL,
X_audit_amount9 IN NUMBER DEFAULT NULL,
X_audit_amount10 IN NUMBER DEFAULT NULL,
X_audit_cost_budget_type_code IN VARCHAR2 DEFAULT NULL,
X_audit_rev_budget_type_code IN VARCHAR2 DEFAULT NULL,
x_inventory_org_id IN NUMBER DEFAULT NULL,
x_inventory_item_id IN NUMBER DEFAULT NULL,
x_quantity_billed IN NUMBER DEFAULT NULL,
x_uom_code IN VARCHAR2 DEFAULT NULL,
x_unit_price IN NUMBER DEFAULT NULL,
x_reference1 IN VARCHAR2 DEFAULT NULL,
x_reference2 IN VARCHAR2 DEFAULT NULL,
x_reference3 IN VARCHAR2 DEFAULT NULL,
x_reference4 IN VARCHAR2 DEFAULT NULL,
x_reference5 IN VARCHAR2 DEFAULT NULL,
x_reference6 IN VARCHAR2 DEFAULT NULL,
x_reference7 IN VARCHAR2 DEFAULT NULL,
x_reference8 IN VARCHAR2 DEFAULT NULL,
x_reference9 IN VARCHAR2 DEFAULT NULL,
x_reference10 IN VARCHAR2 DEFAULT NULL,
X_txn_currency_code IN VARCHAR2 DEFAULT NULL, /* Added 20 columns for MCB2 */
X_project_rate_type IN VARCHAR2 DEFAULT NULL,
X_project_rate_date IN DATE DEFAULT NULL,
X_project_exchange_rate IN NUMBER DEFAULT NULL,
X_project_func_rate_type IN VARCHAR2 DEFAULT NULL,
X_project_func_rate_date IN DATE DEFAULT NULL,
X_project_func_exchange_rate IN NUMBER DEFAULT NULL,
X_funding_rate_type IN VARCHAR2 DEFAULT NULL,
X_funding_rate_date IN DATE DEFAULT NULL,
X_funding_exchange_rate IN NUMBER DEFAULT NULL,
X_zero_revenue_amount_flag IN VARCHAR2 DEFAULT NULL, /* Funding MRC Changes */
X_audit_cost_plan_type_id IN NUMBER DEFAULT NULL, /* Added for Fin plan impact */
X_audit_rev_plan_type_id IN NUMBER DEFAULT NULL, /* Added for Fin plan impact */
X_error_message OUT NOCOPY VARCHAR2,
X_status OUT NOCOPY NUMBER
) IS
XD_bill_trans_bill_amt NUMBER(22,5); /* changed for MCB2 from rev/bill amount to trans bill/rev amount */
PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event:' );
last_updated_by := FND_GLOBAL.USER_ID;
last_update_login := FND_GLOBAL.LOGIN_ID;
SELECT 'Y'
INTO l_found
FROM fnd_currencies /* Bug 4352166 Changed vl to base table*/
WHERE currency_code = l_txn_currency_code
AND TRUNC(SYSDATE) BETWEEN DECODE (TRUNC(start_date_active), NULL, TRUNC(SYSDATE),
TRUNC(start_date_active))
AND DECODE(TRUNC(end_date_active), NULL, TRUNC(SYSDATE),TRUNC(end_date_active));
PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));
PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: inv amt'||to_char(XD_bill_trans_bill_amt));
SELECT 'Valid item'
INTO l_dummy
FROM mtl_item_flexfields
WHERE inventory_item_id = x_inventory_item_id;
SELECT 'found'
INTO l_found
FROM ( SELECT conversion_type, user_conversion_type
FROM pa_conversion_types_v
WHERE conversion_type <>'User'
AND (pa_multi_currency.is_user_rate_type_allowed(
l_txn_currency_code,
l_projfunc_currency_code,
DECODE(l_projfunc_bil_rate_date_code,
'PA_INVOICE_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),
'FIXED_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date)))= 'N')
UNION
SELECT conversion_type, user_conversion_type
FROM pa_conversion_types_v
WHERE pa_multi_currency.is_user_rate_type_allowed(
l_txn_currency_code,
l_projfunc_currency_code,
DECODE(l_projfunc_bil_rate_date_code,
'PA_INVOICE_DATE',NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),
'FIXED_DATE',NVL(X_project_func_rate_date,l_projfunc_bil_rate_date) ))= 'Y')
WHERE DECODE(conversion_type,X_project_func_rate_type,'Y','N') = 'Y';
SELECT 'found'
INTO l_found
FROM ( SELECT conversion_type, user_conversion_type
FROM pa_conversion_types_v
WHERE conversion_type <>'User'
AND (pa_multi_currency.is_user_rate_type_allowed(
l_txn_currency_code,
l_project_currency_code,
DECODE(l_project_bil_rate_date_code,
'PA_INVOICE_DATE', NVL(X_project_rate_date,l_project_bil_rate_date),
'FIXED_DATE', NVL(X_project_rate_date,l_project_bil_rate_date)))= 'N')
UNION
SELECT conversion_type, user_conversion_type
FROM pa_conversion_types_v
WHERE pa_multi_currency.is_user_rate_type_allowed(
l_txn_currency_code,
l_project_currency_code,
DECODE(l_project_bil_rate_date_code,
'PA_INVOICE_DATE',NVL(X_project_rate_date,l_project_bil_rate_date),
'FIXED_DATE',NVL(X_project_rate_date,l_project_bil_rate_date) ))= 'Y')
WHERE DECODE(conversion_type,X_project_rate_type,'Y','N') = 'Y';
SELECT 'found'
INTO l_found
FROM ( SELECT conversion_type, user_conversion_type
FROM pa_conversion_types_v)
WHERE DECODE(conversion_type,X_funding_rate_type,'Y','N') = 'Y';
insert into pa_events
(PROJECT_ID, TASK_ID, ORGANIZATION_ID, EVENT_NUM, EVENT_TYPE, -- 1
REVENUE_AMOUNT,BILL_AMOUNT,COMPLETION_DATE, REQUEST_ID, -- 2
DESCRIPTION, BILL_HOLD_FLAG, REV_DIST_REJECTION_CODE, -- 3
REVENUE_DISTRIBUTED_FLAG, PROGRAM_APPLICATION_ID, PROGRAM_ID, -- 4
PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, -- 5
CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, -- 6
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, -- 7
ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, -- 8
BILLING_ASSIGNMENT_ID, calling_place, calling_process, -- 9
EVENT_NUM_REVERSED, -- 10
AUDIT_AMOUNT1,
AUDIT_AMOUNT2,
AUDIT_AMOUNT3,
AUDIT_AMOUNT4,
AUDIT_AMOUNT5,
AUDIT_AMOUNT6,
AUDIT_AMOUNT7,
AUDIT_AMOUNT8,
AUDIT_AMOUNT9,
AUDIT_AMOUNT10,
AUDIT_COST_BUDGET_TYPE_CODE,
AUDIT_REV_BUDGET_TYPE_CODE,
EVENT_ID,
INVENTORY_ORG_ID,
INVENTORY_ITEM_ID,
QUANTITY_BILLED,
UOM_CODE,
UNIT_PRICE,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
BILL_TRANS_CURRENCY_CODE, /* These 22 columns have been added for MCB2 */
BILL_TRANS_REV_AMOUNT,
BILL_TRANS_BILL_AMOUNT,
PROJECT_CURRENCY_CODE,
PROJECT_RATE_TYPE,
PROJECT_RATE_DATE,
PROJECT_EXCHANGE_RATE,
PROJFUNC_CURRENCY_CODE,
PROJFUNC_RATE_TYPE,
PROJFUNC_RATE_DATE,
PROJFUNC_EXCHANGE_RATE,
FUNDING_RATE_TYPE,
FUNDING_RATE_DATE,
FUNDING_EXCHANGE_RATE,
INVPROC_CURRENCY_CODE,
INVPROC_RATE_TYPE,
INVPROC_RATE_DATE,
INVPROC_EXCHANGE_RATE,
REVPROC_CURRENCY_CODE,
REVPROC_RATE_TYPE,
REVPROC_RATE_DATE,
REVPROC_EXCHANGE_RATE,
ZERO_REVENUE_AMOUNT_FLAG, /* Funding MRC Changes */
AUDIT_COST_PLAN_TYPE_ID, /* Added for Fin Plan impact */
AUDIT_REV_PLAN_TYPE_ID /* Added for Fin Plan impact */
)
values
(nvl(X_project_id, pa_billing.GlobVars.ProjectId), nvl(X_top_task_id,pa_billing.GlobVars.TaskId),
XD_organization_id, event_num, XD_event_type, -- 1
0,0,XD_completion_date, pa_billing.GlobVars.ReqId, -- 2
XD_event_description, 'N', NULL, -- 3
'N', program_application_id,program_id, -- 4
sysdate, sysdate, nvl(last_updated_by,0), -- 5
sysdate, nvl(created_by,0), nvl(last_update_login,0),
X_attribute_category, -- 6
X_attribute1, X_attribute2, X_attribute3, X_attribute4,
X_attribute5, -- 7
X_attribute6, X_attribute7, X_attribute8, X_attribute9,
X_attribute10, -- 8
pa_billing.GlobVars.BillingAssignmentId, pa_billing.GlobVars.CallingPlace,
pa_billing.GlobVars.CallingProcess, -- 9
X_event_num_reversed, -- 10
pa_currency.round_currency_amt(X_audit_amount1),
pa_currency.round_currency_amt(X_audit_amount2),
pa_currency.round_currency_amt(X_audit_amount3),
pa_currency.round_currency_amt(X_audit_amount4),
pa_currency.round_currency_amt(X_audit_amount5),
pa_currency.round_currency_amt(X_audit_amount6),
pa_currency.round_currency_amt(X_audit_amount7),
pa_currency.round_currency_amt(X_audit_amount8),
pa_currency.round_currency_amt(X_audit_amount9),
pa_currency.round_currency_amt(X_audit_amount10),
X_audit_cost_budget_type_code,
X_audit_rev_budget_type_code,
pa_events_s.nextval,
x_inventory_org_id,
x_inventory_item_id,
x_quantity_billed,
x_uom_code,
x_unit_price,
x_reference1,
x_reference2,
x_reference3,
x_reference4,
x_reference5,
x_reference6,
x_reference7,
x_reference8,
x_reference9,
x_reference10,
l_txn_currency_code,
XD_bill_trans_rev_amt,
XD_bill_trans_bill_amt,
l_project_currency_code,
l_project_bil_rate_type,
l_project_bil_rate_date,
l_project_bil_exchange_rate,
l_projfunc_currency_code,
l_projfunc_bil_rate_type,
l_projfunc_bil_rate_date,
l_projfunc_bil_exchange_rate,
l_funding_rate_type,
l_funding_rate_date,
l_funding_exchange_rate,
l_invproc_currency_code,
l_invproc_rate_type,
l_invproc_rate_date,
l_invproc_exchange_rate,
l_revproc_currency_code,
l_revproc_rate_type,
l_revproc_rate_date,
l_revproc_exchange_rate,
NVL(X_zero_revenue_amount_flag, 'N'),
X_audit_cost_plan_type_id,
X_audit_rev_plan_type_id
);
PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_events: ');
insert_message(X_inserting_procedure_name => 'pa_billing_pub.insert_event',
X_attribute1 => XD_bill_trans_rev_amt,
X_attribute2 => XD_bill_trans_bill_amt,
X_message => status,
X_status => err_status,
X_error_message => err_message);
END insert_event;
SELECT 'N' -- MRC migration to SLA
INTO l_enabled_flag
FROM pa_implementations;
Select NVL(Enable_Top_Task_Customer_Flag, 'N')
Into l_Enable_Top_Task_Cust_Flag
From PA_Projects_all
Where Project_ID = P_Project_ID;
Select NVL(ENABLE_TOP_TASK_INV_MTH_FLAG, 'N')
Into l_ENABLE_TOP_TASK_INV_MTH_FLAG
From PA_Projects_all
Where Project_ID = P_Project_ID;