[Home] [Help]
PACKAGE: APPS.PA_BILL_WORKBENCH_INVOICE
Source
1 PACKAGE pa_bill_workbench_invoice AUTHID CURRENT_USER AS
2 /*$Header: PABWINVS.pls 120.1 2005/08/19 16:17:39 mwasowic noship $ */
3
4
5 PROCEDURE get_inv_global_value(p_project_id IN NUMBER,
6 p_draft_inv_num IN NUMBER,
7 x_mcb_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8 x_user_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9 x_login_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10 x_person_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
11 x_yes_m OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12 x_no_m OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13 x_na_m OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
14 x_employee_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
15 X_fs_approve OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 X_prj_closed_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 x_dist_warn_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
18 x_org_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
19 x_multi_cust_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 );
24
25
26 PROCEDURE Approve_info_commit
27 ( p_project_id IN NUMBER,
28 p_draft_invoice_num IN NUMBER,
29 P_user_id IN NUMBER,
30 p_person_id IN NUMBER,
31 p_login_id IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
34 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35 );
36
37
38 PROCEDURE Get_invoice_mode
39 ( p_project_id IN NUMBER,
40 p_draft_invoice_num IN NUMBER,
41 p_inv_line_num IN NUMBER,
42 p_event_task_id IN NUMBER,
43 p_event_num IN NUMBER,
44 p_retn_inv_flag IN VARCHAR2,
45 p_inv_items_line_type IN VARCHAR2,
46 x_invoice_mode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
49 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 );
51
52 Procedure Validate_Approval ( P_Project_ID in number,
53 P_Draft_Invoice_Num in number,
54 P_Validation_Level in varchar2,
55 X_Error_Message_Code out NOCOPY varchar2 ); --File.Sql.39 bug 4440895
56
57 PROCEDURE validate_multi_Customer ( P_Invoice_Set_ID in number,
58 X_Error_Message_Code out NOCOPY varchar2); --File.Sql.39 bug 4440895
59
60 Procedure Validate_multi_invoices ( P_Project_ID in number,
61 P_invoice_set_Id in number,
62 P_Validation_Level in varchar2,
63 X_Error_Message_Code out NOCOPY varchar2 ); --File.Sql.39 bug 4440895
64
65 PROCEDURE Approve_multi_commit
66 ( p_project_id IN NUMBER,
67 p_invoice_set_id IN NUMBER,
68 P_user_id IN NUMBER,
69 p_person_id IN NUMBER,
70 p_login_id IN NUMBER,
71 x_app_draft_num OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
72 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
74 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75 );
76 END pa_bill_workbench_invoice;