[Home] [Help]
397: -- Create a batch for the the process --
398: --------------------------------------------------------------------
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
404:
405: -- Populate Batch table here
406: l_stmt_num := 35;
407:
408: INSERT INTO cst_ap_variance_batches
409: ( batch_id,
410: description,
411: organization_id,
412: item_option,
1123: ----------------------------------------------------------------------
1124:
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
1131: -- Populate Batch table here
1132: l_stmt_num := 35;
1133:
1134: INSERT INTO
1135: cst_ap_variance_batches
1136: (
1137: batch_id,
1138: organization_id,
1139: item_option,