1 PACKAGE GMS_BILLING_ADJUSTMENTS AS
2 -- $Header: gmsinads.pls 120.2 2005/12/23 22:12:11 appldev ship $
3
4 p_msg_count NUMBER;
5
6 Procedure PERFORM_REV_BILL_ADJS(X_Adj_Action IN VARCHAR2,
7 X_Calling_Process IN VARCHAR2,
8 X_Award_Project_Id IN NUMBER DEFAULT NULL,
9 X_Draft_Invoice_Num IN NUMBER DEFAULT NULL,
10 X_Start_Award_Project_Number IN VARCHAR2 DEFAULT NULL,
11 X_End_Award_Project_Number IN VARCHAR2 DEFAULT NULL,
12 X_Mass_Gen_Flag IN VARCHAR2 DEFAULT NULL,
13 X_Adj_Amount IN NUMBER DEFAULT NULL,
14 RETCODE OUT NOCOPY VARCHAR2,
15 ERRBUF OUT NOCOPY VARCHAR2);
16
17 Procedure DELINV(X_project_id IN NUMBER,
18 X_top_Task_id IN NUMBER DEFAULT NULL,
19 X_calling_process IN VARCHAR2 DEFAULT NULL,
20 X_calling_place IN VARCHAR2 DEFAULT NULL,
21 X_amount IN NUMBER DEFAULT NULL,
22 X_percentage IN NUMBER DEFAULT NULL,
23 X_rev_or_bill_date IN DATE DEFAULT NULL,
24 X_bill_extn_assignment_id IN NUMBER DEFAULT NULL,
25 X_bill_extension_id IN NUMBER DEFAULT NULL,
26 X_request_id IN NUMBER DEFAULT NULL);
27
28 Procedure CANINV(X_project_id IN NUMBER,
29 X_top_Task_id IN NUMBER DEFAULT NULL,
30 X_calling_process IN VARCHAR2 DEFAULT NULL,
31 X_calling_place IN VARCHAR2 DEFAULT NULL,
32 X_amount IN NUMBER DEFAULT NULL,
33 X_percentage IN NUMBER DEFAULT NULL,
34 X_rev_or_bill_date IN DATE DEFAULT NULL,
35 X_bill_extn_assignment_id IN NUMBER DEFAULT NULL,
36 X_bill_extension_id IN NUMBER DEFAULT NULL,
37 X_request_id IN NUMBER DEFAULT NULL);
38
39 Procedure WRIINV(X_project_id IN NUMBER,
40 X_top_Task_id IN NUMBER DEFAULT NULL,
41 X_calling_process IN VARCHAR2 DEFAULT NULL,
42 X_calling_place IN VARCHAR2 DEFAULT NULL,
43 X_amount IN NUMBER DEFAULT NULL,
44 X_percentage IN NUMBER DEFAULT NULL,
45 X_rev_or_bill_date IN DATE DEFAULT NULL,
46 X_bill_extn_assignment_id IN NUMBER DEFAULT NULL,
47 X_bill_extension_id IN NUMBER DEFAULT NULL,
48 X_request_id IN NUMBER DEFAULT NULL);
49
50 Procedure DELREV(X_project_id IN NUMBER,
51 X_top_Task_id IN NUMBER DEFAULT NULL,
52 X_calling_process IN VARCHAR2 DEFAULT NULL,
53 X_calling_place IN VARCHAR2 DEFAULT NULL,
54 X_amount IN NUMBER DEFAULT NULL,
55 X_percentage IN NUMBER DEFAULT NULL,
56 X_rev_or_bill_date IN DATE DEFAULT NULL,
57 X_bill_extn_assignment_id IN NUMBER DEFAULT NULL,
58 X_bill_extension_id IN NUMBER DEFAULT NULL,
59 X_request_id IN NUMBER DEFAULT NULL);
60
61 -- ## Following procedure, procedure INSERT_BILL_CANCEL is referred in gms_billing.billing_rollback
62
63 PROCEDURE INSERT_BILL_CANCEL(X_Award_Project_Id IN NUMBER,
64 X_Event_Num IN NUMBER,
65 X_Expenditure_item_id IN NUMBER DEFAULT null,
66 X_Adl_Line_No IN NUMBER DEFAULT null,
67 X_Bill_Amount IN NUMBER,
68 X_Calling_Process IN VARCHAR2,
69 X_Burden_Exp_Type IN VARCHAR2 DEFAULT null,
70 X_Burden_Cost_Code IN VARCHAR2 DEFAULT null,
71 X_Creation_Date IN DATE,
72 X_Actual_Project_Id IN NUMBER,
73 X_Actual_Task_Id IN NUMBER,
74 X_Expenditure_Org_Id IN NUMBER,
75 X_Deletion_Date IN DATE,
76 X_Resource_List_Member_Id IN NUMBER DEFAULT null,
77 X_Err_Code IN OUT NOCOPY NUMBER,
78 X_Err_Buff IN OUT NOCOPY VARCHAR2);
79
80 -- ## procedure HANDLE_NET_ZERO_EVENTS is referred in gms_billing.billing_rollback
81 -- ## Added for bug 4594090
82
83 PROCEDURE HANDLE_NET_ZERO_EVENTS (P_AWARD_PROJECT_ID IN NUMBER,
84 P_REQUEST_ID IN NUMBER,
85 P_CALLING_PROCESS IN VARCHAR2);
86
87
88 End GMS_BILLING_ADJUSTMENTS;