[Home] [Help]
PACKAGE: APPS.OKC_TIME_RES_PVT
Source
1 Package OKC_TIME_RES_PVT AS
2 /* $Header: OKCCRESS.pls 120.2 2006/02/24 15:09:35 smallya 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 PICKUP_UPTO_MONTHS NUMBER := 12;
32 RESOLVE_UNTIL_MONTHS NUMBER := 6;
33 ---------------------------------------------------------------------------
34 -- Procedures and Functions
35 ---------------------------------------------------------------------------
36
37 PROCEDURE Res_Time_Events(
38 x_return_status OUT NOCOPY VARCHAR2,
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 p_cnh_id IN NUMBER,
42 p_coe_id IN NUMBER,
43 p_date IN date);
44
45 PROCEDURE Res_Time_New_K(
46 p_chr_id IN NUMBER,
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2);
50
51 PROCEDURE Res_Time_Extnd_K(
52 p_chr_id IN NUMBER,
53 p_cle_id IN NUMBER,
54 p_start_date IN DATE,
55 p_end_date IN DATE,
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60 PROCEDURE Res_Time_Termnt_K(
61 p_chr_id IN NUMBER,
62 p_cle_id IN NUMBER,
63 p_end_date IN DATE,
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2);
67
68 FUNCTION Check_Res_Time_N_tasks(
69 p_tve_id IN NUMBER,
70 p_date IN DATE)
71 return BOOLEAN ;
72
73 PROCEDURE Delete_Res_Time_N_Tasks(
74 p_tve_id IN NUMBER,
75 p_date IN DATE,
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE Create_Res_Time_N_Tasks(
81 p_tve_id IN NUMBER,
82 p_start_date IN DATE,
83 p_end_date IN DATE,
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2);
87
88 PROCEDURE Batch_Resolve_Time_N_Tasks ;
89
90 PROCEDURE time_resolver(errbuf OUT NOCOPY VARCHAR2,
91 retcode OUT NOCOPY VARCHAR2);
92
93 END OKC_TIME_RES_PVT;