1 PACKAGE PO_SOURCING_SV4 AUTHID CURRENT_USER as
2 /* $Header: POXSCS1S.pls 115.2 2002/11/23 01:51:13 sbull ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_SOURCING_SV4
6
7 DESCRIPTION: This package contains the server side Supplier Item
8 Catalog and Sourcing Application Program Interfaces
9 (APIs).
10
11 CLIENT/SERVER: Server
12
13 OWNER: Liza Broadbent
14
15 FUNCTION/PROCEDURE: val_src_dest()
16 get_disposition_message()
17
18
19 ===========================================================================*/
20 /*===========================================================================
21 FUNCTION NAME: get_disposition_message
22
23 DESCRIPTION: Finds the disposition message(s) associated
24 with the item/organization provided. If
25 one or many messages are found, this function
26 return true. If multiple messages are found,
27 the x_multiple_flag is also set to 'Y'
28
29 RETURN VALUE: boolean
30
31
32 PARAMETERS: x_item_id in number,
33 x_org_id in number,
34 x_cross_ref_type in varchar2,
35 x_message in out varchar2,
36 x_multiple_flag in out varchar2
37
38 DESIGN REFERENCES:
39
40 ALGORITHM:
41
42 NOTES:
43
44 OPEN ISSUES:
45
46 CLOSED ISSUES:
47
48 CHANGE HISTORY: Created 15-NOV-95 LBROADBE
49 ===========================================================================*/
50 function get_disposition_message(x_item_id in number,
51 x_org_id in number,
52 x_cross_ref_type in varchar2,
53 x_message in out NOCOPY varchar2,
54 x_multiple_flag in out NOCOPY varchar2) return boolean;
55
56 /*===========================================================================
57 FUNCTION NAME: val_src_dest
58
59 DESCRIPTION:
60
61 RETURN VALUE: boolean
62
63
64 PARAMETERS:
65
66 DESIGN REFERENCES:
67
68 ALGORITHM:
69
70 NOTES:
71
72 OPEN ISSUES:
73
74 CLOSED ISSUES:
75
76 CHANGE HISTORY: Created 15-NOV-95 LBROADBE
77 ===========================================================================*/
78 FUNCTION val_src_dest(x_val_level in varchar2,
79 x_sob_id in number,
80 x_item_id in number,
81 x_item_revision in varchar2,
82 x_ship_to in varchar2,
83 x_receiving in varchar2,
84 x_source_type in out NOCOPY varchar2,
85 x_destination_type in out NOCOPY varchar2,
86 x_destination_org_id in out NOCOPY number,
87 x_destination_loc_id in out NOCOPY number,
88 x_destination_subinventory in out NOCOPY varchar2,
89 x_source_org_id in out NOCOPY number,
90 x_source_subinventory in out NOCOPY varchar2,
91 x_error_type in out NOCOPY varchar2) return boolean;
92
93 END PO_SOURCING_SV4;