APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 34: select currency_code into l_to_currency from ozf_sd_batch_headers_all

30: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;
31:
32: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
33:
34: select currency_code into l_to_currency from ozf_sd_batch_headers_all
35: where batch_id=(select batch_id from ozf_sd_batch_lines_all
36: where batch_line_id = p_batch_line_id);
37:
38: -- select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;

Line 814: FROM OZF_SD_BATCH_HEADERS_ALL

810: SAVEPOINT process_batch_adjust_claim_sv;
811:
812:
813: SELECT status_code,imd_claim_flag into l_status_code,l_imd_claim_flag
814: FROM OZF_SD_BATCH_HEADERS_ALL
815: WHERE BATCH_ID=p_batch_header_id ;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, '- imd_claim_flag for batch is '||l_imd_claim_flag );
818: FND_FILE.PUT_LINE(FND_FILE.LOG, '- for batch id '||p_batch_header_id||' status code is'||l_status_code);

Line 1100: UPDATE ozf_sd_batch_headers_all

1096:
1097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Changing status to Closed');
1098:
1099:
1100: UPDATE ozf_sd_batch_headers_all
1101: SET status_code = 'CLOSED'
1102: WHERE BATCH_ID = p_batch_header_id ;
1103:
1104: END IF ;

Line 1359: from OZF_SD_BATCH_HEADERS_ALL bh, FND_CONCURRENT_PROGRAMS cp , FND_CONCURRENT_REQUESTS cr

1355: l_phase_code VARCHAR2(1) := NULL;
1356:
1357: Cursor c_pen_close_batches (p_batch_id number) is
1358: select bh.status_code, cr.request_id, cr.phase_code
1359: from OZF_SD_BATCH_HEADERS_ALL bh, FND_CONCURRENT_PROGRAMS cp , FND_CONCURRENT_REQUESTS cr
1360: where cp.concurrent_program_name = 'OZFSDPBPPRG'
1361: and cp.concurrent_program_id = bh.program_id
1362: and cr.request_id(+) = bh.request_id
1363: and bh.batch_id = p_batch_id;

Line 1381: update ozf_sd_batch_headers_all

1377: -- True when the request in BH not found in FND_Concurrent_Reqeusts / The current request is the request tagged in BH / Last request has finshed processing.
1378: IF ( l_status_code ='PENDING_CLOSE'
1379: AND ( l_request_id is null OR l_request_id = FND_GLOBAL.CONC_REQUEST_ID OR l_phase_code = 'C')) THEN
1380:
1381: update ozf_sd_batch_headers_all
1382: set request_id = FND_GLOBAL.CONC_REQUEST_ID,
1383: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
1384: last_update_date = sysdate,
1385: last_updated_by = FND_GLOBAL.USER_ID,