eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EVENT_PUB dependencies on PA_EVENTS

Line 24: -- PA_EVENTS_PKG.INSERT_ROW

20: -- PA_EVENT_PVT.CHECK_MDTY_PARAMS2
21: -- PA_EVENT_UTILS.CHECK_VALID_PROJECT
22: -- PA_EVENT_PVT.CHECK_CREATE_EVENT_OK
23: -- PA_EVENT_PVT.VALIDATE_FLEXFIELD
24: -- PA_EVENTS_PKG.INSERT_ROW
25: --History:
26:
27: -- ============================================================================*/
28:

Line 44: P_project_id pa_events.project_id%type;

40:
41:
42: rowid varchar2(18);
43: l_event_type_classification pa_event_types.event_type_classification%type;
44: P_project_id pa_events.project_id%type;
45: P_task_id pa_events.task_id%type;
46: P_Organization_Id pa_projects_all.org_id%type;
47: p_inv_org_id pa_events.inventory_item_id%type;
48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake

Line 45: P_task_id pa_events.task_id%type;

41:
42: rowid varchar2(18);
43: l_event_type_classification pa_event_types.event_type_classification%type;
44: P_project_id pa_events.project_id%type;
45: P_task_id pa_events.task_id%type;
46: P_Organization_Id pa_projects_all.org_id%type;
47: p_inv_org_id pa_events.inventory_item_id%type;
48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake
49:

Line 47: p_inv_org_id pa_events.inventory_item_id%type;

43: l_event_type_classification pa_event_types.event_type_classification%type;
44: P_project_id pa_events.project_id%type;
45: P_task_id pa_events.task_id%type;
46: P_Organization_Id pa_projects_all.org_id%type;
47: p_inv_org_id pa_events.inventory_item_id%type;
48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake
49:
50: p_event_in_rec Event_Rec_In_Type;
51: p_event_out_rec Event_Rec_Out_Type;

Line 48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake

44: P_project_id pa_events.project_id%type;
45: P_task_id pa_events.task_id%type;
46: P_Organization_Id pa_projects_all.org_id%type;
47: p_inv_org_id pa_events.inventory_item_id%type;
48: p_agreement_id pa_events.agreement_id%type; -- Federal Uptake
49:
50: p_event_in_rec Event_Rec_In_Type;
51: p_event_out_rec Event_Rec_Out_Type;
52: tot_in_rec NUMBER:=0;

Line 62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

58: /* Declaring varible for MCB2 */
59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

59: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

60: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

61: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
62: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

63: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

64: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

65: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
66: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
67: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
68: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
69: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
70: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
71: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
72: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
73: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 85: l_event_number pa_events.event_num%type;

81: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
82: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
83: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
84:
85: l_event_number pa_events.event_num%type;
86: l_encoded varchar2(1):='F';
87: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
88: BEGIN
89: -- Initialize the Error Stack

Line 412: -- inserting the record into pa_events.

408: ,x_log_level => 5);
409: END IF;
410:
411: -- Validating the event num.If found NULL it is populated before
412: -- inserting the record into pa_events.
413: If (p_event_in_rec.P_event_number Is NULL
414: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
415: Then
416: --generating event number for project level events

Line 421: FROM pa_events e

417: If (P_task_id Is NULL)
418: Then
419: SELECT NVL(max(event_num),0)+1
420: INTO P_event_in_rec.p_event_number
421: FROM pa_events e
422: WHERE e.project_id = P_project_id
423: AND e.task_id IS NULL;
424: Else
425: --generating event number for task level events

Line 428: FROM pa_events e

424: Else
425: --generating event number for task level events
426: SELECT NVL(max(event_num),0)+1
427: INTO P_event_in_rec.p_event_number
428: FROM pa_events e
429: WHERE e.project_id =P_project_id
430: AND e.task_id = P_task_id;
431: End If;
432: End If;

Line 840: --Calling PA_EVENTS_PKG.

836:
837: -- Till here
838:
839: --Call to table handler to insert the events into the database
840: --Calling PA_EVENTS_PKG.
841:
842: PA_EVENTS_PKG.Insert_Row
843: (X_Rowid =>rowid
844: ,X_Event_Id =>p_event_in_rec.p_event_id

Line 842: PA_EVENTS_PKG.Insert_Row

838:
839: --Call to table handler to insert the events into the database
840: --Calling PA_EVENTS_PKG.
841:
842: PA_EVENTS_PKG.Insert_Row
843: (X_Rowid =>rowid
844: ,X_Event_Id =>p_event_in_rec.p_event_id
845: ,X_product_code =>p_pm_product_code
846: ,X_event_reference =>p_event_in_rec.p_pm_event_reference

Line 1079: -- pa_events_pkg.update_row

1075: --Called subprograms: PA_EVENT_PVT.CHECK_MDTY_PARAMS1
1076: -- PA_EVENT_PVT.CHECK_MDTY_PARAMS2
1077: -- PA_EVENT_PVT.check_update_event_ok
1078: -- PA_EVENT_PVT.VALIDATE_FLEXFIELD
1079: -- pa_events_pkg.update_row
1080: --
1081: --
1082: --
1083: --History:

Line 1105: p_inv_org_id pa_events.inventory_item_id%type;

1101: Select project_id
1102: From pa_projects_all
1103: Where segment1 = P_project_number;
1104:
1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;

Line 1106: P_project_id pa_events.project_id%type;

1102: From pa_projects_all
1103: Where segment1 = P_project_number;
1104:
1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;

Line 1108: P_task_id pa_events.task_id%type;

1104:
1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;
1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake

Line 1109: l_task_id pa_events.task_id%type;

1105: p_inv_org_id pa_events.inventory_item_id%type;
1106: P_project_id pa_events.project_id%type;
1107: l_project_id pa_projects_all.project_id%type;
1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;
1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1113:

Line 1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake

1108: P_task_id pa_events.task_id%type;
1109: l_task_id pa_events.task_id%type;
1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;
1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1113:
1114: P_event_id_out pa_events.event_id%type;
1115: Rowid VARCHAR2(18);
1116: p_event_in_rec Event_Rec_In_Type;

Line 1114: P_event_id_out pa_events.event_id%type;

1110: P_Organization_Id pa_projects_all.org_id%type;
1111: l_event_type_classification pa_event_types.event_type_classification%type;
1112: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1113:
1114: P_event_id_out pa_events.event_id%type;
1115: Rowid VARCHAR2(18);
1116: p_event_in_rec Event_Rec_In_Type;
1117: p_event_out_rec Event_Rec_Out_Type;
1118: tot_in_rec NUMBER:=0;

Line 1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;

1119: tot_out_rec NUMBER:=0;
1120: p_api_name VARCHAR2(100):='UPDATE_EVENT';
1121: p_return_msg VARCHAR2(2000);
1122: p_validate_status VARCHAR2(1):='Y';
1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;

Line 1124: l_project_currency_code pa_events.Project_currency_code%type;

1120: p_api_name VARCHAR2(100):='UPDATE_EVENT';
1121: p_return_msg VARCHAR2(2000);
1122: p_validate_status VARCHAR2(1):='Y';
1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;

Line 1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;

1121: p_return_msg VARCHAR2(2000);
1122: p_validate_status VARCHAR2(1):='Y';
1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;

Line 1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;

1122: p_validate_status VARCHAR2(1):='Y';
1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;

Line 1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;

1123: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;

Line 1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;

1124: l_project_currency_code pa_events.Project_currency_code%type;
1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;

Line 1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;

1125: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;

Line 1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;

1126: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;

Line 1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;

1127: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;

Line 1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;

1128: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;

Line 1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;

1129: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;

Line 1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;

1130: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;

Line 1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;

1131: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;

Line 1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;

1132: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;

Line 1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;

1133: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;

Line 1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;

1134: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;

Line 1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;

1135: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;

Line 1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;

1136: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;

Line 1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;

1137: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;

Line 1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;

1138: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;

Line 1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;

1139: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;

Line 1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;

1140: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;

Line 1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;

1141: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1142: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1143: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1144: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;

Line 1149: l_project_bil_rate_type pa_events.project_rate_type%type;

1145: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;

Line 1150: l_project_bil_rate_date pa_events.project_rate_date%type;

1146: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;

Line 1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;

1147: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;

Line 1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;

1148: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;

Line 1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;

1149: l_project_bil_rate_type pa_events.project_rate_type%type;
1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;

Line 1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;

1150: l_project_bil_rate_date pa_events.project_rate_date%type;
1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;

Line 1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;

1151: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;

Line 1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;

1152: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;

Line 1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;

1153: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;

Line 1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;

1154: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;

Line 1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;

1155: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;

Line 1160: l_description pa_events.description%type;

1156: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;

Line 1161: l_bill_hold_flag pa_events.bill_hold_flag%type;

1157: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;

Line 1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;

1158: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 1163: l_inventory_org_id pa_events.inventory_org_id%type;

1159: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1167: l_encoded varchar2(1):='F';

Line 1164: l_inventory_item_id pa_events.inventory_item_id%type;

1160: l_description pa_events.description%type;
1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1167: l_encoded varchar2(1):='F';
1168: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;

Line 1165: l_organization_id pa_events.organization_id%type;

1161: l_bill_hold_flag pa_events.bill_hold_flag%type;
1162: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1163: l_inventory_org_id pa_events.inventory_org_id%type;
1164: l_inventory_item_id pa_events.inventory_item_id%type;
1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1167: l_encoded varchar2(1):='F';
1168: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
1169: l_record_version_number pa_events.record_version_number%TYPE;

Line 1169: l_record_version_number pa_events.record_version_number%TYPE;

1165: l_organization_id pa_events.organization_id%type;
1166: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1167: l_encoded varchar2(1):='F';
1168: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
1169: l_record_version_number pa_events.record_version_number%TYPE;
1170:
1171: /* Added for bug 7110782 */
1172: l_event_processed varchar2(1) := 'N';
1173: l_bill_amount pa_events.bill_amount%type;

Line 1173: l_bill_amount pa_events.bill_amount%type;

1169: l_record_version_number pa_events.record_version_number%TYPE;
1170:
1171: /* Added for bug 7110782 */
1172: l_event_processed varchar2(1) := 'N';
1173: l_bill_amount pa_events.bill_amount%type;
1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;

Line 1174: l_revenue_amount pa_events.revenue_amount%type;

1170:
1171: /* Added for bug 7110782 */
1172: l_event_processed varchar2(1) := 'N';
1173: l_bill_amount pa_events.bill_amount%type;
1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;

Line 1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;

1171: /* Added for bug 7110782 */
1172: l_event_processed varchar2(1) := 'N';
1173: l_bill_amount pa_events.bill_amount%type;
1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;

Line 1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;

1172: l_event_processed varchar2(1) := 'N';
1173: l_bill_amount pa_events.bill_amount%type;
1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;
1180: l_Calling_Process pa_events.Calling_Process%type;

Line 1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;

1173: l_bill_amount pa_events.bill_amount%type;
1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;
1180: l_Calling_Process pa_events.Calling_Process%type;
1181: /* Added for bug 7110782 */

Line 1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;

1174: l_revenue_amount pa_events.revenue_amount%type;
1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;
1180: l_Calling_Process pa_events.Calling_Process%type;
1181: /* Added for bug 7110782 */
1182:

Line 1179: l_Calling_Place pa_events.Calling_Place%type;

1175: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;
1180: l_Calling_Process pa_events.Calling_Process%type;
1181: /* Added for bug 7110782 */
1182:
1183: BEGIN

Line 1180: l_Calling_Process pa_events.Calling_Process%type;

1176: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1177: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1178: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1179: l_Calling_Place pa_events.Calling_Place%type;
1180: l_Calling_Process pa_events.Calling_Process%type;
1181: /* Added for bug 7110782 */
1182:
1183: BEGIN
1184:

Line 1348: From pa_events

1344:
1345: --Deriving the project_id using the event_reference and product_code
1346: Select project_id, record_version_number
1347: Into P_project_id, p_event_in_rec.P_record_version_number
1348: From pa_events
1349: Where event_id = p_event_in_rec.P_event_id;
1350:
1351:
1352: --Deriving the project_id using the project_number if provided.

Line 1381: ,x_msg =>'Defaulting currency from pa_events for the given event'

1377:
1378: --Log Message
1379: IF l_debug_mode = 'Y' THEN
1380: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1381: ,x_msg =>'Defaulting currency from pa_events for the given event'
1382: ,x_log_level =>5);
1383: END IF;
1384:
1385: --Select default currency from pa_events for the given event

Line 1385: --Select default currency from pa_events for the given event

1381: ,x_msg =>'Defaulting currency from pa_events for the given event'
1382: ,x_log_level =>5);
1383: END IF;
1384:
1385: --Select default currency from pa_events for the given event
1386: --And use those for validations if the currency fields are not
1387: --overwritten by the new changes.
1388: Select ev.Project_currency_code
1389: ,ev.ProjFunc_Inv_Rate_date

Line 1454: From pa_events ev

1450: ,l_funding_rate_type
1451: ,l_funding_rate_date
1452: ,l_funding_exchange_rate
1453: ,l_bill_trans_curr_code
1454: From pa_events ev
1455: Where event_id=p_event_in_rec.p_event_id;
1456:
1457: Select multi_currency_billing_flag
1458: ,funding_rate_date_code

Line 1606: From pa_events

1602: ,p_event_in_rec.P_attribute7
1603: ,p_event_in_rec.P_attribute8
1604: ,p_event_in_rec.P_attribute9
1605: ,p_event_in_rec.P_attribute10
1606: From pa_events
1607: Where event_id=p_event_in_rec.P_event_id;
1608:
1609: Else
1610: p_event_in_rec.P_desc_flex_name :=NULL;

Line 1881: --before inserting the record into pa_events.

1877:
1878:
1879: -- Validating the event num.
1880: --If task number has been changed then generate new event_num
1881: --before inserting the record into pa_events.
1882: If (p_event_in_rec.P_event_number Is NULL
1883: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1884: Then
1885: SELECT task_id

Line 1887: FROM pa_events e

1883: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1884: Then
1885: SELECT task_id
1886: INTO l_task_id
1887: FROM pa_events e
1888: Where event_id=p_event_in_rec.P_event_id;
1889:
1890: --Validating if the existing task_id matches with the updated task_id
1891: --In case of any mismatch new event_number is generated before updating the record.

Line 1901: FROM pa_events e

1897: If (P_task_id Is NULL )
1898: Then
1899: SELECT NVL(max(event_num),0)+1
1900: INTO P_event_in_rec.p_event_number
1901: FROM pa_events e
1902: WHERE e.project_id = P_project_id
1903: AND e.task_id IS NULL;
1904: Else
1905: --generating event number for task level events

Line 1908: FROM pa_events e

1904: Else
1905: --generating event number for task level events
1906: SELECT NVL(max(event_num),0)+1
1907: INTO P_event_in_rec.p_event_number
1908: FROM pa_events e
1909: WHERE e.project_id =P_project_id
1910: AND e.task_id = P_task_id;
1911: End If;
1912: --If task number is the same defaulting the event number.

Line 1916: FROM pa_events e

1912: --If task number is the same defaulting the event number.
1913: Else
1914: SELECT event_num
1915: INTO P_event_in_rec.p_event_number
1916: FROM pa_events e
1917: Where event_id=p_event_in_rec.P_event_id;
1918: End If;
1919: Else
1920: SELECT event_num

Line 1922: FROM pa_events e

1918: End If;
1919: Else
1920: SELECT event_num
1921: INTO P_event_in_rec.p_event_number
1922: FROM pa_events e
1923: Where event_id=p_event_in_rec.P_event_id;
1924: End If; /* If p_event_in_rec.p_task_number is NOT NULL */
1925: End If; /* If event_num is null , '^' */
1926:

Line 1930: From pa_events

1926:
1927: --Populating the rowid
1928: Select Rowid
1929: Into rowid
1930: From pa_events
1931: Where event_id=p_event_in_rec.p_event_id;
1932:
1933: --Defaulting bill_hold_flag,adjusting_revenue_flag.
1934: Select decode(p_event_in_rec.P_bill_hold_flag

Line 2068: From pa_events

2064: ,l_record_version_number
2065: ,l_bill_trans_bill_amt /* Added for bug 4093948 */
2066: ,l_bill_trans_rev_amt /* Added for bug 4093948 */
2067:
2068: From pa_events
2069: Where event_id=p_event_in_rec.P_event_id;
2070:
2071: --Unless the user updates with a valid description the
2072: --description gets defaulted with the event type.

Line 2345: FROM pa_events ev

2341: ,p_event_in_rec.P_reference8
2342: ,p_event_in_rec.P_reference9
2343: ,p_event_in_rec.P_reference10
2344: ,P_agreement_id
2345: FROM pa_events ev
2346: WHERE event_id = p_event_in_rec.p_event_id;
2347:
2348: PA_EVENTS_PKG.Update_Row
2349: (X_Rowid =>Rowid

Line 2348: PA_EVENTS_PKG.Update_Row

2344: ,P_agreement_id
2345: FROM pa_events ev
2346: WHERE event_id = p_event_in_rec.p_event_id;
2347:
2348: PA_EVENTS_PKG.Update_Row
2349: (X_Rowid =>Rowid
2350: ,X_Event_Id =>p_event_in_rec.P_event_id
2351: ,X_Task_Id =>p_task_id
2352: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2590: FROM pa_events ev

2586: ,p_event_in_rec.P_reference8
2587: ,p_event_in_rec.P_reference9
2588: ,p_event_in_rec.P_reference10
2589: ,P_agreement_id
2590: FROM pa_events ev
2591: WHERE event_id = p_event_in_rec.p_event_id;
2592:
2593: PA_EVENTS_PKG.Update_Row
2594: (X_Rowid =>Rowid

Line 2593: PA_EVENTS_PKG.Update_Row

2589: ,P_agreement_id
2590: FROM pa_events ev
2591: WHERE event_id = p_event_in_rec.p_event_id;
2592:
2593: PA_EVENTS_PKG.Update_Row
2594: (X_Rowid =>Rowid
2595: ,X_Event_Id =>p_event_in_rec.P_event_id
2596: ,X_Task_Id =>p_task_id
2597: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2683: PA_EVENTS_PKG.Update_Row

2679: /* Code added for Bug 7110782 - ends */
2680:
2681: ELSE
2682: --Calls table handler for updating valid events.
2683: PA_EVENTS_PKG.Update_Row
2684: (X_Rowid =>Rowid
2685: ,X_Event_Id =>p_event_in_rec.P_event_id
2686: ,X_Task_Id =>p_task_id
2687: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2915: -- PA_EVENTS_PKG.DELETE_ROW

2911: --Called subprograms:
2912: --Called subprograms: PA_EVENT_PVT.CHECK_MDTY_PARAMS1
2913: -- PA_EVENT_PVT.CHECK_MDTY_PARAMS2
2914: -- PA_EVENT_PVT.CHECK_DELETE_EVENT_OK
2915: -- PA_EVENTS_PKG.DELETE_ROW
2916: --
2917: --
2918: --
2919: --History:

Line 3068: --If validation is successful then delete the event from PA_EVENTS

3064:
3065: End If;
3066:
3067:
3068: --If validation is successful then delete the event from PA_EVENTS
3069:
3070: --Populating the rowid
3071: Select Rowid
3072: Into p_rowid

Line 3073: From pa_events

3069:
3070: --Populating the rowid
3071: Select Rowid
3072: Into p_rowid
3073: From pa_events
3074: Where event_id=l_event_id_out;
3075:
3076:
3077: --Log Message

Line 3087: PA_EVENTS_PKG.Delete_Row(X_Rowid => P_rowid);

3083:
3084: --calling PROCEDURE Delete_Row to delete the event
3085:
3086:
3087: PA_EVENTS_PKG.Delete_Row(X_Rowid => P_rowid);
3088:
3089: --If commit is set to true then commit to database.
3090: IF FND_API.to_boolean( p_commit )
3091: THEN