1 PACKAGE INV_MGD_MVT_DEF_ATTR AS
2 /* $Header: INVDEFSS.pls 120.0 2005/05/25 05:07:05 appldev noship $ */
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_return_status return status
44 -- x_msg_count number of messages in the list
45 -- x_msg_data message text
46 -- COMMENT : This is the callout procedure which is called before
47 -- inserting records into MVt Stats table to default some of the
48 -- attributes if the user wanted to define their own values.
49 --========================================================================
50
51 PROCEDURE Default_Attr
52 ( p_api_version_number IN NUMBER
53 , p_init_msg_list IN VARCHAR2
54 , p_movement_transaction IN
55 Inv_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
56 , x_transaction_nature IN OUT NOCOPY VARCHAR2
57 , x_delivery_terms IN OUT NOCOPY VARCHAR2
58 , x_area IN OUT NOCOPY VARCHAR2
59 , x_port IN OUT NOCOPY VARCHAR2
60 , x_csa_code IN OUT NOCOPY VARCHAR2
61 , x_oil_reference_code IN OUT NOCOPY VARCHAR2
62 , x_container_type_code IN OUT NOCOPY VARCHAR2
63 , x_flow_indicator_code IN OUT NOCOPY VARCHAR2
64 , x_affiliation_reference_code IN OUT NOCOPY VARCHAR2
65 , x_taric_code IN OUT NOCOPY VARCHAR2
66 , x_preference_code IN OUT NOCOPY VARCHAR2
67 , x_statistical_procedure_code IN OUT NOCOPY VARCHAR2
68 , x_transport_mode IN OUT NOCOPY VARCHAR2
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 --========================================================================
75 -- PROCEDURE : Default_Value
76 -- PARAMETERS: p_api_version_number known api version
77 -- p_init_msg_list FND_API.G_TRUE to reset list
78 -- p_movement_transaction IN Movement Statistics Record Type
79 -- x_document_unit_price IN OUT Unit price on SO/PO
80 -- x_document_line_ext_value IN OUT Line value on SO/PO
81 -- x_movement_amount IN OUT Movement amount
82 -- x_stat_ext_value IN OUT Statistics value
83 -- x_return_status return status
84 -- x_msg_count number of messages in the list
85 -- x_msg_data message text
86 -- COMMENT : This is the callout procedure which is called before
87 -- inserting records into MVt Stats table to default some of the
88 -- values if the user wanted to define their own.
89 --========================================================================
90
91 PROCEDURE Default_Value
92 ( p_api_version_number IN NUMBER
93 , p_init_msg_list IN VARCHAR2
94 , p_movement_transaction IN
95 Inv_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
96 , x_document_unit_price IN OUT NOCOPY NUMBER
97 , x_document_line_ext_value IN OUT NOCOPY NUMBER
98 , x_movement_amount IN OUT NOCOPY NUMBER
99 , x_stat_ext_value IN OUT NOCOPY NUMBER
100 , x_return_status OUT NOCOPY VARCHAR2
101 , x_msg_count OUT NOCOPY NUMBER
102 , x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105
106
107 END INV_MGD_MVT_DEF_ATTR;