DBA Data[Home] [Help]

APPS.OKL_SRV_PVT dependencies on OKL_API

Line 51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;

47: --------------------------------------------------------------------------------
48: -- GLOBAL MESSAGE CONSTANTS
49: --------------------------------------------------------------------------------
50:
51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;

Line 52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;

48: -- GLOBAL MESSAGE CONSTANTS
49: --------------------------------------------------------------------------------
50:
51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

Line 53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;

49: --------------------------------------------------------------------------------
50:
51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

Line 54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;

50:
51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

Line 55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;

51: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

Line 56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

52: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

Line 57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

53: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
61: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

54: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
61: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
62: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

Line 59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

55: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
61: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
62: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
63: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

Line 60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

56: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
61: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
62: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
63: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
64: g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';

Line 75: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;

71: -- GLOBAL VARIABLES
72: --------------------------------------------------------------------------------
73:
74: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_SRV_PVT';
75: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
76:
77: --------------------------------------------------------------------------------
78: -- Procedures and Functions
79: --------------------------------------------------------------------------------

Line 86: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

82:
83: PROCEDURE api_copy;
84:
85: PROCEDURE insert_row(p_api_version IN NUMBER
86: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
87: ,x_return_status OUT NOCOPY VARCHAR2
88: ,x_msg_count OUT NOCOPY NUMBER
89: ,x_msg_data OUT NOCOPY VARCHAR2
90: ,p_srv_rec IN okl_srv_rec

Line 94: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

90: ,p_srv_rec IN okl_srv_rec
91: ,x_srv_rec OUT NOCOPY okl_srv_rec);
92:
93: PROCEDURE insert_row(p_api_version IN NUMBER
94: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
95: ,x_return_status OUT NOCOPY VARCHAR2
96: ,x_msg_count OUT NOCOPY NUMBER
97: ,x_msg_data OUT NOCOPY VARCHAR2
98: ,p_srv_tbl IN okl_srv_tbl

Line 102: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

98: ,p_srv_tbl IN okl_srv_tbl
99: ,x_srv_tbl OUT NOCOPY okl_srv_tbl);
100:
101: PROCEDURE update_row(p_api_version IN NUMBER
102: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_srv_rec IN okl_srv_rec

Line 110: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

106: ,p_srv_rec IN okl_srv_rec
107: ,x_srv_rec OUT NOCOPY okl_srv_rec);
108:
109: PROCEDURE update_row(p_api_version IN NUMBER
110: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
111: ,x_return_status OUT NOCOPY VARCHAR2
112: ,x_msg_count OUT NOCOPY NUMBER
113: ,x_msg_data OUT NOCOPY VARCHAR2
114: ,p_srv_tbl IN okl_srv_tbl

Line 118: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

114: ,p_srv_tbl IN okl_srv_tbl
115: ,x_srv_tbl OUT NOCOPY okl_srv_tbl);
116:
117: PROCEDURE delete_row(p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
119: ,x_return_status OUT NOCOPY VARCHAR2
120: ,x_msg_count OUT NOCOPY NUMBER
121: ,x_msg_data OUT NOCOPY VARCHAR2
122: ,p_srv_rec IN okl_srv_rec);

Line 125: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

121: ,x_msg_data OUT NOCOPY VARCHAR2
122: ,p_srv_rec IN okl_srv_rec);
123:
124: PROCEDURE delete_row(p_api_version IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
126: ,x_return_status OUT NOCOPY VARCHAR2
127: ,x_msg_count OUT NOCOPY NUMBER
128: ,x_msg_data OUT NOCOPY VARCHAR2
129: ,p_srv_tbl IN okl_srv_tbl);