27: ----------------------------------------------------------------------------
28: -- GLOBAL CONSTANTS
29: ----------------------------------------------------------------------------
30: g_pkg_name CONSTANT varchar2(100) := 'OKC_INST_CND_PUB';
31: g_app_name CONSTANT varchar2(100) := OKC_API.G_APP_NAME;
32:
33: ----------------------------------------------------------------------------
34: -- GLOBAL EXCEPTION
35: ----------------------------------------------------------------------------
37:
38: ----------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ----------------------------------------------------------------------------
41: g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: ----------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ----------------------------------------------------------------------------
41: g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
39: -- GLOBAL MESSAGE CONSTANTS
40: ----------------------------------------------------------------------------
41: g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
40: ----------------------------------------------------------------------------
41: g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
41: g_fnd_app CONSTANT varchar2(200) := OKC_API.G_FND_APP;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: g_form_record_deleted CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
44: g_form_record_changed CONSTANT varchar2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
52: g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
45: g_record_logically_deleted CONSTANT varchar2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
52: g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
53: g_sqlcode_token CONSTANT varchar2(200) := 'SQLcode';
46: g_required_value CONSTANT varchar2(200) := OKC_API.G_REQUIRED_VALUE;
47: g_invalid_value CONSTANT varchar2(200) := OKC_API.G_INVALID_VALUE;
48: g_col_name_token CONSTANT varchar2(200) := OKC_API.G_COL_NAME_TOKEN;
49: g_parent_table_token CONSTANT varchar2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: g_child_table_token CONSTANT varchar2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
52: g_sqlerrm_token CONSTANT varchar2(200) := 'SQLerrm';
53: g_sqlcode_token CONSTANT varchar2(200) := 'SQLcode';
54: g_uppercase_required CONSTANT varchar2(200) := 'OKC_UPPER_CASE_REQUIRED';
57: -- PROCEDURE inst_condition
58: ----------------------------------------------------------------------------
59: PROCEDURE inst_condition(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_instcnd_inp_rec IN INSTCND_INP_REC);