APPS.OKL_REBOOK_CM_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 659: UPDATE okl_trx_ar_invoices_b

655: END IF;
656:
657:
658: IF (x_return_status <> 'S' ) THEN
659: UPDATE okl_trx_ar_invoices_b
660: SET trx_status_code = 'ERROR'
661: WHERE id = lx_taiv_rec.id;
662: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
663: ELSE

Line 677: UPDATE okl_trx_ar_invoices_b

673: FOR i in err_tbl.FIRST..err_tbl.LAST LOOP
674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(i).amount);
675:
676:
677: UPDATE okl_trx_ar_invoices_b
678: SET trx_status_code = 'ERROR'
679: WHERE id = err_tbl(i).tai_id;
680: END LOOP;
681:

Line 903: UPDATE okl_trx_ar_invoices_b

899: ||err_tbl(i).amount);
900: END IF;
901:
902:
903: UPDATE okl_trx_ar_invoices_b
904: SET trx_status_code = 'ERROR'
905: WHERE id = err_tbl(i).tai_id;
906: END LOOP;
907: ELSE

Line 914: --UPDATE okl_trx_ar_invoices_b

910: WHERE id = adj_streams_rec.sel_id;
911: END IF;
912:
913:
914: --UPDATE okl_trx_ar_invoices_b
915: --SET trx_status_code = 'ERROR'
916: --WHERE id = x_taiv_rec.id;
917: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
918: ELSE

Line 936: UPDATE okl_trx_ar_invoices_b

932: ||err_tbl(i).amount);
933: END IF;
934:
935:
936: UPDATE okl_trx_ar_invoices_b
937: SET trx_status_code = 'ERROR'
938: WHERE id = err_tbl(i).tai_id;
939: END LOOP;
940: ELSE

Line 1338: UPDATE okl_trx_ar_invoices_b

1334: END IF;
1335:
1336:
1337: IF (x_return_status <> 'S' ) THEN
1338: UPDATE okl_trx_ar_invoices_b
1339: SET trx_status_code = 'ERROR'
1340: WHERE id = lx_taiv_rec.id;
1341: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1342: ELSE

Line 1440: UPDATE okl_trx_ar_invoices_b

1436: END IF;
1437:
1438:
1439: IF (x_return_status <> 'S' ) THEN
1440: UPDATE okl_trx_ar_invoices_b
1441: SET trx_status_code = 'ERROR'
1442: WHERE id = lx_taiv_rec.id;
1443: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1444: ELSE

Line 2190: UPDATE okl_trx_ar_invoices_b

2186: END IF;
2187:
2188:
2189: IF (x_return_status <> 'S' ) THEN
2190: UPDATE okl_trx_ar_invoices_b
2191: SET trx_status_code = 'ERROR'
2192: WHERE id = lx_taiv_rec.id;
2193: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2194: ELSE

Line 2208: UPDATE okl_trx_ar_invoices_b

2204: FOR j in err_tbl.FIRST..err_tbl.LAST LOOP
2205: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(j).amount);
2206:
2207:
2208: UPDATE okl_trx_ar_invoices_b
2209: SET trx_status_code = 'ERROR'
2210: WHERE id = err_tbl(j).tai_id;
2211: END LOOP;
2212: END IF;

Line 2435: UPDATE okl_trx_ar_invoices_b

2431: ||err_tbl(j).amount);
2432: END IF;
2433:
2434:
2435: UPDATE okl_trx_ar_invoices_b
2436: SET trx_status_code = 'ERROR'
2437: WHERE id = err_tbl(j).tai_id;
2438: END LOOP;
2439: END IF;

Line 2442: --UPDATE okl_trx_ar_invoices_b

2438: END LOOP;
2439: END IF;
2440:
2441:
2442: --UPDATE okl_trx_ar_invoices_b
2443: --SET trx_status_code = 'ERROR'
2444: --WHERE id = x_taiv_rec.id;
2445: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2446: ELSE

Line 2464: UPDATE okl_trx_ar_invoices_b

2460: ||err_tbl(j).amount);
2461: END IF;
2462:
2463:
2464: UPDATE okl_trx_ar_invoices_b
2465: SET trx_status_code = 'ERROR'
2466: WHERE id = err_tbl(j).tai_id;
2467: END LOOP;
2468: END IF;

Line 2768: UPDATE okl_trx_ar_invoices_b

2764: END IF;
2765:
2766:
2767: IF (x_return_status <> 'S' ) THEN
2768: UPDATE okl_trx_ar_invoices_b
2769: SET trx_status_code = 'ERROR'
2770: WHERE id = lx_taiv_rec.id;
2771: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
2772: END IF;

Line 2869: UPDATE okl_trx_ar_invoices_b

2865: END IF;
2866:
2867:
2868: IF (x_return_status <> 'S' ) THEN
2869: UPDATE okl_trx_ar_invoices_b
2870: SET trx_status_code = 'ERROR'
2871: WHERE id = lx_taiv_rec.id;
2872: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions');
2873: END IF;