APPS.OKL_PAY_INVOICES_TRANS_PUB dependencies on AP_INVOICES_INTERFACE

Line 83: select count(*) into l_count1 from ap_invoices_interface;

79: lx_return_status VARCHAR(1);
80:
81: BEGIN
82:
83: select count(*) into l_count1 from ap_invoices_interface;
84:
85: transfer ( p_api_version => l_api_vesrions,
86: p_init_msg_list => OKC_API.G_FALSE,
87: x_return_status => lx_return_status,

Line 91: select count(*) into l_count2 from ap_invoices_interface;

87: x_return_status => lx_return_status,
88: x_msg_count => lx_msg_count,
89: x_msg_data => errbuf);
90:
91: select count(*) into l_count2 from ap_invoices_interface;
92: l_count := l_count2 - l_count1;
93:
94: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Payables Invoices Transfer to AP');
95: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

Line 97: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoices Prepared in ap_invoices_interface :'||l_count);

93:
94: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Payables Invoices Transfer to AP');
95: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
96: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);
97: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoices Prepared in ap_invoices_interface :'||l_count);
98: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
99:
100:
101: END;