1 PACKAGE INV_MGD_MVT_DEF_ATTR AUTHID CURRENT_USER AS
2 /* $Header: INVDEFSS.pls 120.0.12020000.2 2012/07/05 07:26:45 ntungare ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVDEFSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec. of INV_MGD_MVT_DEF_ATTR |
13 --| |
14 --| |
15 --| HISTORY |
16 --| 04/01/2000 pseshadr Created |
17 --| 12/04/2002 vma Default_Attr: added NOCOPY to x_return_sta|
18 --| tus, x_msg_count, x_msg data. Change the |
19 --| other OUT parameters to IN OUT NOCOPY |
20 --| parameters. This is to comply with new |
21 --| PL/SQL standards for better performance. |
22 --| 03/17/2005 yawang Add new program for default movement amt |
23 --| stat_ext_value, document price and vlaue |
24 --+======================================================================*/
25
26 --========================================================================
27 -- PROCEDURE : Default_Attr
28 -- PARAMETERS: p_api_version_number known api version
29 -- p_init_msg_list FND_API.G_TRUE to reset list
30 -- p_movement_transaction IN Movement Statistics Record Type
31 -- x_transaction_nature IN OUT Transaction Nature
32 -- x_delivery_terms IN OUT Delivery Terms
33 -- x_area IN OUT Area where goods arrive/depart
34 -- x_Port IN OUT Port where goods arrive/depart
35 -- x_csa_code IN OUT Csa code
36 -- x_oil_reference_code IN OUT Used in oil industry
37 -- x_container_type_code IN OUT Container Type
38 -- x_flow_indicator_code IN OUT Used in the oil industry
39 -- x_affiliation_reference_code
40 -- x_taric_code IN OUT Taric Code
41 -- x_preference_code IN OUT Preference Code
42 -- x_statistical_procedure_code IN OUT Statistical Procedure Code
43 -- x_attribute1 - x_attribute15 DFF attributes -- bug 13501354
44 -- x_return_status return status
45 -- x_msg_count number of messages in the list
46 -- x_msg_data message text
47 -- COMMENT : This is the callout procedure which is called before
48 -- inserting records into MVt Stats table to default some of the
49 -- attributes if the user wanted to define their own values.
50 --========================================================================
51 --
52 -- bug 13501354
53 -- Added the DFF attributes from attribute1 to attribute15
54 -- as parameters to allow the customer to defalut the DFF values.
55 --
56 PROCEDURE Default_Attr
57 ( p_api_version_number IN NUMBER
58 , p_init_msg_list IN VARCHAR2
59 , p_movement_transaction IN
60 Inv_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
61 , x_transaction_nature IN OUT NOCOPY VARCHAR2
62 , x_delivery_terms IN OUT NOCOPY VARCHAR2
63 , x_area IN OUT NOCOPY VARCHAR2
64 , x_port IN OUT NOCOPY VARCHAR2
65 , x_csa_code IN OUT NOCOPY VARCHAR2
66 , x_oil_reference_code IN OUT NOCOPY VARCHAR2
67 , x_container_type_code IN OUT NOCOPY VARCHAR2
68 , x_flow_indicator_code IN OUT NOCOPY VARCHAR2
69 , x_affiliation_reference_code IN OUT NOCOPY VARCHAR2
70 , x_taric_code IN OUT NOCOPY VARCHAR2
71 , x_preference_code IN OUT NOCOPY VARCHAR2
72 , x_statistical_procedure_code IN OUT NOCOPY VARCHAR2
73 , x_transport_mode IN OUT NOCOPY VARCHAR2
74 , x_attribute1 IN OUT NOCOPY VARCHAR2
75 , x_attribute2 IN OUT NOCOPY VARCHAR2
76 , x_attribute3 IN OUT NOCOPY VARCHAR2
77 , x_attribute4 IN OUT NOCOPY VARCHAR2
78 , x_attribute5 IN OUT NOCOPY VARCHAR2
79 , x_attribute6 IN OUT NOCOPY VARCHAR2
80 , x_attribute7 IN OUT NOCOPY VARCHAR2
81 , x_attribute8 IN OUT NOCOPY VARCHAR2
82 , x_attribute9 IN OUT NOCOPY VARCHAR2
83 , x_attribute10 IN OUT NOCOPY VARCHAR2
84 , x_attribute11 IN OUT NOCOPY VARCHAR2
85 , x_attribute12 IN OUT NOCOPY VARCHAR2
86 , x_attribute13 IN OUT NOCOPY VARCHAR2
87 , x_attribute14 IN OUT NOCOPY VARCHAR2
88 , x_attribute15 IN OUT NOCOPY VARCHAR2
89 , x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT NOCOPY NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 --========================================================================
95 -- PROCEDURE : Default_Value
96 -- PARAMETERS: p_api_version_number known api version
97 -- p_init_msg_list FND_API.G_TRUE to reset list
98 -- p_movement_transaction IN Movement Statistics Record Type
99 -- x_document_unit_price IN OUT Unit price on SO/PO
100 -- x_document_line_ext_value IN OUT Line value on SO/PO
101 -- x_movement_amount IN OUT Movement amount
102 -- x_stat_ext_value IN OUT Statistics value
103 -- x_return_status return status
104 -- x_msg_count number of messages in the list
105 -- x_msg_data message text
106 -- COMMENT : This is the callout procedure which is called before
107 -- inserting records into MVt Stats table to default some of the
108 -- values if the user wanted to define their own.
109 --========================================================================
110
111 PROCEDURE Default_Value
112 ( p_api_version_number IN NUMBER
113 , p_init_msg_list IN VARCHAR2
114 , p_movement_transaction IN
115 Inv_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
116 , x_document_unit_price IN OUT NOCOPY NUMBER
117 , x_document_line_ext_value IN OUT NOCOPY NUMBER
118 , x_movement_amount IN OUT NOCOPY NUMBER
119 , x_stat_ext_value IN OUT NOCOPY NUMBER
120 , x_return_status OUT NOCOPY VARCHAR2
121 , x_msg_count OUT NOCOPY NUMBER
122 , x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125
126
127 END INV_MGD_MVT_DEF_ATTR;
[Home] [Help]