[Home] [Help]
PACKAGE: APPS.PA_BILLING_WRKBNCH_EVENTS
Source
1 Package PA_Billing_Wrkbnch_Events as
2 /* $Header: PABWBCHS.pls 120.1 2005/08/19 16:17:32 mwasowic noship $ */
3
4 /*----------------- Private Procedure/Function Declarations -----------------*/
5
6 /*----------------------------------------------------------------------------+
7 | This Private Procedure Get_Next_Event_Num gets the maximum event num + 1 |
8 | for the project and task. |
9 +----------------------------------------------------------------------------*/
10 Procedure Get_Next_Event_Num ( P_Project_ID IN NUMBER,
11 P_Task_ID IN NUMBER,
12 X_Event_Num OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
13
14
15
16 Procedure Check_Event_Action ( P_Project_Id IN NUMBER,
17 P_Task_ID IN NUMBER,
18 P_Event_Num IN NUMBER,
19 P_Event_Id IN NUMBER,
20 P_Event_Action IN VARCHAR2,
21 P_Action_Name IN VARCHAR2,
22 P_Init_Msg_List IN VARCHAR2,
23 P_Event_Num_Chg IN VARCHAR2,
24 P_Rec_Ver_Num IN NUMBER,
25 P_Mcb_Enabled_Flag IN VARCHAR2,
26 P_Pfc_Rate_Date_Code IN VARCHAR2,
27 P_Pc_Rate_Date_Code IN VARCHAR2,
28 P_Fc_Rate_Date_Code IN VARCHAR2,
29 P_Projfunc_Curr_Code IN VARCHAR2,
30 P_Project_Curr_Code IN VARCHAR2,
31 P_Bill_Trans_Curr_Code IN VARCHAR2,
32 P_Pfc_Rate_Type IN VARCHAR2,
33 P_Pc_Rate_Type IN VARCHAR2,
34 P_Fc_Rate_Type IN VARCHAR2,
35 P_Pfc_Rate_Date IN DATE,
36 P_Pc_Rate_Date IN DATE,
37 P_Fc_Rate_Date IN DATE,
38 P_Pfc_Excg_Rate IN NUMBER,
39 P_Pc_Excg_Rate IN NUMBER,
40 P_Fc_Excg_Rate IN NUMBER,
41 P_Event_Type IN VARCHAR2,
42 P_Bill_Txn_Cur IN VARCHAR2,
43 P_Invoice_Amt IN NUMBER,
44 P_Revenue_Amt IN NUMBER,
45 P_Event_Org IN NUMBER,
46 X_Msg_Data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47 X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
48 X_Return_Status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
49
50 Function Check_Delv_Event_Processed ( P_Project_Id IN NUMBER,
51 P_Deliverable_Id IN NUMBER,
52 P_Action_Id IN NUMBER)
53 RETURN VARCHAR2;
54
55 Procedure Delete_Delv_Event ( P_Project_Id IN NUMBER,
56 P_Deliverable_Id IN NUMBER,
57 P_Action_Id IN NUMBER,
58 P_Action_Name IN VARCHAR2,
59 X_Return_Status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60
61 Procedure Get_Proj_Carry_Out_Org ( P_Project_ID IN NUMBER,
62 X_Org_ID OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63 X_Org_Name OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
64
65 Function CHECK_BILLING_EVENT_EXISTS
66 (
67 p_project_id IN pa_projects_all.project_id%TYPE,
68 p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
69 ) RETURN VARCHAR2 ;
70
71 /* Added for bug 3941159 */
72 Procedure Upd_Event_Comp_Date
73 (
74 P_Deliverable_Id IN NUMBER,
75 P_Action_Id IN NUMBER,
76 P_Event_Date IN DATE
77 );
78 /*------------- End of Public Procedure/Function Declarations ----------------*/
79
80 end PA_Billing_Wrkbnch_Events;