1 PACKAGE PO_SHIPMENTS_SV7 AUTHID CURRENT_USER AS
2 /* $Header: POXPOS7S.pls 115.2 2002/11/26 19:42:51 sbull ship $*/
3
4 /*===========================================================================
5 FUNCTION NAME: get_dest_type_dist
6
7 DESCRIPTION: Checks if there is any distribution
8 that has the destination type as SHOP FLOOR
9 or INVENTORY for a given line_location_id.
10
11 PARAMETERS: See Below
12
13 DESIGN REFERENCES:
14
15 ALGORITHM:
16
17 NOTES:
18
19 OPEN ISSUES:
20
21 CLOSED ISSUES:
22
23 CHANGE HISTORY: SIYER 6/15 Created
24
25 ===========================================================================*/
26 function get_dest_type_dist(X_po_header_id IN number,
27 X_po_line_id IN number,
28 X_line_location_id IN number)
29 return boolean;
30
31 /*===========================================================================
32 PROCEDURE NAME: get_original_date
33
34 DESCRIPTION: Gets the Original Commitment Date that was
35 provided on the shipment. It is the promised date
36 from the archive table.
37
38 PARAMETERS: See Below
39
40 DESIGN REFERENCES:
41
42 ALGORITHM:
43
44 NOTES:
45
46 OPEN ISSUES:
47
48 CLOSED ISSUES:
49
50 CHANGE HISTORY: SIYER 6/15 Created
51
52 ===========================================================================*/
53
54 procedure get_original_date(X_line_location_id IN number,
55 X_Promised_Date IN OUT NOCOPY DATE);
56
57 /*===========================================================================
58 PROCEDURE NAME: get_dist_num
59
60 DESCRIPTION: Gets the total number of distributions
61
62 PARAMETERS: See Below
63
64 DESIGN REFERENCES:
65
66 ALGORITHM:
67
68 NOTES:
69
70 OPEN ISSUES:
71
72 CLOSED ISSUES:
73
74 CHANGE HISTORY: SIYER 6/15 Created
75
76 ===========================================================================*/
77 procedure get_dist_num(X_line_location_id IN number,
78 X_dist_num IN OUT NOCOPY number,
79 X_code_combination_id IN OUT NOCOPY number);
80
81
82 /*===========================================================================
83 PROCEDURE NAME: check_available_quantity
84
85 DESCRIPTION: Checks if there is qty available to be released
86 for a line/shipment combination.
87
88 PARAMETERS: See Below
89
90 DESIGN REFERENCES:
91
92 ALGORITHM:
93
94 NOTES:
95
96 OPEN ISSUES:
97
98 CLOSED ISSUES:
99
100 CHANGE HISTORY: SIYER 6/30 Created
101
102 ===========================================================================*/
103 procedure check_available_quantity(X_source_shipment_id IN NUMBER,
104 X_orig_quantity IN NUMBER,
105 X_quantity IN NUMBER );
106
107 END PO_SHIPMENTS_SV7;