PACKAGE: APPS.MSC_X_PEGGING_FUNC

Source

1 PACKAGE MSC_X_PEGGING_FUNC AS
2 /*  $Header: MSCXPEGS.pls 120.1 2005/06/07 23:29:50 appldev  $ */
3 
4    FUNCTION get_receipt_date (arg_transid IN NUMBER) RETURN date;
5 
6    FUNCTION get_days_late (arg_transid IN NUMBER) RETURN NUMBER;
7 
8    FUNCTION get_max_late (arg_transid IN NUMBER) RETURN NUMBER;
9 
10    FUNCTION get_qty_ontime (arg_transid IN NUMBER) RETURN NUMBER;
11 
12    FUNCTION get_qty_late (arg_transid IN NUMBER) RETURN NUMBER;
13 
14    FUNCTION get_intransit (arg_transid IN NUMBER) RETURN NUMBER;
15 
16    FUNCTION get_uncommitted (arg_transid IN NUMBER) RETURN NUMBER;
17 
18    FUNCTION get_child_num (arg_transid IN NUMBER) RETURN NUMBER  ;
19 
20    FUNCTION get_transids (arg_transid IN NUMBER, arg_binder IN VARCHAR2) RETURN VARCHAR2 ;
21 
22    FUNCTION get_immediate_po (arg_transid IN NUMBER, arg_order_type IN NUMBER) RETURN NUMBER;
23 
24 
25 
26 
27 
28 /*   FUNCTION get_valid_transid(arg_transid IN NUMBER) RETURN NUMBER;
29 
30    FUNCTION get_date_excep(arg_transid IN NUMBER) RETURN VARCHAR2 ;
31 
32    FUNCTION get_date_excep_short(arg_transid IN NUMBER) RETURN VARCHAR2  ;
33 
34    FUNCTION get_display_date(arg_transid IN NUMBER, arg_pos IN NUMBER) RETURN DATE;
35 
36    FUNCTION get_graph_value (arg_transid IN NUMBER,
37                              arg_pos IN NUMBER,
38                              arg_field IN VARCHAR2) RETURN VARCHAR2 ;
39 
40    FUNCTION get_transids (arg_transid IN NUMBER, arg_binder IN VARCHAR2) RETURN VARCHAR2 ;
41 
42    FUNCTION get_scheduled_qty(arg_transid IN NUMBER) RETURN VARCHAR2 ;
43 
44    FUNCTION get_child_num (arg_transid IN NUMBER) RETURN NUMBER  ;
45 
46    FUNCTION get_excep (arg_transid IN NUMBER,
47                        arg_order_type IN NUMBER,
48                        arg_excep_order IN NUMBER,
49                        arg_excep_type IN NUMBER) RETURN VARCHAR2 ;
50 
51    FUNCTION get_status (arg_transid IN NUMBER) RETURN VARCHAR2 ;
52 
53    FUNCTION get_receipt_date (arg_transid IN NUMBER) RETURN date;
54 */
55 END MSC_X_PEGGING_FUNC ;