1 PACKAGE INV_VIEW_MTL_TXN AUTHID CURRENT_USER AS
2 /*$Header: INVVTXNS.pls 120.0.12010000.2 2009/04/09 09:16:54 skommine ship $*/
3
4 /*
5 ** --------------------------------------------------------------------------
6 ** Procedure :Get_Decription
7 ** Decription: This procedure accepts the identifiers and returns the
8 ** description for the identifiers. The following columns
9 ** from mtl_material_transactions are passed as input for
10 ** this procedure
11 **
12 ** TRANSACTION_TYPE_ID
13 ** TRANSACTION_ACTION_ID
14 ** COSTED_FLAG
15 ** PM_COST_COLLECTED
16 ** PM_COST_COLLECTOR_GROUP_ID
17 ** TRANSACTION_SOURCE_TYPE_ID
18 ** REASON_ID
19 ** DEPARTMENT_ID
20 ** TRANSFER_ORGANIZATION_ID
21 ** LPN_ID
22 ** CONTENT_LPN_ID
23 ** TRANSFER_LPN_ID
24 ** COST_GROUP_ID
25 ** TRANSFER_COST_GROUP_ID
26 ** INV_ADV_INSTALLED
27 ** PUT_AWAY_STRATEGY_ID
28 ** PUT_AWAY_RULE_ID
29 ** PICK_STRATEGY_ID
30 ** PICK_RULE_ID
31 ** ORGANIZATION_ID
32 ** TRANSFER_OWNING_TP_TYPE
33 ** XFR_OWNING_ORGANIZATION_ID
34 **
35 ** The following are the output columns for the procedure:
36 ** X_RETURN_STATUS :Return Status indicating success,
37 ** error, unexpected error for the procedure
38 ** X_MSG_DATA :if the number of messages in message list
39 ** is 1, contains message text
40 ** X_MSG_COUNT :number of messages in message list
41 ** X_TRANSACTION_TYPE_NAME : Description for TRANSACTION_TYPE_ID
42 ** X_TRANSACTION_ACTION : Description for TRANSACTION_ACTION_ID
43 ** X_COSTED_FLAG_1 : Description for COSTED_FLAG
44 ** X_COSTED_LOOKUP_CODE : Description for COSTED_LOOKUP_CODE
45 ** X_PM_COST_COLLECTED_1 : Description for PM_COST_COLLECTED
46 ** X_PM_COST_COLLECTED_LK_CODE : Description for COSTED_LOOKUP_CODE
47 ** X_TRANSACTION_SOURCE_TYPE_NAME: Description for TRANSACTION_SOURCE_TYPE_ID
48 ** X_TRANSACTION_SOURCE_NAME_DB : Description for TRANSACTION_SOURCE_TYPE_ID
49 ** X_REASON_NAME : Description for REASON_ID
50 ** X_DEPARTMENT_CODE : Description for DEPARTMENT_ID
51 ** X_TRANSFER_ORGANIZATION_NAME : Description for TRANSFER_ORGANIZATION_ID
52 ** X_TRANSFER_LPN : Description for TRANSFER_LPN_ID
53 ** X_CONTENT_LPN : Description for CONTENT_LPN_ID
54 ** X_LPN : Description for LPN_ID
55 ** X_COST_GROUP_NAME : Description for COST_GROUP_ID
56 ** X_TRANSFER_COST_GROUP_NAME : Description for TRANSFER_COST_GROUP_ID
57 ** X_PUT_AWAY_STRATEGY_NAME : Description for PUT_AWAY_STRATEGY_ID
58 ** X_PUT_AWAY_RULE_NAME : Description for PUT_AWAY_RULE_ID
59 ** X_PICK_STRATEGY_NAME : Description for PICK_STRATEGY_ID
60 ** X_PICK_RULE_NAME : Description for PICK_RULE_ID
61 ** X_ORGANIZATION_CODE : Description for ORGANIZATION_ID
62 ** X_OPERATIN_UNIT : Operating Unit for the ORGANIZATION_ID
63 ** X_XFR_OWNING_ORGANIZATION_NAME: Description for XFR_OWNING_ORGANIZATION_ID
64 */
65 PROCEDURE GET_DESCRIPTION(
66 X_RETURN_STATUS OUT NOCOPY VARCHAR2
67 ,X_MSG_DATA OUT NOCOPY VARCHAR2
68 ,X_MSG_COUNT OUT NOCOPY NUMBER
69 ,X_TRANSACTION_TYPE_NAME OUT NOCOPY VARCHAR2
70 ,X_TRANSACTION_ACTION OUT NOCOPY VARCHAR2
71 ,X_COSTED_FLAG_1 OUT NOCOPY VARCHAR2
72 ,X_COSTED_LOOKUP_CODE OUT NOCOPY VARCHAR2
73 ,X_PM_COST_COLLECTED_1 OUT NOCOPY VARCHAR2
74 ,X_PM_COST_COLLECTED_LK_CODE OUT NOCOPY VARCHAR2
75 ,X_TRANSACTION_SOURCE_TYPE_NAME OUT NOCOPY VARCHAR2
76 ,X_TRANSACTION_SOURCE_NAME_DB OUT NOCOPY VARCHAR2
77 ,X_REASON_NAME OUT NOCOPY VARCHAR2
78 ,X_DEPARTMENT_CODE OUT NOCOPY VARCHAR2
79 ,X_TRANSFER_ORGANIZATION_NAME OUT NOCOPY VARCHAR2
80 ,X_TRANSFER_LPN OUT NOCOPY VARCHAR2
81 ,X_CONTENT_LPN OUT NOCOPY VARCHAR2
82 ,X_LPN OUT NOCOPY VARCHAR2
83 ,X_COST_GROUP_NAME OUT NOCOPY VARCHAR2
84 ,X_TRANSFER_COST_GROUP_NAME OUT NOCOPY VARCHAR2
85 ,X_put_away_strategy_name OUT NOCOPY VARCHAR2
86 ,X_put_away_rule_name OUT NOCOPY VARCHAR2
87 ,X_PICK_STRATEGY_NAME OUT NOCOPY VARCHAR2
88 ,X_PICK_RULE_NAME OUT NOCOPY VARCHAR2
89 ,x_owning_organization_name OUT NOCOPY VARCHAR2
90 ,x_supplier OUT NOCOPY VARCHAR2
91 ,x_supplier_site_name OUT NOCOPY VARCHAR2
92 ,X_ORGANIZATION_CODE OUT NOCOPY VARCHAR2
93 ,X_OPERATING_UNIT OUT NOCOPY VARCHAR2
94 ,X_XFR_OWNING_ORGANIZATION_NAME OUT NOCOPY VARCHAR2
95 ,p_TRANSACTION_TYPE_ID IN NUMBER
96 ,p_TRANSACTION_ACTION_ID IN NUMBER
97 ,p_COSTED_FLAG IN VARCHAR2
98 ,p_PM_COST_COLLECTED IN VARCHAR2
99 ,P_PM_COST_COLLECTOR_GROUP_ID IN VARCHAR2
100 ,p_TRANSACTION_SOURCE_TYPE_ID IN NUMBER
101 ,P_REASON_ID IN NUMBER
102 ,p_DEPARTMENT_ID IN NUMBER
103 ,p_TRANSFER_ORGANIZATION_ID IN NUMBER
104 ,p_LPN_ID IN NUMBER
105 ,p_content_lpn_id IN NUMBER
106 ,p_transfer_lpn_id IN NUMBER
107 ,p_COST_GROUP_ID IN NUMBER
108 ,p_TRANSFER_COST_GROUP_ID IN NUMBER
109 ,p_INV_ADV_INSTALLED IN VARCHAR2
110 ,p_put_away_strategy_id IN NUMBER
111 ,p_put_away_rule_id IN NUMBER
112 ,p_pick_strategy_id IN NUMBER
113 ,p_pick_rule_id IN NUMBER
114 ,p_owning_organization_id IN NUMBER
115 ,p_planning_tp_type IN NUMBER
116 ,p_owning_tp_type IN NUMBER
117 ,p_planning_organization_id IN NUMBER
118 ,p_organization_id IN NUMBER DEFAULT NULL
119 ,p_transfer_owning_tp_type IN NUMBER
120 ,p_xfr_owning_organization_id IN NUMBER
121 ) ;
122 PROCEDURE update_mmt_process_cost
123 (
124 p_organization_id number
125 ,p_trans_date_from DATE
126 ,p_trans_date_to DATE
127 ,p_report VARCHAR2 DEFAULT 'T'
128 );
129 END INV_VIEW_MTL_TXN;