PACKAGE: APPS.FLM_EKB_SUMMARY_UTIL

Source

1 PACKAGE FLM_EKB_SUMMARY_UTIL AUTHID CURRENT_USER AS
2 /* $Header: flmeksus.pls 120.3 2011/06/13 20:55:37 hliew noship $ */
3 
4 /*The following function will retrieve the value of document number for EKanban
5 Summary's Page Detail table*/
6 FUNCTION get_doc_num(p_doc_type IN NUMBER,
7                      p_doc_header_id IN NUMBER,
8                      p_doc_detail_id IN NUMBER) RETURN VARCHAR2;
9 
10 /*The following function will retrieve the creation date of document for a kanban card*/
11 FUNCTION get_doc_creation_date(p_doc_type IN NUMBER,
12                      p_doc_header_id IN NUMBER,
13                      p_doc_detail_id IN NUMBER) RETURN VARCHAR2;
14 
15 
16 FUNCTION get_summary_query(p_org_id IN NUMBER,
17                            p_supplier_id IN NUMBER,
18                            p_supplier_site_id IN NUMBER) RETURN VARCHAR2;
19 
20 FUNCTION get_supplier_query(p_org_id IN NUMBER,
21                            p_supplier_id IN NUMBER,
22                            p_supplier_site_id IN NUMBER) RETURN VARCHAR2;
23 
24 FUNCTION get_pull_seq_details_query(p_org_id IN NUMBER) RETURN VARCHAR2;
25 
26 END FLM_EKB_SUMMARY_UTIL;