DBA Data[Home] [Help]

PACKAGE: APPS.HXT_RETRO_MIX

Source


1 PACKAGE HXT_RETRO_MIX AUTHID CURRENT_USER AS
2 /* $Header: hxtrmix.pkh 120.2.12020000.2 2012/07/04 07:12:43 amnaraya ship $ */
3 --
4 
5 
6 -- Bug 8888777
7 -- Added global variables for IV processing.
8 g_IV_upgrade    VARCHAR2(30);
9 g_IV_format     VARCHAR2(50);
10 g_XIV_TABLE  HXT_OTC_RETRIEVAL_INTERFACE.IV_TABLE;
11 
12 
13 
14 PROCEDURE retro_sum_to_mix (p_batch_id IN NUMBER,
15                       p_tim_id IN NUMBER,
16  		      p_sum_retcode OUT NOCOPY NUMBER,
17                       p_err_buf OUT NOCOPY VARCHAR2);
18 
19 -- Bug 9494444
20 -- Added new procedure to snap details for the dashboard.
21 PROCEDURE snap_retrieval_details(p_batch_id   IN NUMBER,
22                                  p_tim_id     IN NUMBER);
23 
24 
25 FUNCTION batch_line_hours(p_batch_line_id IN NUMBER)
26 RETURN NUMBER;
27 
28 --
29 END hxt_retro_mix;