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.OKS_MASSCHANGE_PVT dependencies on OKS_ACTION_TIME_TYPES

Line 983: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

979:
980: -- Old Value: NULL (-9999)
981: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
982: l_stmt := l_select||', NULL old_value'||
983: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
984: ' AND kl.dnz_chr_id = okh.id
985: AND kl.id = att.cle_id
986: And kl.lse_id in (4,17,22)
987: AND att.action_type_code = ''RSN''

Line 1003: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

999: ELSE
1000:
1001: l_old_value := p_ctr_rec.old_value;
1002: l_stmt := l_select||' , :l_old_value old_value'||
1003: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1004: ' AND kl.dnz_chr_id = okh.id
1005: AND kl.id = att.cle_id
1006: And kl.lse_id in (4,17,22)
1007: AND att.action_type_code = ''RSN''

Line 1027: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

1023:
1024: -- Old Value: NULL (-9999)
1025: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1026: l_stmt := l_select||', NULL old_value'||
1027: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1028: ' AND kl.dnz_chr_id = okh.id
1029: AND kl.id = att.cle_id
1030: And kl.lse_id in (4,17,22)
1031: AND att.action_type_code = ''RCN''

Line 1047: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

1043: ELSE
1044:
1045: l_old_value := p_ctr_rec.old_value;
1046: l_stmt := l_select||' , :l_old_value old_value'||
1047: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1048: ' AND kl.dnz_chr_id = okh.id
1049: AND kl.id = att.cle_id
1050: And kl.lse_id in (4,17,22)
1051: AND att.action_type_code = ''RCN''

Line 2105: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

2101:
2102: -- Old Value: NULL (-9999)
2103: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2104: l_stmt := l_select||', NULL old_value'||
2105: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
2106: ' AND kl.dnz_chr_id = okh.id
2107: AND kl.id = att.cle_id
2108: And kl.lse_id in (4,17,22)
2109: AND att.action_type_code = ''RSN''

Line 2127: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2123: ELSE
2124: -- dbms_output.put_line('Inside else 111111');
2125: l_old_value := p_ctr_rec.old_value;
2126: l_stmt := l_select||' , :l_old_value old_value'||
2127: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2128: ' AND kl.dnz_chr_id = okh.id
2129: AND kl.id = att.cle_id
2130: And kl.lse_id in (4,17,22)
2131: AND att.action_type_code = ''RSN''

Line 2151: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2147:
2148: -- Old Value: NULL (-9999)
2149: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2150: l_stmt := l_select||', NULL old_value'||
2151: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2152: ' AND kl.dnz_chr_id = okh.id
2153: AND kl.id = att.cle_id
2154: And kl.lse_id in (4,17,22)
2155: AND att.action_type_code = ''RCN''

Line 2171: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2167: ELSE
2168:
2169: l_old_value := p_ctr_rec.old_value;
2170: l_stmt := l_select||' , :l_old_value old_value'||
2171: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2172: ' AND kl.dnz_chr_id = okh.id
2173: AND kl.id = att.cle_id
2174: And kl.lse_id in (4,17,22)
2175: AND att.action_type_code = ''RCN''

Line 3376: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '|| l_where||

3372:
3373: -- Old Value: NULL (-9999)
3374: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3375: l_stmt := l_select||', NULL old_value'||
3376: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '|| l_where||
3377: ' AND kl.dnz_chr_id = okh.id
3378: AND kl.id = att.cle_id
3379: And kl.lse_id in (4,17,22)
3380: AND att.action_type_code = ''RSN''

Line 3399: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3395: ELSE
3396: -- dbms_output.put_line('Inside else 111111');
3397: l_old_value := p_ctr_rec.old_value;
3398: l_stmt := l_select||' , :l_old_value old_value'||
3399: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3400: ' AND kl.dnz_chr_id = okh.id
3401: AND kl.id = att.cle_id
3402: And kl.lse_id in (4,17,22)
3403: AND att.action_type_code = ''RSN''

Line 3425: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3421:
3422: -- Old Value: NULL (-9999)
3423: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3424: l_stmt := l_select||', NULL old_value'||
3425: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3426: ' AND kl.dnz_chr_id = okh.id
3427: AND kl.id = att.cle_id
3428: And kl.lse_id in (4,17,22)
3429: AND att.action_type_code = ''RCN''

Line 3447: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3443: ELSE
3444:
3445: l_old_value := p_ctr_rec.old_value;
3446: l_stmt := l_select||' , :l_old_value old_value'||
3447: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3448: ' AND kl.dnz_chr_id = okh.id
3449: AND kl.id = att.cle_id
3450: And kl.lse_id in (4,17,22)
3451: AND att.action_type_code = ''RCN''

Line 4559: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

4555:
4556: -- Old Value: NULL (-9999)
4557: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4558: l_stmt := l_select||', NULL old_value'||
4559: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
4560: ' AND kl.dnz_chr_id = okh.id
4561: AND kl.id = att.cle_id
4562: And kl.lse_id in (4,17,22)
4563: AND att.action_type_code = ''RSN''

Line 4580: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4576: ELSE
4577: -- dbms_output.put_line('Inside else 111111');
4578: l_old_value := p_ctr_rec.old_value;
4579: l_stmt := l_select||' , :l_old_value old_value'||
4580: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4581: ' AND kl.dnz_chr_id = okh.id
4582: AND kl.id = att.cle_id
4583: And kl.lse_id in (4,17,22)
4584: AND att.action_type_code = ''RSN''

Line 4604: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4600:
4601: -- Old Value: NULL (-9999)
4602: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4603: l_stmt := l_select||', NULL old_value'||
4604: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4605: ' AND kl.dnz_chr_id = okh.id
4606: AND kl.id = att.cle_id
4607: And kl.lse_id in (4,17,22)
4608: AND att.action_type_code = ''RCN''

Line 4622: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4618: -- Old Value: Other than NULL or ALL
4619: ELSE
4620: l_old_value := p_ctr_rec.old_value;
4621: l_stmt := l_select||' , :l_old_value old_value'||
4622: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4623: ' AND kl.dnz_chr_id = okh.id
4624: AND kl.id = att.cle_id
4625: And kl.lse_id in (4,17,22)
4626: AND att.action_type_code = ''RCN''

Line 5858: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

5854:
5855: -- Old Value: NULL (-9999)
5856: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5857: l_stmt := l_select||', NULL old_value'||
5858: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
5859: ' AND kl.dnz_chr_id = okh.id
5860: AND kl.id = att.cle_id
5861: And kl.lse_id in (4,17,22)
5862: AND att.action_type_code = ''RSN''

Line 5883: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5879: ELSE
5880: -- dbms_output.put_line('Inside else 111111');
5881: l_old_value := p_ctr_rec.old_value;
5882: l_stmt := l_select||' , :l_old_value old_value'||
5883: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5884: ' AND kl.dnz_chr_id = okh.id
5885: AND kl.id = att.cle_id
5886: And kl.lse_id in (4,17,22)
5887: AND att.action_type_code = ''RSN''

Line 5910: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5906:
5907: -- Old Value: NULL (-9999)
5908: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5909: l_stmt := l_select||', NULL old_value'||
5910: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5911: ' AND kl.dnz_chr_id = okh.id
5912: AND kl.id = att.cle_id
5913: And kl.lse_id in (4,17,22)
5914: AND att.action_type_code = ''RCN''

Line 5931: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5927: -- Old Value: Other than NULL or ALL
5928: ELSE
5929: l_old_value := p_ctr_rec.old_value;
5930: l_stmt := l_select||' , :l_old_value old_value'||
5931: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5932: ' AND kl.dnz_chr_id = okh.id
5933: AND kl.id = att.cle_id
5934: And kl.lse_id in (4,17,22)
5935: AND att.action_type_code = ''RCN''

Line 7077: FROM OKC_K_LINES_V okl, oks_action_times oat , oks_action_time_types att

7073: CURSOR Get_act_time ( p_chr_id IN NUMBER , p_action_type_code VARCHAR2
7074: , p_old_value IN Varchar2) IS
7075: SELECT oat.id id ,oat.sun_duration ,oat.mon_duration ,oat.tue_duration ,oat.wed_duration,
7076: oat.thu_duration ,oat.fri_duration, oat.sat_duration, oat.object_version_number
7077: FROM OKC_K_LINES_V okl, oks_action_times oat , oks_action_time_types att
7078: WHERE okl.dnz_chr_id = p_chr_id
7079: AND att.cle_id = okl.id
7080: AND att.action_type_code = p_action_type_code
7081: AND oat.cov_action_type_id = att.id