[Home] [Help]
PACKAGE: APPS.OZF_SD_UTIL_PVT
Source
1 package OZF_SD_UTIL_PVT as
2 /* $Header: ozfvsdus.pls 120.7 2008/04/01 09:19:13 mohali noship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_UTIL_PVT
6 -- Purpose :
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11
12 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_UTIL_PVT';
13 --G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdus.pls';
14
15 -- Author : MBHATT
16 -- Created : 11/16/2007 2:39:16 PM
17 -- Purpose :
18
19
20 -- Public function and procedure declarations
21
22
23 ---------------------------------------------------------------------
24 -- FUNCTION
25 -- SD_CONVERT_CURRENCY
26 --
27 -- PURPOSE
28 -- Gets converted currncy amount from request currency to plan currency
29 -- PARAMETERS
30 -- a) p_batch_line_id : batch line Id
31 -- b) p_amount number : amount in request currency
32 --
33 -- NOTES
34 --
35 ----------------------------------------------------------------------
36
37 function SD_CONVERT_CURRENCY(p_batch_line_id number,p_amount number) return number;
38
39
40 ---------------------------------------------------------------------
41 -- PROCEDURE
42 -- SD_AMOUNT_POSTBACK
43 --
44 -- PURPOSE
45 -- Updates OZF_FUNDS_UTILIZED_ALL_B for amount postback
46 -- PARAMETERS
47 -- a) p_batch_line_id : batch line Id
48 -- b) p_amount number : amount in request currency
49 --
50 -- NOTES
51 --
52 ----------------------------------------------------------------------
53
54 PROCEDURE SD_AMOUNT_POSTBACK(p_batch_line_id number, x_return_status OUT NOCOPY VARCHAR2, x_meaning OUT NOCOPY VARCHAR2);
55 PROCEDURE CONVERT_TO_RN_DATE(
56 p_server_date IN DATE,
57 x_rn_date OUT NOCOPY VARCHAR2);
58
59 PROCEDURE CONVERT_TO_DB_DATE(
60 p_rn_date IN VARCHAR2,
61 x_db_date OUT NOCOPY DATE);
62
63
64 ---------------------------------------------------------------------
65 -- PROCEDURE
66 -- UPDATE_SD_REQ_PRICES
67 --
68 -- PURPOSE
69 -- Updates the Ship and Debit price interface table with correct request line iD
70 -- PARAMETERS
71 -- a) p_request_number : The SD Request Number for transaction
72 -- b) p_request_line_id : Correct request line Id
73 --
74 -- NOTES
75 --
76 ----------------------------------------------------------------------
77 PROCEDURE UPDATE_SD_REQ_PRICES(p_request_number IN VARCHAR2,p_request_line_id IN NUMBER);
78
79
80 ---------------------------------------------------------------------
81 -- PROCEDURE
82 -- PROCESS_SD_RESPONSE
83 --
84 -- PURPOSE
85 -- Updates the Ship and Debit header and base tables for the inbound data
86 -- only when the business validation(s) are passed
87 -- The business validation involved are
88 -- a)
89 -- PARAMETERS
90 -- a) p_request_number : The SD Request Number
91 -- b) x_return_status : Return status for the processing
92 -- c) x_msg_data : Error message if the validation errored out
93 -- NOTES
94 --
95 ----------------------------------------------------------------------
96 PROCEDURE PROCESS_SD_RESPONSE(p_request_number IN VARCHAR2
97 , x_return_status OUT nocopy VARCHAR2
98 , x_msg_data OUT nocopy VARCHAR2
99 );
100
101 PROCEDURE CONVERT_TO_RN_TIMEZONE(
102 p_input_date IN DATE,
103 x_utc_date OUT NOCOPY DATE );
104
105
106 PROCEDURE CONVERT_TO_RN_DATETIME(
107 p_server_date IN DATE,
108 x_rn_datetime OUT NOCOPY VARCHAR2);
109
110 ---------------------------------------------------------------------
111 -- PROCEDURE
112 -- UPDATE_SD_REQ_STALE_DATA
113 --
114 -- PURPOSE
115 -- Updates the Ship and Debit interface tables for any stale data
116 --
117 -- PARAMETERS
118 -- a) p_request_number : The SD Request Number
119 -- NOTES
120 --
121 ----------------------------------------------------------------------
122 PROCEDURE UPDATE_SD_REQ_STALE_DATA(p_request_number IN VARCHAR2);
123
124 ---------------------------------------------------------------------
125 -- PROCEDURE
126 -- SD_RAISE_EVENT
127 --
128 -- PURPOSE
129 -- This procedure raises a Business Event based on batch action.
130 --
131 -- PARAMETERS
132 -- a) Batch ID
133 -- b) Batch Action - can be EXPORT,CREATE, RESPONSE and CLAIM.
134 -- NOTES
135 --
136 ----------------------------------------------------------------------
137 PROCEDURE SD_RAISE_EVENT(P_BATCH_ID IN NUMBER,
138 P_BATCH_ACTION IN VARCHAR2,
139 x_return_status OUT NOCOPY VARCHAR2);
140
141
142 end OZF_SD_UTIL_PVT;