DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on AP_BATCHES

Line 131: X_batch_name ap_batches.batch_name%TYPE;

127: X_received_amount NUMBER := 0;
128:
129: /*Bug# 1539257 */
130: X_tmp_batch_id NUMBER;
131: X_batch_name ap_batches.batch_name%TYPE;
132:
133:
134: /* Bug:396027. gtummala. 10/17/96
135: * Now the cursor picks up previously REJECTED transactions as well

Line 1493: SELECT ap_batches_s.nextval

1489: /*Bug# 1539257 Building the batch name which was earlier NA */
1490: fnd_message.set_name('PO', 'PO_INV_CR_ERS_BATCH_DESC');
1491: X_batch_name := fnd_message.get;
1492:
1493: SELECT ap_batches_s.nextval
1494: INTO X_tmp_batch_id
1495: FROM dual;
1496:
1497: /* need to commit before we submit another conc request, since

Line 2781: l_batch_name ap_batches.batch_name%TYPE;

2777: l_group_id ap_invoices_interface.group_id%TYPE;
2778: l_user_id NUMBER;
2779: l_login_id NUMBER;
2780: l_tmp_batch_id NUMBER;
2781: l_batch_name ap_batches.batch_name%TYPE;
2782: l_request_id ap_invoices_interface.request_id%TYPE;
2783:
2784: l_error_msg VARCHAR2(2000);
2785: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3205: SELECT ap_batches_s.nextval

3201: IF (g_asn_debug = 'Y') THEN
3202: ASN_DEBUG.put_line('Call invoice import program');
3203: END IF;
3204:
3205: SELECT ap_batches_s.nextval
3206: INTO l_tmp_batch_id
3207: FROM sys.dual;
3208:
3209: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_BATCH_DESC');