[Home] [Help]
PACKAGE: APPS.OKC_TIME_RES_PUB
Source
1 Package OKC_TIME_RES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPRESS.pls 120.0 2005/05/25 19:03:28 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10 G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12 ---------------------------------------------------------------------------
13 -- GLOBAL MESSAGE CONSTANTS
14 ---------------------------------------------------------------------------
15 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25 ---------------------------------------------------------------------------
26 -- GLOBAL VARIABLES
27 ---------------------------------------------------------------------------
28 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TIME_RES_PVT';
29 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
30 ---------------------------------------------------------------------------
31 -- Procedures and Functions
32 ---------------------------------------------------------------------------
33
34 PROCEDURE Res_Time_Events(
35 x_return_status OUT NOCOPY VARCHAR2,
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 p_cnh_id IN NUMBER,
39 p_coe_id IN NUMBER,
40 p_date IN date);
41
42 PROCEDURE Res_Time_New_K(
43 p_chr_id IN NUMBER,
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 PROCEDURE Res_Time_Extnd_K(
49 p_chr_id IN NUMBER,
50 p_cle_id IN NUMBER,
51 p_start_date IN DATE,
52 p_end_date IN DATE,
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2);
56
57 PROCEDURE Res_Time_Termnt_K(
58 p_chr_id IN NUMBER,
59 p_cle_id IN NUMBER,
60 p_end_date IN DATE,
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 FUNCTION Check_Res_Time_N_tasks(
66 p_tve_id IN NUMBER,
67 p_date IN DATE)
68 return BOOLEAN ;
69
70 PROCEDURE Delete_Res_Time_N_Tasks(
71 p_tve_id IN NUMBER,
72 p_date IN DATE,
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2);
76
77 PROCEDURE Create_Res_Time_N_Tasks(
78 p_tve_id IN NUMBER,
79 p_start_date IN DATE,
80 p_end_date IN DATE,
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2);
84
85 PROCEDURE Batch_Resolve_Time_N_Tasks ;
86 END OKC_TIME_RES_PUB;