1 PACKAGE inv_prj_cust_val AUTHID CURRENT_USER AS
2 /* $Header: INVPRJCS.pls 120.2 2005/06/11 14:05:58 appldev $ */
3
4 procedure validate(
5 V_item_id IN number
6 ,V_revision IN varchar2 DEFAULT NULL
7 ,V_org_id IN number
8 ,V_sub_code IN varchar2
9 ,V_locator_id IN number DEFAULT NULL
10 ,V_xfr_org_id IN number DEFAULT NULL
11 ,V_xfr_sub_code IN varchar2 DEFAULT NULL
12 ,V_xfr_locator_id IN number DEFAULT NULL
13 ,V_quantity IN number
14 ,V_txn_type_id IN number
15 ,V_txn_action_id IN number DEFAULT NULL
16 ,V_txn_source_type_id IN number DEFAULT NULL
17 ,V_txn_source_id IN number DEFAULT NULL
18 ,V_txn_source_name IN varchar2 DEFAULT NULL
19 ,V_project_id IN number DEFAULT NULL
20 ,V_task_id IN OUT NOCOPY /* file.sql.39 change */ number
21 ,V_source_project_id IN number DEFAULT NULL
22 ,V_source_task_id IN OUT NOCOPY /* file.sql.39 change */ number
23 ,V_to_project_id IN number DEFAULT NULL
24 ,V_to_task_id IN OUT NOCOPY /* file.sql.39 change */ number
25 ,V_txn_date IN date
26 ,V_pa_expenditure_org_id IN number DEFAULT NULL
27 ,V_expenditure_type IN varchar2 DEFAULT NULL
28 ,V_calling_module IN varchar2
29 ,V_user_id IN number
30 ,V_error_mesg OUT NOCOPY /* file.sql.39 change */ varchar2
31 ,V_warning_mesg OUT NOCOPY /* file.sql.39 change */ varchar2
32 ,V_success_flag OUT NOCOPY /* file.sql.39 change */ number
33 ,V_attribute_category IN varchar2
34 ,V_attribute1 IN varchar2 DEFAULT NULL
35 ,V_attribute2 IN varchar2 DEFAULT NULL
36 ,V_attribute3 IN varchar2 DEFAULT NULL
37 ,V_attribute4 IN varchar2 DEFAULT NULL
38 ,V_attribute5 IN varchar2 DEFAULT NULL
39 ,V_attribute6 IN varchar2 DEFAULT NULL
40 ,V_attribute7 IN varchar2 DEFAULT NULL
41 ,V_attribute8 IN varchar2 DEFAULT NULL
42 ,V_attribute9 IN varchar2 DEFAULT NULL
43 ,V_attribute10 IN varchar2 DEFAULT NULL
44 ,V_attribute11 IN varchar2 DEFAULT NULL
45 ,V_attribute12 IN varchar2 DEFAULT NULL
46 ,V_attribute13 IN varchar2 DEFAULT NULL
47 ,V_attribute14 IN varchar2 DEFAULT NULL
48 ,V_attribute15 IN varchar2 DEFAULT NULL );
49
50 END inv_prj_cust_val;
[Home] [Help]