APPS.OKC_TIME_RES_PVT dependencies on OKC_TIME_PUB

Line 148: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;

144: x_msg_count NUMBER;
145: x_task_id NUMBER;
146: l_msg_data VARCHAR2(2000);
147: x_msg_data VARCHAR2(2000);
148: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
149: x_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
150: BEGIN
151: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
152: p_init_msg_list,

Line 149: x_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;

145: x_task_id NUMBER;
146: l_msg_data VARCHAR2(2000);
147: x_msg_data VARCHAR2(2000);
148: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
149: x_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
150: BEGIN
151: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
152: p_init_msg_list,
153: '_COMPLEX',

Line 173: OKC_TIME_PUB.CREATE_RESOLVED_TIMEVALUES(

169: l_rtvv_rec.tve_id := p_tve_id;
170: l_rtvv_rec.datetime := p_date;
171: l_rtvv_rec.coe_id := p_coe_id;
172: -- Creating Resolved timevalues
173: OKC_TIME_PUB.CREATE_RESOLVED_TIMEVALUES(
174: p_api_version,
175: p_init_msg_list,
176: x_return_status,
177: x_msg_count,

Line 1003: p_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;

999: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;
1000: l_no_of_cols number;
1001: l_tze_id number;
1002: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
1003: p_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1004: x_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1005: l_pending_further_resolving VARCHAR2(1) := 'X';
1006: l_over_further_resolving VARCHAR2(1) := 'X';
1007:

Line 1004: x_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;

1000: l_no_of_cols number;
1001: l_tze_id number;
1002: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
1003: p_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1004: x_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1005: l_pending_further_resolving VARCHAR2(1) := 'X';
1006: l_over_further_resolving VARCHAR2(1) := 'X';
1007:
1008: BEGIN

Line 1196: OKC_TIME_pub.update_ia_startend(

1192: end if;
1193: p_isev_ext_rec.start_date := l_start_date;
1194: p_isev_ext_rec.end_date := l_end_date;
1195: p_isev_ext_rec.id := l_tve_id_limited;
1196: OKC_TIME_pub.update_ia_startend(
1197: p_api_version,
1198: p_init_msg_list,
1199: x_return_status,
1200: x_msg_count,

Line 1557: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;

1553: l_rul_id NUMBER;
1554: l_rtv_id NUMBER;
1555: l_tve_type OKC_TIMEVALUES.tve_type%type;
1556: l_sql_string varchar2(4000);
1557: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
1558: x_msg_count NUMBER;
1559: x_msg_data VARCHAR2(2000);
1560: l_app_id number;
1561: l_rule_type OKC_RULES_V.rule_information_category%type;

Line 1643: OKC_TIME_PUB.DELETE_RESOLVED_TIMEVALUES(

1639: x_msg_data);
1640: if x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1641: exit;
1642: end if;
1643: OKC_TIME_PUB.DELETE_RESOLVED_TIMEVALUES(
1644: p_api_version,
1645: p_init_msg_list,
1646: x_return_status,
1647: x_msg_count,

Line 1739: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;

1735: and rtv.datetime >= p_date
1736: and tve.id = p_tve_id ;
1737:
1738: l_rtv_rec rtv_csr%ROWTYPE;
1739: l_rtvv_rec OKC_TIME_PUB.rtvv_rec_type;
1740: x_msg_count NUMBER;
1741: x_msg_data VARCHAR2(2000);
1742: BEGIN
1743: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1761: OKC_TIME_PUB.DELETE_RESOLVED_TIMEVALUES(

1757: x_msg_data);
1758: if x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1759: exit;
1760: end if;
1761: OKC_TIME_PUB.DELETE_RESOLVED_TIMEVALUES(
1762: p_api_version,
1763: p_init_msg_list,
1764: x_return_status,
1765: x_msg_count,