1 package PA_MERGE_PKG AS
2 /* $Header: PAXTCAMS.pls 120.0 2005/05/29 14:47:59 appldev noship $ */
3
4
5
6 PROCEDURE party_merge(
7 p_entity_name IN VARCHAR2,
8 p_from_id IN NUMBER,
9 x_to_id OUT NOCOPY NUMBER,
10 p_from_fk_id IN NUMBER,
11 p_to_fk_id IN NUMBER,
12 p_parent_entity_name IN VARCHAR2,
13 p_batch_id IN NUMBER,
14 p_batch_party_id IN NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2);
16
17 PROCEDURE control_items_owner_id(
18 p_entity_name IN VARCHAR2,
19 p_from_id IN NUMBER,
20 x_to_id OUT NOCOPY NUMBER,
21 p_from_fk_id IN NUMBER,
22 p_to_fk_id IN NUMBER,
23 p_parent_entity_name IN VARCHAR2,
24 p_batch_id IN NUMBER,
25 p_batch_party_id IN NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2);
27
28 PROCEDURE control_items_last_mod_by_id(
29 p_entity_name IN VARCHAR2,
30 p_from_id IN NUMBER,
31 x_to_id OUT NOCOPY NUMBER,
32 p_from_fk_id IN NUMBER,
33 p_to_fk_id IN NUMBER,
34 p_parent_entity_name IN VARCHAR2,
35 p_batch_id IN NUMBER,
36 p_batch_party_id IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE control_items_closed_by_id(
40 p_entity_name IN VARCHAR2,
41 p_from_id IN NUMBER,
42 x_to_id OUT NOCOPY NUMBER,
43 p_from_fk_id IN NUMBER,
44 p_to_fk_id IN NUMBER,
45 p_parent_entity_name IN VARCHAR2,
46 p_batch_id IN NUMBER,
47 p_batch_party_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2);
49
50 PROCEDURE ci_actions_assigned_to(
51 p_entity_name IN VARCHAR2,
52 p_from_id IN NUMBER,
53 x_to_id OUT NOCOPY NUMBER,
54 p_from_fk_id IN NUMBER,
55 p_to_fk_id IN NUMBER,
56 p_parent_entity_name IN VARCHAR2,
57 p_batch_id IN NUMBER,
58 p_batch_party_id IN NUMBER,
59 x_return_status OUT NOCOPY VARCHAR2);
60
61 PROCEDURE ci_impacts_implemented_by(
62 p_entity_name IN VARCHAR2,
63 p_from_id IN NUMBER,
64 x_to_id OUT NOCOPY NUMBER,
65 p_from_fk_id IN NUMBER,
66 p_to_fk_id IN NUMBER,
67 p_parent_entity_name IN VARCHAR2,
68 p_batch_id IN NUMBER,
69 p_batch_party_id IN NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2);
71
72 PROCEDURE project_parties_res_src_id(
73 p_entity_name IN VARCHAR2,
74 p_from_id IN NUMBER,
75 x_to_id OUT NOCOPY NUMBER,
76 p_from_fk_id IN NUMBER,
77 p_to_fk_id IN NUMBER,
78 p_parent_entity_name IN VARCHAR2,
79 p_batch_id IN NUMBER,
80 p_batch_party_id IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2);
82
83 PROCEDURE update_project_parties_res_id(
84 p_from_resource_id IN NUMBER,
85 p_to_resource_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2);
87
88 end;