399: l_stmt_num := 30;
400:
401: SELECT cst_ap_variance_batches_s.nextval
402: INTO l_batch_id
403: FROM DUAL;
404:
405: -- Populate Batch table here
406: l_stmt_num := 35;
407:
1125: l_stmt_num := 30;
1126:
1127: SELECT cst_ap_variance_batches_s.nextval
1128: INTO l_batch_id
1129: FROM DUAL;
1130:
1131: -- Populate Batch table here
1132: l_stmt_num := 35;
1133:
1837: p_prog_app_id,
1838: p_prog_id,
1839: SYSDATE,
1840: p_login_id
1841: FROM DUAL
1842: );
1843:
1844: -- Debug statements -----------------------------------------------
1845: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.podist: '
2095: AND cavl.po_distribution_id = p_po_distribution_id;
2096:
2097: SELECT cst_ap_variance_headers_s.nextval
2098: INTO l_header_id
2099: FROM dual;
2100:
2101:
2102: l_stmt_num := 25;
2103: