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_K_HEADERS_B

Line 289: l_from||', oks_k_headers_b oksh'||

285:
286: ELSIF p_ctr_rec.old_value = 'ERN' then
287: l_old_value := p_ctr_rec.old_value;
288: l_stmt := l_select||' , :l_old_value old_value' ||
289: l_from||', oks_k_headers_b oksh'||
290: l_where||
291: ' AND oksh.chr_id = okh.id
292: AND (okh.renewal_type_code = ''NSR''
293: AND ''ERN'' = :p_ctr_rec_old_value

Line 313: l_from||', oks_k_headers_b oksh'||

309: -- Old Value: Other than NULL or ALL
310: ELSE
311: l_old_value := p_ctr_rec.old_value;
312: l_stmt := l_select||' , :l_old_value old_value' ||
313: l_from||', oks_k_headers_b oksh'||
314: l_where||
315: ' AND oksh.chr_id = okh.id
316: AND okh.renewal_type_code = :p_ctr_rec_old_value
317: AND nvl(oksh.ELECTRONIC_RENEWAL_FLAG,''N'') <>''Y''

Line 1428: l_from||' ,oks_k_headers_b oksh'||

1424: ELSIF p_ctr_rec.old_value = 'ERN' then
1425:
1426: l_old_value := p_ctr_rec.old_value;
1427: l_stmt := l_select||' , :l_old_value old_value' ||
1428: l_from||' ,oks_k_headers_b oksh'||
1429: l_where||
1430: ' AND oksh.chr_id = okh.id
1431: AND okh.renewal_type_code = ''NSR''
1432: AND ''ERN'' = :p_ctr_rec_old_value

Line 1453: l_from||' ,oks_k_headers_b oksh'||

1449:
1450: ELSE
1451: l_old_value := p_ctr_rec.old_value;
1452: l_stmt := l_select||' , :l_old_value old_value' ||
1453: l_from||' ,oks_k_headers_b oksh'||
1454: l_where||
1455: ' AND oksh.chr_id = okh.id
1456: AND okh.renewal_type_code = :p_ctr_rec_old_value
1457: AND nvl(oksh.ELECTRONIC_RENEWAL_FLAG,''N'') <> ''Y''

Line 2537: l_from||' ,oks_k_headers_b oksh ,okc_k_party_roles_b okp1'||

2533: ELSIF p_ctr_rec.old_value = 'ERN' then
2534:
2535: l_old_value := p_ctr_rec.old_value;
2536: l_stmt := l_select||' , :l_old_value old_value' ||
2537: l_from||' ,oks_k_headers_b oksh ,okc_k_party_roles_b okp1'||
2538: l_where||
2539: ' AND oksh.chr_id = okh.id
2540: AND okh.renewal_type_code = ''NSR''
2541: AND ''ERN'' = :p_ctr_rec_old_value

Line 2564: l_from||' ,oks_k_headers_b oksh ,okc_k_party_roles_b okp1'||

2560: ELSE
2561:
2562: l_old_value := p_ctr_rec.old_value;
2563: l_stmt := l_select||' , :l_old_value old_value' ||
2564: l_from||' ,oks_k_headers_b oksh ,okc_k_party_roles_b okp1'||
2565: l_where||
2566: ' AND oksh.chr_id = okh.id
2567: AND okh.renewal_type_code = :p_ctr_rec_old_value
2568: AND nvl(oksh.ELECTRONIC_RENEWAL_FLAG,''N'') <> ''Y''

Line 3866: l_from||' ,oks_k_headers_b oksh'||

3862:
3863: ELSIF p_ctr_rec.old_value = 'ERN' then
3864: l_old_value := p_ctr_rec.old_value;
3865: l_stmt := l_select||' , :l_old_value old_value' ||
3866: l_from||' ,oks_k_headers_b oksh'||
3867: l_where||
3868: ' AND oksh.chr_id = okh.id
3869: AND okh.renewal_type_code = ''NSR''
3870: AND ''ERN'' = :p_ctr_rec_old_value

Line 3891: l_from||' ,oks_k_headers_b oksh'||

3887:
3888: ELSE
3889: l_old_value := p_ctr_rec.old_value;
3890: l_stmt := l_select||' , :l_old_value old_value' ||
3891: l_from||' ,oks_k_headers_b oksh'||
3892: l_where||
3893: ' AND oksh.chr_id = okh.id
3894: AND okh.renewal_type_code = :p_ctr_rec_old_value
3895: AND nvl(oksh.ELECTRONIC_RENEWAL_FLAG,''N'') <> ''Y''

Line 5004: l_from||' ,oks_k_headers_b oksh'||

5000: ELSIF p_ctr_rec.old_value = 'ERN' then
5001:
5002: l_old_value := p_ctr_rec.old_value;
5003: l_stmt := l_select||' , :l_old_value old_value' ||
5004: l_from||' ,oks_k_headers_b oksh'||
5005: l_where||
5006: ' AND oksh.chr_id = okh.id
5007: AND okh.renewal_type_code = ''NSR''
5008: AND ''ERN'' = :p_ctr_rec_old_value

Line 5033: l_from||' ,oks_k_headers_b oksh'||

5029: ELSE
5030:
5031: l_old_value := p_ctr_rec.old_value;
5032: l_stmt := l_select||' , :l_old_value old_value' ||
5033: l_from||' ,oks_k_headers_b oksh'||
5034: l_where||
5035: ' AND oksh.chr_id = okh.id
5036: AND okh.renewal_type_code = :p_ctr_rec_old_value
5037: AND nvl(oksh.ELECTRONIC_RENEWAL_FLAG,''N'') <>''Y''

Line 6966: FROM oks_k_headers_b oksh

6962: AND oct.timezone_id = p_old_value ;
6963:
6964: CURSOR Get_Acct_Rule(p_chr_id IN Number, p_old_value IN Varchar2) IS
6965: SELECT oksh.id , oksh.object_version_number
6966: FROM oks_k_headers_b oksh
6967: WHERE oksh.chr_id = p_chr_id
6968: AND oksh.acct_rule_id = p_old_value ;
6969:
6970: CURSOR Get_Summary_Print(p_chr_id IN Number, p_old_value IN Varchar2) IS

Line 6972: FROM oks_k_headers_b oksh

6968: AND oksh.acct_rule_id = p_old_value ;
6969:
6970: CURSOR Get_Summary_Print(p_chr_id IN Number, p_old_value IN Varchar2) IS
6971: SELECT oksh.id , oksh.object_version_number
6972: FROM oks_k_headers_b oksh
6973: WHERE oksh.chr_id = p_chr_id
6974: AND nvl(oksh.inv_print_profile,'N') = p_old_value ;
6975:
6976: CURSOR Get_Electronic_Ren_YN(p_chr_id IN Number) IS

Line 6978: FROM oks_k_headers_b oksh

6974: AND nvl(oksh.inv_print_profile,'N') = p_old_value ;
6975:
6976: CURSOR Get_Electronic_Ren_YN(p_chr_id IN Number) IS
6977: SELECT oksh.id , oksh.object_version_number
6978: FROM oks_k_headers_b oksh
6979: WHERE oksh.chr_id = p_chr_id;
6980:
6981: CURSOR Get_po_required_ren(p_chr_id IN Number, p_old_value IN Varchar2) IS
6982: SELECT oksh.id , oksh.object_version_number