1 PACKAGE RCV_INTRANSIT_SV AUTHID CURRENT_USER as
2 /* $Header: RCVSHINS.pls 120.1 2005/06/14 18:13:26 wkunz noship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_ITEMS_SV2
5
6 DESCRIPTION: This package contains the server side Shipment related
7 functions for v10 char mode. This must be a separate
8 file because it acts as a prereq for the pocso.opc
9 Create Internal Sales order process
10
11 CLIENT/SERVER: Server
12
13 OWNER: George Kellner
14
15 PROCEDURE NAMES: get_expected_shipped_date
16
17 ===========================================================================*/
18
19
20 /*===========================================================================
21 PROCEDURE NAME: get_expected_shipped_date
22
23 DESCRIPTION: Obtain the exepected shipped date for an internal
24 req to sales order creation (Create internal sales
25 order routine.) so that the shipped date is offset
26 by the INTRANSIT LEAD TIME for the ship to org
27
28 PARAMETERS: X_from_organization_id IN NUMBER
29 X_to_organization_id IN NUMBER
30 X_need_by_date IN DATE
31 X_req_line_id IN NUMBER
32
33
34 DESIGN REFERENCES:
35
36 ALGORITHM:
37
38 NOTES:
39
40 OPEN ISSUES:
41
42 CLOSED ISSUES:
43
44 CHANGE HISTORY: GKELLNER 09/22/96 CReATED
45 ===========================================================================*/
46
47 FUNCTION get_expected_shipped_date (
48 X_from_organization_id IN NUMBER,
49 X_to_organization_id IN NUMBER,
50 X_need_by_date IN DATE,
51 X_req_line_id IN NUMBER)
52 RETURN DATE;
53
54 --pragma restrict_references (get_expected_shipped_date,WNDS,RNPS,WNPS);
55
56 FUNCTION rcv_get_org_name (
57 p_source_code IN VARCHAR2,
58 p_vendor_id IN NUMBER,
59 p_org_id IN NUMBER)
60 RETURN VARCHAR2 ;
61
62 --pragma restrict_references (rcv_get_org_name,WNDS,WNPS);
63
64 END RCV_INTRANSIT_SV;