DBA Data[Home] [Help]

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 432: -- inserting the record into pa_events.

428: ,x_log_level => 5);
429: END IF;
430:
431: -- Validating the event num.If found NULL it is populated before
432: -- inserting the record into pa_events.
433: If (p_event_in_rec.P_event_number Is NULL
434: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
435: Then
436: --generating event number for project level events

Line 441: FROM pa_events e

437: If (P_task_id Is NULL)
438: Then
439: SELECT NVL(max(event_num),0)+1
440: INTO P_event_in_rec.p_event_number
441: FROM pa_events e
442: WHERE e.project_id = P_project_id
443: AND e.task_id IS NULL;
444: Else
445: --generating event number for task level events

Line 448: FROM pa_events e

444: Else
445: --generating event number for task level events
446: SELECT NVL(max(event_num),0)+1
447: INTO P_event_in_rec.p_event_number
448: FROM pa_events e
449: WHERE e.project_id =P_project_id
450: AND e.task_id = P_task_id;
451: End If;
452: End If;

Line 866: --Calling PA_EVENTS_PKG.

862:
863: -- Till here
864:
865: --Call to table handler to insert the events into the database
866: --Calling PA_EVENTS_PKG.
867:
868: PA_EVENTS_PKG.Insert_Row
869: (X_Rowid =>rowid
870: ,X_Event_Id =>p_event_in_rec.p_event_id

Line 868: PA_EVENTS_PKG.Insert_Row

864:
865: --Call to table handler to insert the events into the database
866: --Calling PA_EVENTS_PKG.
867:
868: PA_EVENTS_PKG.Insert_Row
869: (X_Rowid =>rowid
870: ,X_Event_Id =>p_event_in_rec.p_event_id
871: ,X_product_code =>p_pm_product_code
872: ,X_event_reference =>p_event_in_rec.p_pm_event_reference

Line 1106: -- pa_events_pkg.update_row

1102: --Called subprograms: PA_EVENT_PVT.CHECK_MDTY_PARAMS1
1103: -- PA_EVENT_PVT.CHECK_MDTY_PARAMS2
1104: -- PA_EVENT_PVT.check_update_event_ok
1105: -- PA_EVENT_PVT.VALIDATE_FLEXFIELD
1106: -- pa_events_pkg.update_row
1107: --
1108: --
1109: --
1110: --History:

Line 1132: p_inv_org_id pa_events.inventory_item_id%type;

1128: Select project_id
1129: From pa_projects_all
1130: Where segment1 = P_project_number;
1131:
1132: p_inv_org_id pa_events.inventory_item_id%type;
1133: P_project_id pa_events.project_id%type;
1134: l_project_id pa_projects_all.project_id%type;
1135: P_task_id pa_events.task_id%type;
1136: l_task_id pa_events.task_id%type;

Line 1133: P_project_id pa_events.project_id%type;

1129: From pa_projects_all
1130: Where segment1 = P_project_number;
1131:
1132: p_inv_org_id pa_events.inventory_item_id%type;
1133: P_project_id pa_events.project_id%type;
1134: l_project_id pa_projects_all.project_id%type;
1135: P_task_id pa_events.task_id%type;
1136: l_task_id pa_events.task_id%type;
1137: P_Organization_Id pa_projects_all.org_id%type;

Line 1135: P_task_id pa_events.task_id%type;

1131:
1132: p_inv_org_id pa_events.inventory_item_id%type;
1133: P_project_id pa_events.project_id%type;
1134: l_project_id pa_projects_all.project_id%type;
1135: P_task_id pa_events.task_id%type;
1136: l_task_id pa_events.task_id%type;
1137: P_Organization_Id pa_projects_all.org_id%type;
1138: l_event_type_classification pa_event_types.event_type_classification%type;
1139: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake

Line 1136: l_task_id pa_events.task_id%type;

1132: p_inv_org_id pa_events.inventory_item_id%type;
1133: P_project_id pa_events.project_id%type;
1134: l_project_id pa_projects_all.project_id%type;
1135: P_task_id pa_events.task_id%type;
1136: l_task_id pa_events.task_id%type;
1137: P_Organization_Id pa_projects_all.org_id%type;
1138: l_event_type_classification pa_event_types.event_type_classification%type;
1139: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1140:

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

1135: P_task_id pa_events.task_id%type;
1136: l_task_id pa_events.task_id%type;
1137: P_Organization_Id pa_projects_all.org_id%type;
1138: l_event_type_classification pa_event_types.event_type_classification%type;
1139: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1140:
1141: P_event_id_out pa_events.event_id%type;
1142: Rowid VARCHAR2(18);
1143: p_event_in_rec Event_Rec_In_Type;

Line 1141: P_event_id_out pa_events.event_id%type;

1137: P_Organization_Id pa_projects_all.org_id%type;
1138: l_event_type_classification pa_event_types.event_type_classification%type;
1139: P_agreement_id pa_events.agreement_id%type; -- Federal Uptake
1140:
1141: P_event_id_out pa_events.event_id%type;
1142: Rowid VARCHAR2(18);
1143: p_event_in_rec Event_Rec_In_Type;
1144: p_event_out_rec Event_Rec_Out_Type;
1145: tot_in_rec NUMBER:=0;

Line 1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;

1146: tot_out_rec NUMBER:=0;
1147: p_api_name VARCHAR2(100):='UPDATE_EVENT';
1148: p_return_msg VARCHAR2(2000);
1149: p_validate_status VARCHAR2(1):='Y';
1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;

Line 1151: l_project_currency_code pa_events.Project_currency_code%type;

1147: p_api_name VARCHAR2(100):='UPDATE_EVENT';
1148: p_return_msg VARCHAR2(2000);
1149: p_validate_status VARCHAR2(1):='Y';
1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;

Line 1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;

1148: p_return_msg VARCHAR2(2000);
1149: p_validate_status VARCHAR2(1):='Y';
1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;

Line 1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;

1149: p_validate_status VARCHAR2(1):='Y';
1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;

Line 1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;

1150: l_bill_trans_curr_code pa_events.Bill_Trans_Currency_Code%type;
1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;

Line 1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;

1151: l_project_currency_code pa_events.Project_currency_code%type;
1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;

Line 1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;

1152: l_Project_Inv_Exchange_Rate pa_events.Project_Inv_Exchange_Rate%type;
1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;

Line 1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;

1153: l_Project_Bill_Amount pa_events.Project_Bill_Amount%type;
1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;

Line 1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;

1154: l_Project_Rev_Rate_date pa_events.Project_Rev_Rate_date%type;
1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;

Line 1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;

1155: l_Project_Rev_Exchange_Rate pa_events.Project_Rev_Exchange_Rate%type;
1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;

Line 1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;

1156: l_Project_Revenue_Amount pa_events.Project_Revenue_Amount%type;
1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;

Line 1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;

1157: l_ProjFunc_Currency_Code pa_events.ProjFunc_Currency_Code%type;
1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;

Line 1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;

1158: l_ProjFunc_Inv_Rate_date pa_events.ProjFunc_Inv_Rate_date%type;
1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;

Line 1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;

1159: l_ProjFunc_Inv_Exchange_Rate pa_events.ProjFunc_Inv_Exchange_Rate%type;
1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;

Line 1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;

1160: l_ProjFunc_Bill_Amount pa_events.ProjFunc_Bill_Amount%type;
1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;

Line 1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;

1161: l_ProjFunc_Rev_Rate_date pa_events.ProjFunc_Rev_Rate_date%type;
1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;

Line 1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;

1162: l_Projfunc_Rev_Exchange_Rate pa_events.Projfunc_Rev_Exchange_Rate%type;
1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;

Line 1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;

1163: l_ProjFunc_Revenue_Amount pa_events.ProjFunc_Revenue_Amount%type;
1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;

Line 1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;

1164: l_Invproc_Currency_Code pa_events.Invproc_Currency_Code%type;
1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;

Line 1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;

1165: l_Invproc_Rate_Type pa_events.Invproc_Rate_Type%type;
1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;

Line 1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;

1166: l_Invproc_Rate_date pa_events.Invproc_Rate_date%type;
1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;

Line 1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;

1167: l_Invproc_Exchange_Rate pa_events.Invproc_Exchange_Rate%type;
1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;

Line 1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;

1168: l_Revproc_Currency_Code pa_events.Revproc_Currency_Code%type;
1169: l_Revproc_Rate_Type pa_events.Revproc_Rate_Type%type;
1170: l_Revproc_Rate_date pa_events.Revproc_Rate_date%type;
1171: l_revproc_exchange_rate pa_events.revproc_exchange_rate%type;
1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1176: l_project_bil_rate_type pa_events.project_rate_type%type;

Line 1176: l_project_bil_rate_type pa_events.project_rate_type%type;

1172: l_Inv_Gen_Rejection_Code pa_events.Inv_Gen_Rejection_Code%type;
1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1176: l_project_bil_rate_type pa_events.project_rate_type%type;
1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;

Line 1177: l_project_bil_rate_date pa_events.project_rate_date%type;

1173: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%type;
1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1176: l_project_bil_rate_type pa_events.project_rate_type%type;
1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;

Line 1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;

1174: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%type;
1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1176: l_project_bil_rate_type pa_events.project_rate_type%type;
1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;

Line 1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;

1175: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%type;
1176: l_project_bil_rate_type pa_events.project_rate_type%type;
1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;

Line 1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;

1176: l_project_bil_rate_type pa_events.project_rate_type%type;
1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;

Line 1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;

1177: l_project_bil_rate_date pa_events.project_rate_date%type;
1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;

Line 1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;

1178: l_project_bil_exchange_rate pa_events.project_exchange_rate%type;
1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;

Line 1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;

1179: l_projfunc_bil_rate_type pa_events.projfunc_rate_type%type;
1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;

Line 1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;

1180: l_projfunc_bil_rate_date pa_events.projfunc_rate_date%type;
1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;

Line 1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;

1181: L_PROJFUNC_BIL_EXCHANGE_RATE pa_events.PROJFUNC_EXCHANGE_RATE%type;
1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;

Line 1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;

1182: L_FUNDING_RATE_TYPE pa_events.FUNDING_RATE_TYPE%type;
1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;

Line 1187: l_description pa_events.description%type;

1183: L_FUNDING_RATE_DATE pa_events.FUNDING_RATE_DATE%type;
1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;

Line 1188: l_bill_hold_flag pa_events.bill_hold_flag%type;

1184: L_FUNDING_EXCHANGE_RATE pa_events.FUNDING_EXCHANGE_RATE%type;
1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;
1192: l_organization_id pa_events.organization_id%type;

Line 1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;

1185: l_bill_trans_rev_amt pa_events.bill_trans_rev_amount%type;
1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;
1192: l_organization_id pa_events.organization_id%type;
1193: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 1190: l_inventory_org_id pa_events.inventory_org_id%type;

1186: l_bill_trans_bill_amt pa_events.bill_trans_bill_amount%type;
1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;
1192: l_organization_id pa_events.organization_id%type;
1193: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1194: l_encoded varchar2(1):='F';

Line 1191: l_inventory_item_id pa_events.inventory_item_id%type;

1187: l_description pa_events.description%type;
1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;
1192: l_organization_id pa_events.organization_id%type;
1193: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1194: l_encoded varchar2(1):='F';
1195: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;

Line 1192: l_organization_id pa_events.organization_id%type;

1188: l_bill_hold_flag pa_events.bill_hold_flag%type;
1189: L_adjusting_revenue_flag pa_events.adjusting_revenue_flag%type;
1190: l_inventory_org_id pa_events.inventory_org_id%type;
1191: l_inventory_item_id pa_events.inventory_item_id%type;
1192: l_organization_id pa_events.organization_id%type;
1193: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1194: l_encoded varchar2(1):='F';
1195: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
1196: l_record_version_number pa_events.record_version_number%TYPE;

Line 1196: l_record_version_number pa_events.record_version_number%TYPE;

1192: l_organization_id pa_events.organization_id%type;
1193: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
1194: l_encoded varchar2(1):='F';
1195: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
1196: l_record_version_number pa_events.record_version_number%TYPE;
1197:
1198: /* Added for bug 7110782 */
1199: l_event_processed varchar2(1) := 'N';
1200: l_bill_amount pa_events.bill_amount%type;

Line 1200: l_bill_amount pa_events.bill_amount%type;

1196: l_record_version_number pa_events.record_version_number%TYPE;
1197:
1198: /* Added for bug 7110782 */
1199: l_event_processed varchar2(1) := 'N';
1200: l_bill_amount pa_events.bill_amount%type;
1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;

Line 1201: l_revenue_amount pa_events.revenue_amount%type;

1197:
1198: /* Added for bug 7110782 */
1199: l_event_processed varchar2(1) := 'N';
1200: l_bill_amount pa_events.bill_amount%type;
1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;

Line 1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;

1198: /* Added for bug 7110782 */
1199: l_event_processed varchar2(1) := 'N';
1200: l_bill_amount pa_events.bill_amount%type;
1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;

Line 1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;

1199: l_event_processed varchar2(1) := 'N';
1200: l_bill_amount pa_events.bill_amount%type;
1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;
1207: l_Calling_Process pa_events.Calling_Process%type;

Line 1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;

1200: l_bill_amount pa_events.bill_amount%type;
1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;
1207: l_Calling_Process pa_events.Calling_Process%type;
1208: /* Added for bug 7110782 */

Line 1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;

1201: l_revenue_amount pa_events.revenue_amount%type;
1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;
1207: l_Calling_Process pa_events.Calling_Process%type;
1208: /* Added for bug 7110782 */
1209:

Line 1206: l_Calling_Place pa_events.Calling_Place%type;

1202: l_revenue_distributed_flag pa_events.revenue_distributed_flag%type;
1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;
1207: l_Calling_Process pa_events.Calling_Process%type;
1208: /* Added for bug 7110782 */
1209:
1210: BEGIN

Line 1207: l_Calling_Process pa_events.Calling_Process%type;

1203: l_rev_dist_rejection_code pa_events.rev_dist_rejection_code%type;
1204: l_Billing_Assignment_Id pa_events.Billing_Assignment_Id%type;
1205: l_Event_Num_Reversed pa_events.Event_Num_Reversed%type;
1206: l_Calling_Place pa_events.Calling_Place%type;
1207: l_Calling_Process pa_events.Calling_Process%type;
1208: /* Added for bug 7110782 */
1209:
1210: BEGIN
1211:

Line 1375: From pa_events

1371:
1372: --Deriving the project_id using the event_reference and product_code
1373: Select project_id, record_version_number
1374: Into P_project_id, p_event_in_rec.P_record_version_number
1375: From pa_events
1376: Where event_id = p_event_in_rec.P_event_id;
1377:
1378:
1379: --Deriving the project_id using the project_number if provided.

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

1404:
1405: --Log Message
1406: IF l_debug_mode = 'Y' THEN
1407: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1408: ,x_msg =>'Defaulting currency from pa_events for the given event'
1409: ,x_log_level =>5);
1410: END IF;
1411:
1412: --Select default currency from pa_events for the given event

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

1408: ,x_msg =>'Defaulting currency from pa_events for the given event'
1409: ,x_log_level =>5);
1410: END IF;
1411:
1412: --Select default currency from pa_events for the given event
1413: --And use those for validations if the currency fields are not
1414: --overwritten by the new changes.
1415: Select ev.Project_currency_code
1416: ,ev.ProjFunc_Inv_Rate_date

Line 1481: From pa_events ev

1477: ,l_funding_rate_type
1478: ,l_funding_rate_date
1479: ,l_funding_exchange_rate
1480: ,l_bill_trans_curr_code
1481: From pa_events ev
1482: Where event_id=p_event_in_rec.p_event_id;
1483:
1484: Select multi_currency_billing_flag
1485: ,funding_rate_date_code

Line 1633: From pa_events

1629: ,p_event_in_rec.P_attribute7
1630: ,p_event_in_rec.P_attribute8
1631: ,p_event_in_rec.P_attribute9
1632: ,p_event_in_rec.P_attribute10
1633: From pa_events
1634: Where event_id=p_event_in_rec.P_event_id;
1635:
1636: Else
1637: p_event_in_rec.P_desc_flex_name :=NULL;

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

1904:
1905:
1906: -- Validating the event num.
1907: --If task number has been changed then generate new event_num
1908: --before inserting the record into pa_events.
1909: If (p_event_in_rec.P_event_number Is NULL
1910: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1911: Then
1912: SELECT task_id

Line 1914: FROM pa_events e

1910: OR p_event_in_rec.P_event_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1911: Then
1912: SELECT task_id
1913: INTO l_task_id
1914: FROM pa_events e
1915: Where event_id=p_event_in_rec.P_event_id;
1916:
1917: --Validating if the existing task_id matches with the updated task_id
1918: --In case of any mismatch new event_number is generated before updating the record.

Line 1928: FROM pa_events e

1924: If (P_task_id Is NULL )
1925: Then
1926: SELECT NVL(max(event_num),0)+1
1927: INTO P_event_in_rec.p_event_number
1928: FROM pa_events e
1929: WHERE e.project_id = P_project_id
1930: AND e.task_id IS NULL;
1931: Else
1932: --generating event number for task level events

Line 1935: FROM pa_events e

1931: Else
1932: --generating event number for task level events
1933: SELECT NVL(max(event_num),0)+1
1934: INTO P_event_in_rec.p_event_number
1935: FROM pa_events e
1936: WHERE e.project_id =P_project_id
1937: AND e.task_id = P_task_id;
1938: End If;
1939: --If task number is the same defaulting the event number.

Line 1943: FROM pa_events e

1939: --If task number is the same defaulting the event number.
1940: Else
1941: SELECT event_num
1942: INTO P_event_in_rec.p_event_number
1943: FROM pa_events e
1944: Where event_id=p_event_in_rec.P_event_id;
1945: End If;
1946: Else
1947: SELECT event_num

Line 1949: FROM pa_events e

1945: End If;
1946: Else
1947: SELECT event_num
1948: INTO P_event_in_rec.p_event_number
1949: FROM pa_events e
1950: Where event_id=p_event_in_rec.P_event_id;
1951: End If; /* If p_event_in_rec.p_task_number is NOT NULL */
1952: End If; /* If event_num is null , '^' */
1953:

Line 1957: From pa_events

1953:
1954: --Populating the rowid
1955: Select Rowid
1956: Into rowid
1957: From pa_events
1958: Where event_id=p_event_in_rec.p_event_id;
1959:
1960: --Defaulting bill_hold_flag,adjusting_revenue_flag.
1961: Select decode(p_event_in_rec.P_bill_hold_flag

Line 2095: From pa_events

2091: ,l_record_version_number
2092: ,l_bill_trans_bill_amt /* Added for bug 4093948 */
2093: ,l_bill_trans_rev_amt /* Added for bug 4093948 */
2094:
2095: From pa_events
2096: Where event_id=p_event_in_rec.P_event_id;
2097:
2098: --Unless the user updates with a valid description the
2099: --description gets defaulted with the event type.

Line 2372: FROM pa_events ev

2368: ,p_event_in_rec.P_reference8
2369: ,p_event_in_rec.P_reference9
2370: ,p_event_in_rec.P_reference10
2371: ,P_agreement_id
2372: FROM pa_events ev
2373: WHERE event_id = p_event_in_rec.p_event_id;
2374:
2375: --Added the below call for bug 7513054
2376: l_Bill_Trans_rev_Amt := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(l_Bill_Trans_rev_Amt,p_event_in_rec.P_bill_trans_currency_code);

Line 2379: PA_EVENTS_PKG.Update_Row

2375: --Added the below call for bug 7513054
2376: l_Bill_Trans_rev_Amt := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(l_Bill_Trans_rev_Amt,p_event_in_rec.P_bill_trans_currency_code);
2377:
2378:
2379: PA_EVENTS_PKG.Update_Row
2380: (X_Rowid =>Rowid
2381: ,X_Event_Id =>p_event_in_rec.P_event_id
2382: ,X_Task_Id =>p_task_id
2383: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2621: FROM pa_events ev

2617: ,p_event_in_rec.P_reference8
2618: ,p_event_in_rec.P_reference9
2619: ,p_event_in_rec.P_reference10
2620: ,P_agreement_id
2621: FROM pa_events ev
2622: WHERE event_id = p_event_in_rec.p_event_id;
2623:
2624: --Added the below call for bug 7513054
2625: l_Bill_Trans_Bill_Amt := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(l_Bill_Trans_Bill_Amt,p_event_in_rec.P_bill_trans_currency_code);

Line 2628: PA_EVENTS_PKG.Update_Row

2624: --Added the below call for bug 7513054
2625: l_Bill_Trans_Bill_Amt := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(l_Bill_Trans_Bill_Amt,p_event_in_rec.P_bill_trans_currency_code);
2626:
2627:
2628: PA_EVENTS_PKG.Update_Row
2629: (X_Rowid =>Rowid
2630: ,X_Event_Id =>p_event_in_rec.P_event_id
2631: ,X_Task_Id =>p_task_id
2632: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2724: PA_EVENTS_PKG.Update_Row

2720: l_Bill_Trans_Bill_Amt := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(l_Bill_Trans_Bill_Amt,p_event_in_rec.P_bill_trans_currency_code);
2721:
2722:
2723: --Calls table handler for updating valid events.
2724: PA_EVENTS_PKG.Update_Row
2725: (X_Rowid =>Rowid
2726: ,X_Event_Id =>p_event_in_rec.P_event_id
2727: ,X_Task_Id =>p_task_id
2728: ,X_Event_Num =>p_event_in_rec.p_event_number

Line 2957: -- PA_EVENTS_PKG.DELETE_ROW

2953: --Called subprograms:
2954: --Called subprograms: PA_EVENT_PVT.CHECK_MDTY_PARAMS1
2955: -- PA_EVENT_PVT.CHECK_MDTY_PARAMS2
2956: -- PA_EVENT_PVT.CHECK_DELETE_EVENT_OK
2957: -- PA_EVENTS_PKG.DELETE_ROW
2958: --
2959: --
2960: --
2961: --History:

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

3106:
3107: End If;
3108:
3109:
3110: --If validation is successful then delete the event from PA_EVENTS
3111:
3112: --Populating the rowid
3113: Select Rowid
3114: Into p_rowid

Line 3115: From pa_events

3111:
3112: --Populating the rowid
3113: Select Rowid
3114: Into p_rowid
3115: From pa_events
3116: Where event_id=l_event_id_out;
3117:
3118:
3119: --Log Message

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

3125:
3126: --calling PROCEDURE Delete_Row to delete the event
3127:
3128:
3129: PA_EVENTS_PKG.Delete_Row(X_Rowid => P_rowid);
3130:
3131: --If commit is set to true then commit to database.
3132: IF FND_API.to_boolean( p_commit )
3133: THEN