1 package body WIP_CUSTOM_JT_PK as
2 /* $Header: WIPWCJTB.pls 120.2 2011/07/12 23:54:57 tekang ship $ */
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 | This package also contains code to fetch the relevant data
16 | definition of a template when given the template code.
17 | This was added for Bug 11874032, used for fetching the
18 | data definition needed for Job Traveler Templates in MES
19 |
20 | |
21 | |
22 | HISTORY : Kiran Konada
23 | Ted Kang
24 | |
25 *============================================================================*/
26
27 /*---------------------------------------------------------------------------+
28 This procedure can be use to send Custom XML to put into job Traveler. User
29 will also need to customize RTF template to see the data on the PDF Job Traveler
30
31 By default 'has_cxml' returns 'N' which implies no custom xml is present
32
33 If Custom xml is returned user will need to set parameter 'has_cxml' to 'Y'
34
35 Following attributes are for future use
36 in_attr1
37 in_attr2
38 in_attr3
39 out_attr1
40 out_attr2
41 out_attr3
42 +----------------------------------------------------------------------------*/
43
44 Procedure get_jtraveler_cxml(
45 wip_entity_id in number,
46 in_attr1 in varchar2 default null,
47 in_attr2 in varchar2 default null,
48 in_attr3 in varchar2 default null,
49 cxml out nocopy blob,
50 has_cxml out NOCOPY varchar2,
51 x_return_status out nocopy varchar2,
52 xErrorMessage out NOCOPY VARCHAR2,
53 xMessageName out NOCOPY VARCHAR2,
54 xTableName out NOCOPY VARCHAR2,
55 out_attr1 out NOCOPY varchar2,
56 out_attr2 out NOCOPY varchar2,
57 out_attr3 out NOCOPY varchar2)
58 IS
59
60 BEGIN
61 x_return_status := 'S';
62 has_cxml := 'N';
63
64 END get_jtraveler_cxml;
65
66 /*---------------------------------------------------------------------------+
67 This procedure takes in a template code and will return the code of the
68 one data definition that is linked to it.
69
70 +----------------------------------------------------------------------------*/
71 Procedure get_jtraveler_datatemplate(
72 jtrav_template_code in varchar2,
73 jtrav_datatemplate_code out NOCOPY varchar2)
74 IS
75
76 BEGIN
77 SELECT DATADEFS.DATA_SOURCE_CODE INTO jtrav_datatemplate_code
78 FROM XDO_TEMPLATES_B TEMPLATES, XDO_DS_DEFINITIONS_B DATADEFS
79 WHERE TEMPLATES.TEMPLATE_CODE = jtrav_template_code
80 AND TEMPLATES.DATA_SOURCE_CODE = DATADEFS.DATA_SOURCE_CODE;
81
82 END get_jtraveler_datatemplate;
83
84 end WIP_CUSTOM_JT_PK;