DBA Data[Home] [Help]

APPS.OKL_RULE_EXTRACT_PUB dependencies on OKL_API

Line 17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

13:
14: ---------------------------------------------------------------------------
15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

14: ---------------------------------------------------------------------------
15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

15: -- GLOBAL MESSAGE CONSTANTS
16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

16: ---------------------------------------------------------------------------
17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

17: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

18: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

19: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';

Line 24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

20: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';

Line 25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

21: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
29: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
24: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
25: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
26: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
27: G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';
28: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
29: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
30: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

38: G_SCOPE CONSTANT VARCHAR2(4) := '_PUB';
39: -- GLOBAL VARIABLES
40: ---------------------------------------------------------------------------
41: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RULE_EXTRACT_PUB';
42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
43: ---------------------------------------------------------------------------
44: --structures to hold rule code records
45: SUBTYPE rule_rec_type is OKL_RULE_EXTRACT_PVT.rule_rec_type;
46: SUBTYPE rule_tbl_type is OKL_RULE_EXTRACT_PVT.rule_tbl_type;

Line 84: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

80: * @rep:lifecycle active
81: * @rep:category BUSINESS_ENTITY OKL_ORIGINATION
82: */
83: PROCEDURE Get_subclass_Rgs (p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_chr_id IN Varchar2,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

105: * @rep:lifecycle active
106: * @rep:category BUSINESS_ENTITY OKL_ORIGINATION
107: */
108: PROCEDURE Get_Rg_Rules (p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_rgd_code IN Varchar2,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

132: * @rep:lifecycle active
133: * @rep:category BUSINESS_ENTITY OKL_ORIGINATION
134: */
135: PROCEDURE Get_Rule_Def (p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_rgd_code IN VARCHAR2,

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

150: -- and retrieve ids and names for each segment.
151: --end of comments
152:
153: PROCEDURE Get_Rules_Metadata (p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_rgd_code IN VARCHAR2,