DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_FUNDS_CAPTURE_ORDERS_V

Line 4203: from AR_FUNDS_CAPTURE_ORDERS_V

4199:
4200:
4201: select count(*)
4202: into l_count1
4203: from AR_FUNDS_CAPTURE_ORDERS_V
4204: where CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4205:
4206: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4207: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );

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

4202: into l_count1
4203: from AR_FUNDS_CAPTURE_ORDERS_V
4204: where CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4205:
4206: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4207: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4208: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4209: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4210: END IF;

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

4205:
4206: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4207: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4208: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4209: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4210: END IF;
4211:
4212: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
4213: p_api_version => 1.0,

Line 4217: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',

4213: p_api_version => 1.0,
4214: p_init_msg_list => FND_API.G_TRUE,
4215: p_calling_app_id => l_program_application_id,
4216: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4217: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4218: x_return_status => ls_return_status,
4219: x_msg_count => ls_msg_count,
4220: x_msg_data => ls_msg_data,
4221: x_responses => ls_response_rec_tab );

Line 4977: from AR_FUNDS_CAPTURE_ORDERS_V

4973:
4974:
4975: select count(*)
4976: into l_count1
4977: from AR_FUNDS_CAPTURE_ORDERS_V
4978: where CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4979:
4980: IF PG_DEBUG in ('Y', 'C') THEN
4981: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );

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

4977: from AR_FUNDS_CAPTURE_ORDERS_V
4978: where CALL_APP_SERVICE_REQ_CODE = 'AR_'||p_batch_id;
4979:
4980: IF PG_DEBUG in ('Y', 'C') THEN
4981: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4982: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4983: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4984: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4985: END IF;

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

4980: IF PG_DEBUG in ('Y', 'C') THEN
4981: fnd_file.put_line(FND_FILE.LOG, ' No of records in AR_FUNDS_CAPTURE_ORDERS_V ' || l_count1 );
4982: fnd_file.put_line(FND_FILE.LOG, 'p_calling_app_id ' || to_char(l_program_application_id) );
4983: fnd_file.put_line(FND_FILE.LOG, ' p_calling_app_request_code ' || 'AR_'||p_batch_id);
4984: fnd_file.put_line(FND_FILE.LOG, 'p_order_view_name ' || 'AR_FUNDS_CAPTURE_ORDERS_V' );
4985: END IF;
4986: END IF;
4987:
4988: IBY_FNDCPT_TRXN_PUB.Create_Settlements(

Line 4993: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',

4989: p_api_version => 1.0,
4990: p_init_msg_list => FND_API.G_TRUE,
4991: p_calling_app_id => l_program_application_id,
4992: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4993: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4994: x_return_status => ls_return_status,
4995: x_msg_count => ls_msg_count,
4996: x_msg_data => ls_msg_data,
4997: x_responses => ls_response_rec_tab );