1 PACKAGE BODY PATCX AS
2 /* $Header: PAXTTCXB.pls 120.1 2005/08/08 10:51:46 sbharath noship $ */
3
4 PROCEDURE tc_extension (
5 X_project_id IN NUMBER
6 , X_task_id IN NUMBER
7 , X_expenditure_item_date IN DATE
8 , X_expenditure_type IN VARCHAR2
9 , X_non_labor_resource IN VARCHAR2
10 , X_incurred_by_person_id IN NUMBER
11 , X_quantity IN NUMBER DEFAULT NULL
12 , X_denom_currency_code IN VARCHAR2 DEFAULT NULL
13 , X_acct_currency_code IN VARCHAR2 DEFAULT NULL
14 , X_denom_raw_cost IN NUMBER DEFAULT NULL
15 , X_acct_raw_cost IN NUMBER DEFAULT NULL
16 , X_acct_rate_type IN VARCHAR2 DEFAULT NULL
17 , X_acct_rate_date IN DATE DEFAULT NULL
18 , X_acct_exchange_rate IN NUMBER DEFAULT NULL
19 , X_transferred_from_id IN NUMBER DEFAULT NULL
20 , X_incurred_by_org_id IN NUMBER DEFAULT NULL
21 , X_nl_resource_org_id IN NUMBER DEFAULT NULL
22 , X_transaction_source IN VARCHAR2 DEFAULT NULL
23 , X_calling_module IN VARCHAR2 DEFAULT NULL
24 , X_vendor_id IN NUMBER DEFAULT NULL
25 , X_entered_by_user_id IN NUMBER DEFAULT NULL
26 , X_attribute_category IN VARCHAR2 DEFAULT NULL
27 , X_attribute1 IN VARCHAR2 DEFAULT NULL
28 , X_attribute2 IN VARCHAR2 DEFAULT NULL
29 , X_attribute3 IN VARCHAR2 DEFAULT NULL
30 , X_attribute4 IN VARCHAR2 DEFAULT NULL
31 , X_attribute5 IN VARCHAR2 DEFAULT NULL
32 , X_attribute6 IN VARCHAR2 DEFAULT NULL
33 , X_attribute7 IN VARCHAR2 DEFAULT NULL
34 , X_attribute8 IN VARCHAR2 DEFAULT NULL
35 , X_attribute9 IN VARCHAR2 DEFAULT NULL
36 , X_attribute10 IN VARCHAR2 DEFAULT NULL
37 , X_attribute11 IN VARCHAR2 DEFAULT NULL
38 , X_attribute12 IN VARCHAR2 DEFAULT NULL
39 , X_attribute13 IN VARCHAR2 DEFAULT NULL
40 , X_attribute14 IN VARCHAR2 DEFAULT NULL
41 , X_attribute15 IN VARCHAR2 DEFAULT NULL
42 , X_msg_application IN OUT NOCOPY VARCHAR2
43 , X_billable_flag IN OUT NOCOPY VARCHAR2
44 , X_msg_type OUT NOCOPY VARCHAR2
45 , X_msg_token1 OUT NOCOPY VARCHAR2
46 , X_msg_token2 OUT NOCOPY VARCHAR2
47 , X_msg_token3 OUT NOCOPY VARCHAR2
48 , X_msg_count OUT NOCOPY NUMBER
49 , X_outcome OUT NOCOPY VARCHAR2
50 , p_projfunc_currency_code IN VARCHAR2 default null
51 , p_projfunc_cost_rate_type IN VARCHAR2 default null
52 , p_projfunc_cost_rate_date IN DATE default null
53 , p_projfunc_cost_exchg_rate IN NUMBER default null
54 , x_assignment_id IN OUT NOCOPY NUMBER
55 , p_work_type_id IN NUMBER default null
56 , p_sys_link_function IN VARCHAR2 default null
57 , P_Po_Header_Id IN NUMBER default null
58 , P_Po_Line_Id IN NUMBER default null
59 , P_Person_Type IN VARCHAR2 default null
60 , P_Po_Price_Type IN VARCHAR2 default null
61 , P_Document_Type IN VARCHAR2 default null -- Added these for R12
62 , P_Document_Line_Type IN VARCHAR2 default null
63 , P_Document_Dist_Type IN VARCHAR2 default null
64 , P_pa_ref_num1 IN NUMBER default null
65 , P_pa_ref_num2 IN NUMBER default null
66 , P_pa_ref_num3 IN NUMBER default null
67 , P_pa_ref_num4 IN NUMBER default null
68 , P_pa_ref_num5 IN NUMBER default null
69 , P_pa_ref_num6 IN NUMBER default null
70 , P_pa_ref_num7 IN NUMBER default null
71 , P_pa_ref_num8 IN NUMBER default null
72 , P_pa_ref_num9 IN NUMBER default null
73 , P_pa_ref_num10 IN NUMBER default null
74 , P_pa_ref_var1 IN VARCHAR2 default null
75 , P_pa_ref_var2 IN VARCHAR2 default null
76 , P_pa_ref_var3 IN VARCHAR2 default null
77 , P_pa_ref_var4 IN VARCHAR2 default null
78 , P_pa_ref_var5 IN VARCHAR2 default null
79 , P_pa_ref_var6 IN VARCHAR2 default null
80 , P_pa_ref_var7 IN VARCHAR2 default null
81 , P_pa_ref_var8 IN VARCHAR2 default null
82 , P_pa_ref_var9 IN VARCHAR2 default null
83 , P_pa_ref_var10 IN VARCHAR2 default null)
84
85 IS
86 BEGIN
87
88 X_outcome := NULL; -- Initialize output parameter
89 X_msg_type := 'E'; -- Initiliaze Error/Warning indicator parameter
90
91 -- Add your Transaction Control Extensions logic here
92
93 NULL;
94
95 -- Add your Transaction Control Extension logic for Warnings here.
96 -- Always code your warning section last. Before returning set your
97 -- X_msg_type parameter to 'W' for warnings.
98 EXCEPTION
99 WHEN OTHERS THEN
100 -- Add your exception handling logic here
101
102 NULL;
103
104 END tc_extension;
105
106 END PATCX;