1 PACKAGE PO_SHIPMENTS_SV10 AS
2 /* $Header: POXPOSAS.pls 120.1 2006/07/27 23:48:02 dreddy noship $*/
3 /*===========================================================================
4 FUNCTION NAME: val_approval_status
5
6 DESCRIPTION: Validates if the shipment needs to be unapproved.
7
8 PARAMETERS: X_shipment_id IN NUMBER,
9 X_shipment_type IN VARCHAR2,
10 X_quantity IN NUMBER,
11 X_amount IN NUMBER,
12 X_ship_to_location_id IN NUMBER,
13 X_promised_date IN DATE,
14 X_need_by_date IN DATE,
15 X_shipment_num IN NUMBER,
16 X_last_accept_date IN DATE,
17 X_taxable_flag IN VARCHAR2,
18 X_ship_to_organization_id IN NUMBER,
19 X_price_discount IN NUMBER,
20 X_price_override IN NUMBER,
21 p_start_date IN DATE DEFAULT NULL, -- <TIMEPHASED FPI>
22 p_end_date IN DATE DEFAULT NULL) -- <TIMEPHASED FPI>
23
24 DESIGN REFERENCES:
25
26 ALGORITHM: Based on document type, look at different
27 database columns to compare the input
28 parameters to.
29
30 NOTES:
31
32 OPEN ISSUES:
33
34 CLOSED ISSUES:
35
36 CHANGE HISTORY: KPOWELL 5/3 Created
37 SIYER 6/7 Changed the return datatype
38 from boolean to number in
39 order to be able to
40 return back a 3-state variable.
41 X_need_to_approve
42 Value Meaning
43 0 No need to re-approve
44 1 Unapprove the document
45 2 Unapprove doc AND shipment.
46
47 ===========================================================================*/
48
49 FUNCTION val_approval_status
50 (X_shipment_id IN NUMBER,
51 X_shipment_type IN VARCHAR2,
52 X_quantity IN NUMBER,
53 X_amount IN NUMBER, -- Bug 5409088
54 X_ship_to_location_id IN NUMBER,
55 X_promised_date IN DATE,
56 X_need_by_date IN DATE,
57 X_shipment_num IN NUMBER,
58 X_last_accept_date IN DATE,
59 X_taxable_flag IN VARCHAR2,
60 X_ship_to_organization_id IN NUMBER,
61 X_price_discount IN NUMBER,
62 X_price_override IN NUMBER,
63 X_tax_code_id IN NUMBER,
64 p_start_date IN DATE DEFAULT NULL, /* <TIMEPHASED FPI> */
65 p_end_date IN DATE DEFAULT NULL, /* <TIMEPHASED FPI> */
66 p_days_early_receipt_allowed IN NUMBER) -- <INBOUND LOGISTICS FPJ>
67 RETURN NUMBER ;
68
69 function get_rcv_routing_name(X_rcv_routing_id IN NUMBER)
70 return varchar2;
71
72
73 /*===========================================================================
74 PROCEDURE NAME: get_shipment_post_query_info
75
76 DESCRIPTION: This procedure bundles serveral server procedures
77 which are invoked in the Shipments block POST_QUERY trigger.
78 This is to optimize the server procedures call and to
79 mininize the network triffic.
80
81 PARAMETERS: See Below
82
83 DESIGN REFERENCES:
84
85 ALGORITHM:
86
87 NOTES:
88
89 OPEN ISSUES:
90
91 CLOSED ISSUES:
92
93 CHANGE HISTORY: WLAU 12/9/96 Created
94
95 ===========================================================================*/
96
97 procedure get_shipment_post_query_info(X_line_location_id IN NUMBER,
98 X_shipment_type IN VARCHAR2,
99 X_item_id IN NUMBER,
100 X_ship_to_org_id IN NUMBER,
101 X_total IN OUT NOCOPY NUMBER,
102 X_total_rtot_db IN OUT NOCOPY NUMBER,
103 X_Original_Date IN OUT NOCOPY DATE,
104 X_item_status IN OUT NOCOPY VARCHAR2,
105 x_project_references_enabled IN OUT NOCOPY NUMBER,
106 x_project_control_level IN OUT NOCOPY NUMBER);
107
108
109 /*===========================================================================
110 PROCEDURE NAME: get_price_update_flag
111
112 DESCRIPTION: This procedure returns a flag (Y/N) which decides
113 whether it is OK to change the price in the shipments
114 block.
115
116 PARAMETERS: See Below
117
118 DESIGN REFERENCES:
119
120 ALGORITHM: The price should not be updatable when the destination
121 type is INVENTORY or SHOPFLOOR. In case of EXPENSE
122 destination, the accrual should be on receipt. In
123 addition there whould be no transaction which affects
124 accounting i.e there should be no receipt or billed
125 quantity against that shipment.
126
127 NOTES:
128
129 OPEN ISSUES:
130
131 CLOSED ISSUES:
132
133 CHANGE HISTORY: GMUDGAL 11/2/98 Created
134
135 ===========================================================================*/
136
137 procedure get_price_update_flag(X_line_location_id IN NUMBER,
138 X_expense_accrual_code in varchar2,
139 X_quantity_received in number,
140 X_quantity_billed in number,
141 X_prevent_price_update_flag in out NOCOPY varchar2) ;
142
143
144 END PO_SHIPMENTS_SV10;