[Home] [Help]
PACKAGE: APPS.MTL_MOVEMENT_RPT_PKG
Source
1 package MTL_MOVEMENT_RPT_PKG AUTHID CURRENT_USER as
2 /* $Header: INVMVTPS.pls 120.0 2005/05/25 04:28:19 appldev noship $ */
3
4 ------------------------------------------
5 -- Update mtl_movement_statistics table --
6 -- executed in Before Report Trigger --
7 ------------------------------------------
8
9 procedure BEFORE_REPORT_UPDATES
10 (P_USER_ID in number,
11 P_CONC_LOGIN_ID in number,
12 P_PERIOD_NAME in varchar2,
13 P_CONC_REQUEST_ID in number,
14 P_CONC_APPLICATION_ID in number,
15 P_CONC_PROGRAM_ID in number,
16 P_REPORT_OPTION in varchar2,
17 P_MOVEMENT_TYPE in varchar2,
18 P_LEGAL_ENTITY_ID in number,
19 P_REPORT_REFERENCE in number,
20 P_FORMAT_TYPE in varchar2,
21 C_CONVERSION_TYPE in varchar2,
22 C_CONVERSION_OPTION in varchar2,
23 C_SET_OF_BOOKS_ID in number,
24 C_START_DATE in date,
25 C_END_DATE in date,
26 C_CURRENCY_CODE in varchar2);
27
28 ------------------------------------------
29 -- Update mtl_movement_statistics table --
30 -- and mtl_movement_parameters table --
31 -- executed in After Report Trigger --
32 ------------------------------------------
33
34 procedure AFTER_REPORT_UPDATES
35 (P_USER_ID in number,
36 P_CONC_LOGIN_ID in number,
37 P_PERIOD_NAME in varchar2,
38 P_REPORT_OPTION in varchar2,
39 P_MOVEMENT_TYPE in varchar,
40 P_LEGAL_ENTITY_ID in number,
41 P_REPORT_REFERENCE in number,
42 P_FORMAT_TYPE in varchar2,
43 C_START_DATE in date,
44 C_END_DATE in date);
45
46
47 -------------------------------------
48 -- Functions called from the --
49 -- BEFORE REPORT UPDATES procedure --
50 -------------------------------------
51
52 ----------------------------------------
53 -- Exchange Rate Calculation Function --
54 ----------------------------------------
55 function EXCHANGE_RATE_CALC
56 (C_CONVERSION_OPTION varchar2,
57 C_CONVERSION_TYPE varchar2,
58 C_SET_OF_BOOKS_ID number,
59 C_END_DATE date,
60 C_CURRENCY_CODE varchar2,
61 l_currency_code varchar2,
62 l_transaction_date date,
63 l_invoice_id number,
64 l_document_source_type varchar2,
65 l_movement_type varchar2)
66 return number;
67
68 ------------------------------------------
69 -- Conversion Date Calculation Function --
70 ------------------------------------------
71 function CONVERSION_DATE_CALC
72 (C_END_DATE date,
73 C_CONVERSION_OPTION varchar2,
74 C_CURRENCY_CODE varchar2,
75 l_currency_code varchar2,
76 l_transaction_date date,
77 l_invoice_id number,
78 l_document_source_type varchar2,
79 l_movement_type varchar2)
80 return date;
81
82 --------------------------------------
83 -- Unit Weight Calculation Function --
84 --------------------------------------
85 function UNIT_WEIGHT_CALC
86 (l_inventory_item_id number,
87 l_organization_id number,
88 P_LEGAL_ENTITY_ID number)
89 return number;
90
91 ---------------------------------
92 -- Weight Calculation Function --
93 ---------------------------------
94 function WEIGHT_CALC
95 (l_total_weight number,
96 l_inventory_item_id number,
97 l_organization_id number,
98 l_transaction_quantity number,
99 l_transaction_uom_code varchar2,
100 P_LEGAL_ENTITY_ID number,
101 P_FORMAT_TYPE varchar2)
102 return number;
103
104 --------------------------------------
105 -- Date Report Calculation Function --
106 --------------------------------------
107 function REPORT_DATE_CALC
108 (l_invoice_date_reference date,
109 l_transaction_date date)
110 return date;
111
112 -----------------------------------------------------------------------------
113 -- Define pragmas to declare that the functions are pure and hence will
114 -- not alter the package state.
115 -----------------------------------------------------------------------------
116 PRAGMA RESTRICT_REFERENCES(EXCHANGE_RATE_CALC, WNDS, WNPS);
117 PRAGMA RESTRICT_REFERENCES(CONVERSION_DATE_CALC, WNDS, WNPS);
118 PRAGMA RESTRICT_REFERENCES(UNIT_WEIGHT_CALC, WNDS, WNPS);
119 PRAGMA RESTRICT_REFERENCES(WEIGHT_CALC, WNDS, WNPS);
120 PRAGMA RESTRICT_REFERENCES(REPORT_DATE_CALC, WNDS, WNPS);
121
122
123 end MTL_MOVEMENT_RPT_PKG;