1 PACKAGE PO_ORGS_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXCOO1S.pls 115.2 2002/11/25 23:40:55 sbull ship $*/
3 /*===========================================================================
4 PACKAGE NAME: PO_ORGS_SV2
5
6 DESCRIPTION: This package contains source and destination org
7 validation APIs.
8
9 CLIENT/SERVER: Server
10
11 OWNER: Liza Broadbent
12
13 FUNCTION/PROCEDURE: val_source_org()
14 val_dest_org()
15
16
17 ===========================================================================*/
18 /*===========================================================================
19 FUNCTION NAME: val_dest_org()
20
21
22 DESCRIPTION: Validates a destination organization. Returns FALSE
23 if the org is invalid. Note: if the x_source_type
24 parameter is NULL, then this function will not fail
25 for this reason (it handles a NULL source type).
26
27 PARAMETERS: x_destination_org_id in number,
28 x_item_id in number,
29 x_item_revision in varchar2,
30 x_destination_type in varchar2,
31 x_sob_id in number,
32 x_source_type in varchar2
33
34 RETURN VALUE: boolean
35
36
37 ALGORITHM:
38
39 NOTES:
40
41 OPEN ISSUES:
42
43 CLOSED ISSUES:
44
45 CHANGE HISTORY: Liza Broadbent 11-15-95 Created
46
47 ===============================================================================*/
48 function val_dest_org(x_destination_org_id in number,
49 x_item_id in number,
50 x_item_revision in varchar2,
51 x_destination_type in varchar2,
52 x_sob_id in number,
53 x_source_type in varchar2) return boolean;
54
55 /*===========================================================================
56 FUNCTION NAME: val_source_org()
57
58
59 DESCRIPTION: Validates a source organization. Returns FALSE
60 if the org is invalid. It also sets the x_error_type
61 parameter to indicate how the validation failed.
62
63
64 PARAMETERS: x_source_org_id in number,
65 x_destination_org_id in number,
66 x_item_id in number,
67 x_item_revision in varchar2,
68 x_sob_id in number,
69 x_error_type in out varchar2
70
71 RETURN VALUE: boolean
72
73
74 ALGORITHM:
75
76 NOTES:
77
78 OPEN ISSUES:
79
80 CLOSED ISSUES:
81
82 CHANGE HISTORY: Liza Broadbent 11-15-95 Created
83
84 ===============================================================================*/
85 function val_source_org(x_source_org_id in number,
86 x_destination_org_id in number,
87 x_destination_type in varchar2,
88 x_item_id in number,
89 x_item_revision in varchar2,
90 x_sob_id in number,
91 x_error_type in out NOCOPY varchar2) return boolean;
92 END PO_ORGS_SV2;