DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_MTAX_HDRS_ALL_S

Line 1374: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;

1370: ', p_process_partial -> '||p_process_partial
1371: );
1372: END IF;
1373:
1374: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1375:
1376: -- Entry into mass tax change requests table.
1377: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1378: (

Line 1410: JAI_CMN_MTAX_HDRS_ALL_S.nextval,

1406: )
1407: VALUES
1408: (
1409: --v_batch_id,
1410: JAI_CMN_MTAX_HDRS_ALL_S.nextval,
1411: ln_org_id,
1412: p_document_type,
1413: p_from_date,
1414: p_to_date,

Line 1471: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

1467: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1468: UTL_FILE.fclose(v_myfilehandle);
1469: END IF;
1470:
1471: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1472:
1473: COMMIT;
1474: RETURN;
1475: END IF;

Line 1577: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

1573: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1574: UTL_FILE.fclose(v_myfilehandle);
1575: END IF;
1576:
1577: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1578:
1579: COMMIT;
1580: RETURN;
1581: END IF;

Line 4746: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;

4742: UTL_FILE.fclose(v_myfilehandle);
4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
4744: END IF;
4745: v_message := SQLERRM;
4746: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
4747:
4748: p_ret_code := 1;
4749: p_err_buf := v_message;
4750: