APPS.OKL_PAY_INVOICES_DISB_PUB dependencies on OKL_TRX_AP_INVOICES_B

Line 108: SELECT count(*) INTO l_count1 FROM OKL_TRX_AP_INVOICES_B;

104: IF p_to_date IS NOT NULL THEN
105: l_to_date := FND_DATE.CANONICAL_TO_DATE(p_to_date);
106: END IF;
107:
108: SELECT count(*) INTO l_count1 FROM OKL_TRX_AP_INVOICES_B;
109:
110: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Pay Invoices Creation By Auto-Disbursement from Consolidated Invoices');
111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
112: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||sysdate);

Line 130: SELECT count(*) INTO l_count2 FROM OKL_TRX_AP_INVOICES_B;

126: p_to_date => l_to_date,
127: p_contract_number => p_contract_number
128: );
129:
130: SELECT count(*) INTO l_count2 FROM OKL_TRX_AP_INVOICES_B;
131:
132: l_count := l_count2 - l_count1;
133:
134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));

Line 134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));

130: SELECT count(*) INTO l_count2 FROM OKL_TRX_AP_INVOICES_B;
131:
132: l_count := l_count2 - l_count1;
133:
134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));
135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));
136:
137:
138: IF lx_msg_count >= 1 THEN

Line 135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));

131:
132: l_count := l_count2 - l_count1;
133:
134: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines Created in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count));
135: --FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Number of Invoice Lines in OKL_TRX_AP_INVOICES_B :'||TO_CHAR(l_count2));
136:
137:
138: IF lx_msg_count >= 1 THEN
139: FOR i in 1..lx_msg_count LOOP