PACKAGE BODY: APPS.WIP_ICX_ATTACHMENT

Source

1 PACKAGE BODY wip_icx_attachment as
2 /* $Header: WIPICXAB.pls 115.6 2002/11/28 11:33:54 rmahidha ship $ */
3 
4 procedure operation(c_inputs1 in varchar2 default null,
5                         c_inputs2 in varchar2 default null,
6                         c_inputs3 in varchar2 default null,
7                         c_inputs4 in varchar2 default null,
8                         c_inputs5 in varchar2 default null,
9                         c_inputs6 in varchar2 default null,
10                         c_inputs7 in varchar2 default null,
11                         c_inputs8 in varchar2 default null,
12                         c_inputs9 in varchar2 default null,
13                         c_inputs10 in varchar2 default null,
14                         c_outputs1 out nocopy varchar2,
15                         c_outputs2 out nocopy varchar2,
16                         c_outputs3 out nocopy varchar2,
17                         c_outputs4 out nocopy varchar2,
18                         c_outputs5 out nocopy varchar2,
19                         c_outputs6 out nocopy varchar2,
20                         c_outputs7 out nocopy varchar2,
21                         c_outputs8 out nocopy varchar2,
22                         c_outputs9 out nocopy varchar2,
23                         c_outputs10 out nocopy varchar2)is
24 l_entity_name	varchar2(50);
25 
26 begin
27 
28 if icx_sec.validateSession then
29 
30 	if (c_inputs5 is null) then
31 	    l_entity_name := 'WIP_DISCRETE_OPERATIONS';
32 	else
33 	    l_entity_name := 'WIP_REPETITIVE_OPERATIONS';
34 	end if;
35 
36         fnd_webattch.Summary(
37                 function_name=>icx_call.encrypt2('WIP_WIPOPMDF'),
38                 entity_name=>icx_call.encrypt2(l_entity_name),
39                 pk1_value=>icx_call.encrypt2(c_inputs2),
40                 pk2_value=>icx_call.encrypt2(c_inputs3),
41                 pk3_value=>icx_call.encrypt2(c_inputs4),
42                 pk4_value=>icx_call.encrypt2(c_inputs5),
43                 pk5_value=>icx_call.encrypt2(NULL),
44                 from_url=>icx_call.encrypt2(NULL),
45                 query_only=>icx_call.encrypt2('Y'));
46 end if;
47 end;
48 
49 procedure component(c_inputs1 in varchar2 default null,
50                         c_inputs2 in varchar2 default null,
51                         c_inputs3 in varchar2 default null,
52                         c_inputs4 in varchar2 default null,
53                         c_inputs5 in varchar2 default null,
54                         c_inputs6 in varchar2 default null,
55                         c_inputs7 in varchar2 default null,
56                         c_inputs8 in varchar2 default null,
57                         c_inputs9 in varchar2 default null,
58                         c_inputs10 in varchar2 default null,
59                         c_outputs1 out nocopy varchar2,
60                         c_outputs2 out nocopy varchar2,
61                         c_outputs3 out nocopy varchar2,
62                         c_outputs4 out nocopy varchar2,
63                         c_outputs5 out nocopy varchar2,
64                         c_outputs6 out nocopy varchar2,
65                         c_outputs7 out nocopy varchar2,
66                         c_outputs8 out nocopy varchar2,
67                         c_outputs9 out nocopy varchar2,
68   c_outputs10 out nocopy varchar2)is
69 
70 begin
71 
72 if icx_sec.validateSession then
73 	fnd_webattch.Summary
74 		(function_name=>icx_call.encrypt2('WIP_WIPMRMDF'),
75 		entity_name=>icx_call.encrypt2('MTL_SYSTEM_ITEMS'),
76                 pk1_value=>icx_call.encrypt2(c_inputs5),
77                 pk2_value=>icx_call.encrypt2(c_inputs4),
78    		pk3_value=>icx_call.encrypt2(null),
79 		pk4_value=>icx_call.encrypt2(NULL),
80 		pk5_value=>icx_call.encrypt2(NULL),
81 		from_url=>icx_call.encrypt2(NULL),
82 		query_only=>icx_call.encrypt2('Y'));
83 end if;
84 
85 end;
86 
87 
88 end wip_icx_attachment;