1 package body WIP_CUSTOM_JT_PK as
2 /* $Header: WIPWCJTB.pls 120.1 2007/12/31 15:56:17 kkonada noship $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : WIPWCJTB.pls |
10 | |
11 | DESCRIPTION : This pcakage is a customization hook to facilitate |
12 | addition of additional customer xml data to be included
13 | in Job traveler.
14 |
15 | |
16 | |
17 | HISTORY : Kiran Konada
18 | |
19 *============================================================================*/
20
21 /*---------------------------------------------------------------------------+
22 This procedure can be use to send Custom XML to put into job Traveler. User
23 will also need to customize RTF template to see the data on the PDF Job Traveler
24
25 By default 'has_cxml' returns 'N' which implies no custom xml is present
26
27 If Custom xml is returned user will need to set parameter 'has_cxml' to 'Y'
28
29 Following attributes are for future use
30 in_attr1
31 in_attr2
32 in_attr3
33 out_attr1
34 out_attr2
35 out_attr3
36 +----------------------------------------------------------------------------*/
37
38 Procedure get_jtraveler_cxml(
39 wip_entity_id in number,
40 in_attr1 in varchar2 default null,
41 in_attr2 in varchar2 default null,
42 in_attr3 in varchar2 default null,
43 cxml out nocopy blob,
44 has_cxml out NOCOPY varchar2,
45 x_return_status out nocopy varchar2,
46 xErrorMessage out NOCOPY VARCHAR2,
47 xMessageName out NOCOPY VARCHAR2,
48 xTableName out NOCOPY VARCHAR2,
49 out_attr1 out NOCOPY varchar2,
50 out_attr2 out NOCOPY varchar2,
51 out_attr3 out NOCOPY varchar2)
52 IS
53
54 BEGIN
55 x_return_status := 'S';
56 has_cxml := 'N';
57
58 END get_jtraveler_cxml;
59
60 end WIP_CUSTOM_JT_PK;