1 PACKAGE BODY PSP_PEE_EXT AS
2 /* $Header: PSPEEEXB.pls 120.0 2006/01/31 22:44 dpaudel noship $ */
3 -- WARNING:
4 -- Please note that any PL/SQL statements that cause Commit/Rollback
5 -- are not allowed in the user extension code. Commit/Rollback's
6 -- will interfere with the Commit cycle of the main
7 -- process and Restart/Recover process will not work properly.
8 --
9 -- ------------------------------------------------------
10 Procedure insert_external_eff_line_ext
11 ( p_batch_name in varchar2
12 , p_distribution_date in date
13 , p_person_id in number
14 , p_assignment_id in number
15 , p_currency_code in varchar2
16 , p_distribution_amount in number
17 , p_business_group_id in number
18 , p_set_of_books_id in number
19 , p_gl_code_combination_id in number
20 , p_project_id in number
21 , p_task_id in number
22 , p_award_id in number
23 , p_expenditure_organization_id in number
24 , p_expenditure_type in varchar2
25 , p_attribute_category in varchar2
26 , p_attribute1 in varchar2
27 , p_attribute2 in varchar2
28 , p_attribute3 in varchar2
29 , p_attribute4 in varchar2
30 , p_attribute5 in varchar2
31 , p_attribute6 in varchar2
32 , p_attribute7 in varchar2
33 , p_attribute8 in varchar2
34 , p_attribute9 in varchar2
35 , p_attribute10 in varchar2
36 , p_attribute11 in varchar2
37 , p_attribute12 in varchar2
38 , p_attribute13 in varchar2
39 , p_attribute14 in varchar2
40 , p_attribute15 in varchar2
41 ) IS
42 BEGIN
43 NULL;
44 -- EDIT:Add your code here
45 EXCEPTION
46 WHEN others THEN
47 fnd_msg_pub.add_exc_msg('PSP_PEE_EXT','INSERT_EXTERNAL_EFF_LINE_EXT');
48 raise FND_API.G_EXC_UNEXPECTED_ERROR;
49 END;
50
51 Procedure update_external_eff_line_ext
52 ( p_external_effort_line_id in number
53 , p_batch_name in varchar2
54 , p_distribution_date in date
55 , p_person_id in number
56 , p_assignment_id in number
57 , p_currency_code in varchar2
58 , p_distribution_amount in number
59 , p_business_group_id in number
60 , p_set_of_books_id in number
61 , p_gl_code_combination_id in number
62 , p_project_id in number
63 , p_task_id in number
64 , p_award_id in number
65 , p_expenditure_organization_id in number
66 , p_expenditure_type in varchar2
67 , p_attribute_category in varchar2
68 , p_attribute1 in varchar2
69 , p_attribute2 in varchar2
70 , p_attribute3 in varchar2
71 , p_attribute4 in varchar2
72 , p_attribute5 in varchar2
73 , p_attribute6 in varchar2
74 , p_attribute7 in varchar2
75 , p_attribute8 in varchar2
76 , p_attribute9 in varchar2
77 , p_attribute10 in varchar2
78 , p_attribute11 in varchar2
79 , p_attribute12 in varchar2
80 , p_attribute13 in varchar2
81 , p_attribute14 in varchar2
82 , p_attribute15 in varchar2
83 , p_object_version_number in number
84 )IS
85 BEGIN
86 NULL;
87 -- EDIT:Add your code here
88 EXCEPTION
89 WHEN others THEN
90 fnd_msg_pub.add_exc_msg('PSP_PEE_EXT','UPDATE_EXTERNAL_EFF_LINE_EXT');
91 raise FND_API.G_EXC_UNEXPECTED_ERROR;
92 END;
93
94 Procedure delete_external_eff_line_ext
95 ( p_external_effort_line_id in number
96 , p_object_version_number in number
97 )IS
98 BEGIN
99 NULL;
100 -- EDIT:Add your code here
101 EXCEPTION
102 WHEN others THEN
103 fnd_msg_pub.add_exc_msg('PSP_PEE_EXT','DELETE_EXTERNAL_EFF_LINE_EXT');
104 raise FND_API.G_EXC_UNEXPECTED_ERROR;
105 END;
106
107 END PSP_PEE_EXT;