eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PAL_PVT dependencies on OKL_API

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

41: --------------------------------------------------------------------------------
42: -- GLOBAL MESSAGE CONSTANTS
43: --------------------------------------------------------------------------------
44:
45: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;

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

42: -- GLOBAL MESSAGE CONSTANTS
43: --------------------------------------------------------------------------------
44:
45: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

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

43: --------------------------------------------------------------------------------
44:
45: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

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

44:
45: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

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

45: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

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

46: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
54: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

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

47: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
54: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
55: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;

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

48: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
54: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
55: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
56: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

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

49: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
54: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
55: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
56: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
57: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

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

50: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
51: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
52: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
53: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
54: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
55: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
56: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
57: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
58: g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';

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

65: -- GLOBAL VARIABLES
66: --------------------------------------------------------------------------------
67:
68: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_PAL_PVT';
69: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
70:
71: --------------------------------------------------------------------------------
72: -- Procedures and Functions
73: --------------------------------------------------------------------------------

Line 80: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

76:
77: PROCEDURE api_copy;
78:
79: PROCEDURE insert_row(p_api_version IN NUMBER
80: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_pal_rec IN okl_pal_rec

Line 88: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

84: ,p_pal_rec IN okl_pal_rec
85: ,x_pal_rec OUT NOCOPY okl_pal_rec);
86:
87: PROCEDURE insert_row(p_api_version IN NUMBER
88: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
89: ,x_return_status OUT NOCOPY VARCHAR2
90: ,x_msg_count OUT NOCOPY NUMBER
91: ,x_msg_data OUT NOCOPY VARCHAR2
92: ,p_pal_tbl IN okl_pal_tbl

Line 96: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

92: ,p_pal_tbl IN okl_pal_tbl
93: ,x_pal_tbl OUT NOCOPY okl_pal_tbl);
94:
95: PROCEDURE update_row(p_api_version IN NUMBER
96: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
97: ,x_return_status OUT NOCOPY VARCHAR2
98: ,x_msg_count OUT NOCOPY NUMBER
99: ,x_msg_data OUT NOCOPY VARCHAR2
100: ,p_pal_rec IN okl_pal_rec

Line 104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

100: ,p_pal_rec IN okl_pal_rec
101: ,x_pal_rec OUT NOCOPY okl_pal_rec);
102:
103: PROCEDURE update_row(p_api_version IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
105: ,x_return_status OUT NOCOPY VARCHAR2
106: ,x_msg_count OUT NOCOPY NUMBER
107: ,x_msg_data OUT NOCOPY VARCHAR2
108: ,p_pal_tbl IN okl_pal_tbl

Line 112: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

108: ,p_pal_tbl IN okl_pal_tbl
109: ,x_pal_tbl OUT NOCOPY okl_pal_tbl);
110:
111: PROCEDURE delete_row(p_api_version IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2
116: ,p_pal_rec IN okl_pal_rec);

Line 119: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

115: ,x_msg_data OUT NOCOPY VARCHAR2
116: ,p_pal_rec IN okl_pal_rec);
117:
118: PROCEDURE delete_row(p_api_version IN NUMBER
119: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,x_msg_count OUT NOCOPY NUMBER
122: ,x_msg_data OUT NOCOPY VARCHAR2
123: ,p_pal_tbl IN okl_pal_tbl);