DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_FUNDS_CAPTURE_ORDERS_V

Line 4487: from AR_FUNDS_CAPTURE_ORDERS_V

4483:
4484:
4485: select count(*)
4486: into l_count1
4487: from AR_FUNDS_CAPTURE_ORDERS_V
4488: where SELECTED_REMITTANCE_BATCH_ID = p_batch_id and CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4489:
4490: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4491: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );

Line 4490: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );

4486: into l_count1
4487: from AR_FUNDS_CAPTURE_ORDERS_V
4488: where SELECTED_REMITTANCE_BATCH_ID = p_batch_id and CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4489:
4490: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4491: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4492: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4493: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4494: END IF;

Line 4493: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );

4489:
4490: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4491: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4492: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4493: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4494: END IF;
4495:
4496: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
4497: p_api_version => 1.0,

Line 4501: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',

4497: p_api_version => 1.0,
4498: p_init_msg_list => FND_API.G_TRUE,
4499: p_calling_app_id => l_program_application_id,
4500: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4501: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4502: x_return_status => ls_return_status,
4503: x_msg_count => ls_msg_count,
4504: x_msg_data => ls_msg_data,
4505: x_responses => ls_response_rec_tab );

Line 5253: from AR_FUNDS_CAPTURE_ORDERS_V

5249:
5250:
5251: select count(*)
5252: into l_count1
5253: from AR_FUNDS_CAPTURE_ORDERS_V
5254: where SELECTED_REMITTANCE_BATCH_ID = p_batch_id and CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
5255:
5256: IF PG_DEBUG in ('Y', 'C') THEN
5257: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );

Line 5257: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );

5253: from AR_FUNDS_CAPTURE_ORDERS_V
5254: where SELECTED_REMITTANCE_BATCH_ID = p_batch_id and CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
5255:
5256: IF PG_DEBUG in ('Y', 'C') THEN
5257: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
5258: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
5259: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
5260: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
5261: END IF;

Line 5260: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );

5256: IF PG_DEBUG in ('Y', 'C') THEN
5257: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
5258: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
5259: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
5260: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
5261: END IF;
5262: END IF;
5263:
5264: IBY_FNDCPT_TRXN_PUB.Create_Settlements(

Line 5269: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',

5265: p_api_version => 1.0,
5266: p_init_msg_list => FND_API.G_TRUE,
5267: p_calling_app_id => l_program_application_id,
5268: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
5269: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
5270: x_return_status => ls_return_status,
5271: x_msg_count => ls_msg_count,
5272: x_msg_data => ls_msg_data,
5273: x_responses => ls_response_rec_tab );