APPS.OKL_PAY_INVOICES_CONS_PUB dependencies on OKL_EXT_PAY_INVS_B

Line 118: SELECT count(*) INTO l_count1 FROM OKL_EXT_PAY_INVS_B;

114: IF p_to_date IS NOT NULL THEN
115: l_to_date := FND_DATE.CANONICAL_TO_DATE(p_to_date);
116: END IF;
117:
118: SELECT count(*) INTO l_count1 FROM OKL_EXT_PAY_INVS_B;
119:
120: consolidation( p_api_version => l_api_vesrions,
121: p_init_msg_list => OKC_API.G_FALSE,
122: x_return_status => lx_return_status,

Line 135: SELECT count(*) INTO l_count2 FROM OKL_EXT_PAY_INVS_B;

131: --end:| 24-APR-2007 cklee Disbursement changes for R12B |
132: p_from_date => l_from_date,
133: p_to_date => l_to_date);
134:
135: SELECT count(*) INTO l_count2 FROM OKL_EXT_PAY_INVS_B;
136: l_count := l_count2 - l_count1;
137:
138: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices');
139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

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

137:
138: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices');
139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
141: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoices Prepared in OKL_EXT_PAY_INVS_B :'||l_count);
142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
143: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Summary Success/Detailed Error Messages');
144:
145: IF lx_msg_count >= 1 THEN