[Home] [Help]
48: write_log('Duplicate Line Check: '||p_enable_dup_ln_check);
49:
50: G_QP_DEBUG := p_debug_on;
51: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug On: '||G_QP_DEBUG);
52: FND_PROFILE.GET('QP_BATCH_SIZE_FOR_BULK_IMPORT',g_qp_batch_size); --bug no. 9652756 - profile name was wrong
53: if g_qp_batch_size is NULL or g_qp_batch_size < 1 then
54: g_qp_batch_size := 1000;
55: end if;
56: write_log('Batch Size: '||to_char(g_qp_batch_size));
139:
140: IF p_spawned_request = 'N' or p_spawned_request IS NULL
141: THEN
142:
143: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
144: write_log('Parent Request Id: '||l_request_id);
145:
146: IF p_no_of_threads IS NULL THEN
147: l_no_of_threads := 1;
310: END IF;
311: --uncommenting below to include pattern changes and changes related to bug 8737735
312: --- jagan PL/SQL pattern engine
313: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
314: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' THEN
315: --bug 10634202
316: --for l_list_header_id in l_min_hdr_id..l_max_hdr_id
317: for l_lst_hdr_rec in (SELECT DISTINCT list_header_id
318: FROM qp_list_headers_b
395:
396: select hsecs into l_start_time from v$timer;
397: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
398:
399: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
400: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
401:
402: write_log('Source system code (Profile) :'||l_source_system_code);
403: write_log('PTE_Code (Profile) :'||l_pte_code);
396: select hsecs into l_start_time from v$timer;
397: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
398:
399: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
400: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
401:
402: write_log('Source system code (Profile) :'||l_source_system_code);
403: write_log('PTE_Code (Profile) :'||l_pte_code);
404:
3554:
3555: --child threads request id
3556: write_log( '-----Begining of Child Process-----');
3557:
3558: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
3559:
3560: write_log( 'Request ID: '||l_request_id);
3561:
3562: -- Update PBH child lines with request id.