[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_UPLOAD',g_qp_batch_size);
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;
283:
284: select hsecs into l_start_time from v$timer;
285: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
286:
287: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
288: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
289:
290: write_log('Source system code (Profile) :'||l_source_system_code);
291: write_log('PTE_Code (Profile) :'||l_pte_code);
284: select hsecs into l_start_time from v$timer;
285: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
286:
287: FND_PROFILE.GET('QP_SOURCE_SYSTEM_CODE', l_source_system_code);
288: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
289:
290: write_log('Source system code (Profile) :'||l_source_system_code);
291: write_log('PTE_Code (Profile) :'||l_pte_code);
292:
3435:
3436: --child threads request id
3437: write_log( '-----Begining of Child Process-----');
3438:
3439: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
3440:
3441: write_log( 'Request ID: '||l_request_id);
3442:
3443: -- Update PBH child lines with request id.