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.OKC_TIME_RES_PVT dependencies on OKC_TIME_UTIL_PUB

Line 401: l_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE(

397: l_found := TRUE;
398: if l_okc_tal_rec.before_after = 'B' then
399: l_okc_tal_rec.duration := -1 * l_okc_tal_rec.duration;
400: end if;
401: l_end_date := OKC_TIME_UTIL_PUB.GET_ENDDATE(
402: l_date,
403: l_okc_tal_rec.uom_code,
404: l_okc_tal_rec.duration);
405: if l_end_date is NULL Then

Line 894: l_end_date := okc_time_util_pub.get_enddate(l_start_date, l_okc_spn_tbl(i).uom_code,l_okc_spn_tbl(i).duration);

890: while l_end_date <= p_end_date
891: LOOP
892: i := l_okc_spn_tbl.FIRST;
893: LOOP
894: l_end_date := okc_time_util_pub.get_enddate(l_start_date, l_okc_spn_tbl(i).uom_code,l_okc_spn_tbl(i).duration);
895: if (l_end_date > p_end_date) THEN
896: exit;
897: end if;
898: if l_okc_spn_tbl(i).active_yn = 'Y' then

Line 999: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;

995: x_task_id NUMBER;
996: l_rule_type OKC_RULES_V.rule_information_category%type;
997: l_app_id number;
998: l_rule_df_name varchar2(40);
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;

Line 1016: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;

1012: */
1013:
1014: /* Get the application_id and get the rule definition names */
1015:
1016: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;
1017: if l_app_id is null then
1018: return;
1019: end if;
1020:

Line 1021: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;

1017: if l_app_id is null then
1018: return;
1019: end if;
1020:
1021: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;
1022: if l_rule_df_name is null then
1023: return;
1024: end if;
1025:

Line 1029: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');

1025:
1026: /* Get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1027: /* Get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1028:
1029: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1030: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1031:
1032: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1033:

Line 1030: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');

1026: /* Get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1027: /* Get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1028:
1029: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1030: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1031:
1032: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1033:
1034: /* For these rules, get their ids using the contract header (line) id. */

Line 1050: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',

1046:
1047: /* Get all the timevalues associated with the rule. Currently there is only one tve_id per rule. May be extended in
1048: future. API is flexible to handle this */
1049:
1050: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',
1051: l_rul_id);
1052: if l_list_of_tve_id is NULL Then
1053: goto next_row1;
1054: end if;

Line 1338: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;

1334: l_sql_string varchar2(4000);
1335: l_rule_type OKC_RULES_V.rule_information_category%type;
1336: l_app_id number;
1337: l_rule_df_name varchar2(40);
1338: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;
1339: l_no_of_cols number;
1340: l_tze_id number;
1341: x_task_id NUMBER;
1342: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

Line 1366: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;

1362: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1363:
1364: /* Get the application_id and get the rule definition names */
1365:
1366: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;
1367: if l_app_id is null then
1368: return;
1369: end if;
1370: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;

Line 1370: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;

1366: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;
1367: if l_app_id is null then
1368: return;
1369: end if;
1370: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;
1371: if l_rule_df_name is null then
1372: return;
1373: end if;
1374:

Line 1378: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');

1374:
1375: /*get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1376: /*get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1377:
1378: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1379: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1380:
1381: /* For these rules, get their ids using the contract header (line) id. */
1382:

Line 1379: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');

1375: /*get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1376: /*get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1377:
1378: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1379: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1380:
1381: /* For these rules, get their ids using the contract header (line) id. */
1382:
1383:

Line 1422: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',

1418:
1419: /* Get all the timevalues associated with the rule. Currently there is only one tve_id per rule. May be extended in
1420: future. API is flexible to handle this */
1421:
1422: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',
1423: l_rul_id);
1424: if l_list_of_tve_id is NULL Then
1425: goto next_row;
1426: end if;

Line 1563: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;

1559: x_msg_data VARCHAR2(2000);
1560: l_app_id number;
1561: l_rule_type OKC_RULES_V.rule_information_category%type;
1562: l_rule_df_name varchar2(40);
1563: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;
1564: l_no_of_cols number;
1565: l_resolved_until_date date;
1566:
1567: BEGIN

Line 1579: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;

1575: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1576:
1577: /* Get the application_id and get the rule definition names */
1578:
1579: l_app_id := OKC_TIME_UTIL_PUB.get_app_id;
1580: if l_app_id is null then
1581: return;
1582: end if;
1583:

Line 1584: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;

1580: if l_app_id is null then
1581: return;
1582: end if;
1583:
1584: l_rule_df_name := OKC_TIME_UTIL_PUB.get_rule_df_name;
1585: if l_rule_df_name is null then
1586: return;
1587: end if;
1588:

Line 1592: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');

1588:
1589: /*get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1590: /*get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1591:
1592: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1593: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1594:
1595: /* For these rules, get their ids using the contract header (line) id. */
1596:

Line 1593: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');

1589: /*get all the rule types (e.g. NTN) from metadata which are related to timevalues.*/
1590: /*get all the rule types (e.g. NTN) from metadata which are related to tasks.*/
1591:
1592: l_list_of_rules := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TIMEVALUES');
1593: l_list_of_rules1 := OKC_TIME_UTIL_PUB.get_rule_defs_using_vs(l_app_id,l_rule_df_name,'OKC_TASK_RS');
1594:
1595: /* For these rules, get their ids using the contract header (line) id. */
1596:
1597: l_sql_string := 'select r.id, r.rule_information_category ' ||

Line 1612: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',

1608:
1609: /* Get all the timevalues associated with the rule. Currently there is only one tve_id per rule. May be extended in
1610: future. API is flexible to handle this */
1611:
1612: l_list_of_tve_id := OKC_TIME_UTIL_PUB.get_tve_ids(l_app_id,l_rule_df_name,l_rule_type,'OKC_TIMEVALUES',
1613: l_rul_id);
1614: if l_list_of_tve_id is NULL Then
1615: goto next_row;
1616: end if;