PACKAGE: APPS.OKC_KEXP_PVT

Source

1 PACKAGE okc_kexp_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKCRKEXS.pls 120.0 2005/05/25 19:38:05 appldev noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- Global Constants and Variables
6   ---------------------------------------------------------------------------
7   G_FND_APP           CONSTANT  VARCHAR2(200) :=  OKC_API.G_FND_APP;
8   G_PKG_NAME          CONSTANT  VARCHAR2(200) := 'OKC_KEXP_REPORT_LOAD';
9   G_APP_NAME          CONSTANT  VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
10   G_UNEXPECTED_ERROR  CONSTANT  VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11   G_SQLERRM_TOKEN     CONSTANT  VARCHAR2(200) := 'SQLerrm';
12   G_SQLCODE_TOKEN     CONSTANT  VARCHAR2(200) := 'SQLcode';
13   G_VIEW              CONSTANT  VARCHAR2(30)  := 'OKC_KEXP_REPORT_V';
14   G_DEF_WHERE         CONSTANT  VARCHAR2(30)  := ' CONTRACT_NUMBER IS NULL';
15 
16   ---------------------------------------------------------------------------
17   -- Procedures and Functions
18   ---------------------------------------------------------------------------
19   PROCEDURE load_ksrch_rows(
20     p_ksearch_where_clause         IN  VARCHAR2 DEFAULT G_DEF_WHERE,
21     x_return_status                OUT NOCOPY VARCHAR2,
22     x_report_id                    OUT NOCOPY NUMBER   );
23 
24   PROCEDURE delete_ksrch_rows(
25     p_from_date                    IN  DATE     DEFAULT NULL,
26     p_to_date                      IN  DATE     DEFAULT NULL,
27     x_return_status                OUT NOCOPY VARCHAR2 );
28 
29   FUNCTION get_salesrep_name (     p_id1  IN  VARCHAR2,
30 							p_id2  IN  VARCHAR2  )
31                              RETURN VARCHAR2;
32 
33 END okc_kexp_pvt;