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.

[Home] [Help]

APPS.OKS_MASSCHANGE_PVT dependencies on OKS_K_HEADERS_V

Line 381: l_from||' ,oks_k_headers_v oksh '||

377: -- Old Value: NULL (-9999)
378: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
379:
380: l_stmt := l_select||' ,NULL old_value' ||
381: l_from||' ,oks_k_headers_v oksh '||
382: l_where|| 'AND oksh.chr_id = okh.id
383: AND oksh.acct_rule_id IS NULL
384: AND okh.id = to_number(:update_level_value)';
385: -- Old Value: ALL (-1111)

Line 389: l_from||' ,oks_k_headers_v oksh '||

385: -- Old Value: ALL (-1111)
386:
387: ELSIF p_ctr_rec.old_value = '-1111' THEN
388: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
389: l_from||' ,oks_k_headers_v oksh '||
390: l_where|| 'AND oksh.chr_id = okh.id
391: AND okh.id = to_number(:update_level_value)';
392: -- Old Value: Other than NULL or ALL
393:

Line 396: l_from||' ,oks_k_headers_v oksh '||

392: -- Old Value: Other than NULL or ALL
393:
394: ELSE
395: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
396: l_from||' ,oks_k_headers_v oksh '||
397: l_where|| 'AND oksh.chr_id = okh.id
398: AND oksh.acct_rule_id = to_number(:p_ctr_rec_old_value)
399: AND okh.id = to_number(:update_level_value)';
400:

Line 1194: l_from||' ,oks_k_headers_v oksh '||

1190: -- Old Value: Other than NULL or ALL
1191: ELSE
1192: l_old_value := p_ctr_rec.old_value;
1193: l_stmt := l_select||' , :l_old_value old_value'||
1194: l_from||' ,oks_k_headers_v oksh '||
1195: l_where||' AND oksh.chr_id = okh.id
1196: AND nvl(oksh.renewal_po_required,''N'') = :p_ctr_rec_old_value
1197: AND okh.id = to_number(:update_level_value)';
1198: END IF ;

Line 1210: l_from||' ,oks_k_headers_v oksh '||

1206:
1207: IF p_ctr_rec.old_value = '-1111' THEN
1208: l_old_value := p_ctr_rec.old_value;
1209: l_stmt := l_select||' , :l_old_value old_value'||
1210: l_from||' ,oks_k_headers_v oksh '||
1211: l_where||' AND oksh.chr_id = okh.id
1212: AND okh.id = :update_level_value';
1213:
1214: -- Old Value: Other than NULL or ALL

Line 1218: l_from||' ,oks_k_headers_v oksh '||

1214: -- Old Value: Other than NULL or ALL
1215: ELSE
1216: l_old_value := p_ctr_rec.old_value;
1217: l_stmt := l_select||' , :l_old_value old_value'||
1218: l_from||' ,oks_k_headers_v oksh '||
1219: l_where||' AND oksh.chr_id = okh.id
1220: AND nvl(oksh.inv_print_profile,''N'') = :p_ctr_rec_old_value
1221: AND okh.id = to_number(:update_level_value)';
1222:

Line 1522: l_from||' ,oks_k_headers_v oksh '||

1518: -- Old Value: NULL (-9999)
1519: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1520:
1521: l_stmt := l_select||' ,NULL old_value' ||
1522: l_from||' ,oks_k_headers_v oksh '||
1523: l_where|| 'AND oksh.chr_id = okh.id
1524: AND oksh.acct_rule_id IS NULL
1525: AND okh.org_id = to_number(:update_level_value)';
1526: -- Old Value: ALL (-1111)

Line 1530: l_from||' ,oks_k_headers_v oksh '||

1526: -- Old Value: ALL (-1111)
1527:
1528: ELSIF p_ctr_rec.old_value = '-1111' THEN
1529: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
1530: l_from||' ,oks_k_headers_v oksh '||
1531: l_where|| 'AND oksh.chr_id = okh.id
1532: AND okh.org_id = to_number(:update_level_value)';
1533: -- Old Value: Other than NULL or ALL
1534:

Line 1537: l_from||' ,oks_k_headers_v oksh '||

1533: -- Old Value: Other than NULL or ALL
1534:
1535: ELSE
1536: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
1537: l_from||' ,oks_k_headers_v oksh '||
1538: l_where|| 'AND oksh.chr_id = okh.id
1539: AND oksh.acct_rule_id = to_number(:p_ctr_rec_old_value)
1540: AND okh.org_id = to_number(:update_level_value)';
1541: END IF;

Line 2304: l_from||' ,oks_k_headers_v oksh '||

2300: ELSE
2301:
2302: l_old_value := p_ctr_rec.old_value;
2303: l_stmt := l_select||' , :l_old_value old_value'||
2304: l_from||' ,oks_k_headers_v oksh '||
2305: l_where||' AND oksh.chr_id = okh.id
2306: AND nvl(oksh.renewal_po_required,''N'') = :p_ctr_rec_old_value
2307: AND okh.org_id = to_number(:update_level_value)';
2308: END IF ;

Line 2320: l_from||' ,oks_k_headers_v oksh '||

2316:
2317: IF p_ctr_rec.old_value = '-1111' THEN
2318: l_old_value := p_ctr_rec.old_value;
2319: l_stmt := l_select||' , :l_old_value old_value'||
2320: l_from||' ,oks_k_headers_v oksh '||
2321: l_where||' AND oksh.chr_id = okh.id
2322: AND okh.org_id = to_number(:update_level_value)';
2323:
2324:

Line 2330: l_from||' ,oks_k_headers_v oksh '||

2326:
2327: ELSE
2328: l_old_value := p_ctr_rec.old_value;
2329: l_stmt := l_select||' , :l_old_value old_value'||
2330: l_from||' ,oks_k_headers_v oksh '||
2331: l_where||' AND oksh.chr_id = okh.id
2332: AND nvl(oksh.inv_print_profile,''N'') = :p_ctr_rec_old_value
2333: AND okh.org_id = to_number(:update_level_value)';
2334:

Line 2641: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||

2637: -- Old Value: NULL (-9999)
2638: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2639:
2640: l_stmt := l_select||' ,NULL old_value' ||
2641: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||
2642: l_where|| 'AND oksh.chr_id = okh.id
2643: AND oksh.acct_rule_id IS NULL
2644: AND okh.id = okp1.chr_id
2645: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2651: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||

2647: -- Old Value: ALL (-1111)
2648:
2649: ELSIF p_ctr_rec.old_value = '-1111' THEN
2650: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
2651: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||
2652: l_where|| 'AND oksh.chr_id = okh.id
2653: AND okh.id = okp1.chr_id
2654: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')
2655: AND okp1.object1_id1 = :update_level_value';

Line 2660: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||

2656: -- Old Value: Other than NULL or ALL
2657:
2658: ELSE
2659: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
2660: l_from||' ,oks_k_headers_v oksh ,okc_k_party_roles_b okp1 '||
2661: l_where|| 'AND oksh.chr_id = okh.id
2662: AND oksh.acct_rule_id = to_number(:p_ctr_rec_old_value)
2663: AND okh.id = okp1.chr_id
2664: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 3620: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||

3616: ELSE
3617:
3618: l_old_value := p_ctr_rec.old_value;
3619: l_stmt := l_select||' , :l_old_value old_value'||
3620: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||
3621: l_where||' AND oksh.chr_id = okh.id
3622: AND nvl(oksh.renewal_po_required,''N'') = :p_ctr_rec_old_value
3623: AND okh.id = okp1.chr_id
3624: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 3638: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||

3634:
3635: IF p_ctr_rec.old_value = '-1111' THEN
3636: l_old_value := p_ctr_rec.old_value;
3637: l_stmt := l_select||' , :l_old_value old_value'||
3638: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||
3639: l_where||' AND oksh.chr_id = okh.id
3640: AND okh.id = okp1.chr_id
3641: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')
3642: AND okp1.object1_id1 = :update_level_value';

Line 3650: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||

3646:
3647: ELSE
3648: l_old_value := p_ctr_rec.old_value;
3649: l_stmt := l_select||' , :l_old_value old_value'||
3650: l_from||', okc_k_party_roles_b okp1 ,oks_k_headers_v oksh '||
3651: l_where||' AND oksh.chr_id = okh.id
3652: AND nvl(oksh.inv_print_profile,''N'') = :p_ctr_rec_old_value
3653: AND okh.id = okp1.chr_id
3654: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 3959: l_from||' ,oks_k_headers_v oksh '||

3955: -- Old Value: ALL (-9999)
3956: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3957:
3958: l_stmt := l_select||' ,NULL old_value' ||
3959: l_from||' ,oks_k_headers_v oksh '||
3960: l_where|| 'AND oksh.chr_id = okh.id
3961: AND oksh.acct_rule_id IS NULL
3962: AND okh.scs_code = :update_level_value';
3963: -- Old Value: ALL (-1111)

Line 3967: l_from||' ,oks_k_headers_v oksh '||

3963: -- Old Value: ALL (-1111)
3964:
3965: ELSIF p_ctr_rec.old_value = '-1111' THEN
3966: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
3967: l_from||' ,oks_k_headers_v oksh '||
3968: l_where|| 'AND oksh.chr_id = okh.id
3969: AND okh.scs_code = :update_level_value';
3970: -- Old Value: Other than NULL or ALL
3971:

Line 3974: l_from||' ,oks_k_headers_v oksh '||

3970: -- Old Value: Other than NULL or ALL
3971:
3972: ELSE
3973: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
3974: l_from||' ,oks_k_headers_v oksh '||
3975: l_where|| 'AND oksh.chr_id = okh.id
3976: AND oksh.acct_rule_id = to_number(:p_ctr_rec_old_value)
3977: AND okh.scs_code = :update_level_value';
3978: END IF;

Line 4756: l_from||' ,oks_k_headers_v oksh '||

4752: ELSE
4753:
4754: l_old_value := p_ctr_rec.old_value;
4755: l_stmt := l_select||' , :l_old_value old_value'||
4756: l_from||' ,oks_k_headers_v oksh '||
4757: l_where||' AND oksh.chr_id = okh.id
4758: AND nvl(oksh.renewal_po_required,''N'') = :p_ctr_rec_old_value
4759: AND okh.scs_code = :update_level_value';
4760: END IF ;

Line 4770: l_from||' ,oks_k_headers_v oksh '||

4766:
4767: -- Old Value: ALL (-1111)
4768: IF p_ctr_rec.old_value = '-1111' THEN
4769: l_stmt := l_select||' , :l_old_value old_value'||
4770: l_from||' ,oks_k_headers_v oksh '||
4771: l_where||' AND oksh.chr_id = okh.id
4772: AND okh.scs_code = :update_level_value';
4773:
4774:

Line 4779: l_from||' ,oks_k_headers_v oksh '||

4775: -- Old Value: Other than NULL or ALL
4776: ELSE
4777: l_old_value := p_ctr_rec.old_value;
4778: l_stmt := l_select||' , :l_old_value old_value'||
4779: l_from||' ,oks_k_headers_v oksh '||
4780: l_where||' AND oksh.chr_id = okh.id
4781: AND nvl(oksh.inv_print_profile,''N'') = :p_ctr_rec_old_value
4782: AND okh.scs_code = :update_level_value';
4783:

Line 5114: l_from||' ,oks_k_headers_v oksh '||

5110: -- Old Value: ALL (-9999)
5111: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5112:
5113: l_stmt := l_select||' ,NULL old_value' ||
5114: l_from||' ,oks_k_headers_v oksh '||
5115: l_where|| 'AND oksh.chr_id = okh.id
5116: AND oksh.acct_rule_id IS NULL
5117: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5118: WHERE okg1.included_chr_id is not null

Line 5125: l_from||' ,oks_k_headers_v oksh '||

5121: -- Old Value: ALL (-1111)
5122:
5123: ELSIF p_ctr_rec.old_value = '-1111' THEN
5124: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
5125: l_from||' ,oks_k_headers_v oksh '||
5126: l_where|| 'AND oksh.chr_id = okh.id
5127: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5128: WHERE okg1.included_chr_id is not null
5129: START WITH okg1.cgp_parent_id = to_number(:update_level_value)

Line 5135: l_from||' ,oks_k_headers_v oksh '||

5131: -- Old Value: Other than NULL or ALL
5132:
5133: ELSE
5134: l_stmt := l_select||' ,oksh.acct_rule_id old_value' ||
5135: l_from||' ,oks_k_headers_v oksh '||
5136: l_where|| 'AND oksh.chr_id = okh.id
5137: AND oksh.acct_rule_id = to_number(:p_ctr_rec_old_value)
5138: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5139: WHERE okg1.included_chr_id is not null

Line 6116: l_from||' ,oks_k_headers_v oksh '||

6112: ELSE
6113:
6114: l_old_value := p_ctr_rec.old_value;
6115: l_stmt := l_select||' , :l_old_value old_value'||
6116: l_from||' ,oks_k_headers_v oksh '||
6117: l_where||' AND oksh.chr_id = okh.id
6118: AND nvl(oksh.renewal_po_required,''N'') = :p_ctr_rec_old_value
6119: AND okh.id in(
6120: SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 6136: l_from||' ,oks_k_headers_v oksh '||

6132:
6133: IF p_ctr_rec.old_value = '-1111' THEN
6134: l_old_value := p_ctr_rec.old_value;
6135: l_stmt := l_select||' , :l_old_value old_value'||
6136: l_from||' ,oks_k_headers_v oksh '||
6137: l_where||' AND oksh.chr_id = okh.id
6138: AND okh.id in(
6139: SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
6140: WHERE okg1.included_chr_id is not null

Line 6150: l_from||' ,oks_k_headers_v oksh '||

6146:
6147: ELSE
6148: l_old_value := p_ctr_rec.old_value;
6149: l_stmt := l_select||' , :l_old_value old_value'||
6150: l_from||' ,oks_k_headers_v oksh '||
6151: l_where||' AND oksh.chr_id = okh.id
6152: AND nvl(oksh.inv_print_profile,''N'') = :p_ctr_rec_old_value
6153: AND okh.id in(
6154: SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 6983: FROM oks_k_headers_v 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
6983: FROM oks_k_headers_v oksh
6984: WHERE oksh.chr_id = p_chr_id
6985: AND nvl(oksh.renewal_po_required,'N') = p_old_value ;
6986:
6987: CURSOR Get_agreement_name(p_chr_id IN Number, p_old_value IN Varchar2) IS