1 PACKAGE BODY OE_COPY_UTIL_EXT AS
2 /* $Header: OEXCEXTB.pls 115.1 2004/02/03 23:36:57 mchavan noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_COPY_UTIL_EXT';
5
6 PROCEDURE Copy_Line_DFF
7 ( p_copy_rec IN oe_order_copy_util.copy_rec_type
8 , p_operation IN VARCHAR2
9 , p_ref_line_rec IN OE_Order_PUB.Line_Rec_Type
10 , p_copy_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
11 )
12 IS
13 BEGIN
14
15 -- This is an extension API to allow users to write their own logic on copying
16 -- line level descriptive flexfields. By default, we do not allow users to copy
17 -- the DFF if they are doing a ORDER to RMA copy.
18 -- With this extension API, they will get a chance to copy the DFF for
19 -- Order to RMA copy. Users can even write a selective logic so that only some
20 -- valid attributes are copied over.
21 -- ON copy form if user selects to include the DFF on Lines Tab then
22 -- p_copy_line_rec will have all DFF flex attributes from source line. Otherwise
23 -- they all will get set to FND_API.G_MISS_CHAR.
24 --
25 -- The check-box to include DFF, which is currently not available for Order to
26 -- RMA copy, will be enabled if this extension API is implemented by users (by
27 -- setting the system parameter : COPY_LINE_DFF_EXT_API).
28 --
29 -- These DFF attributes will still be Validated during COPY and if it fails in
30 -- validation then appropriate message will be displayed. Also we will set the
31 -- values to NULL and will indicate to users to enter these values manually
32 -- after copy.
33 --
34 -- Here is a list of attributes on p_copy_rec that can be usefull
35 -- copy_order ->
36 -- VARCHAR2(1) : FND_API.G_TRUE - If New Order/Quote is to be
37 -- created
38 --
39 -- append_to_header_id ->
40 -- NUMBER : Header_id of order, you are adding lines to
41 --
42 -- hdr_type ->
43 -- NUMBER : order_type_id of the destination order.
44 --
45 -- new_phase ->
46 -- VARCHAR2(1) : F if creating a Sales Order. 'N' if creating a Quote.
47 --
48 -- line_type ->
49 -- NUMBER : line_type_id selected on COPY form.
50 --
51 -- line_descflex ->
52 -- VARCHAR2(1) : FND_API.G_TRUE - If user selects to copy line level DFF on
53 -- copy form.
54 --
55 -- Other parameters are:
56 --
57 -- p_operation : VARCHAR2(30) Possible values are
58 -- 'ORDER_TO_RETURN', 'RETURN_TO_ORDER', 'RETURN_TO_RETURN' and 'ORDER_TO_ORDER'
59 -- This indicates how the line category is changing on the specific line record.
60 --
61 -- p_ref_line_rec : It will be populated with the COPY source line record.
62 --
63 NULL;
64
65 END Copy_Line_DFF;
66
67 END OE_COPY_UTIL_EXT;
[Home] [Help]