APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_MTAX_HDRS_ALL_S

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

1020: ', p_process_partial -> '||p_process_partial
1021: );
1022: END IF;
1023:
1024: --SELECT JAI_CMN_MTAX_HDRS_ALL_S.nextval INTO v_batch_id FROM dual;
1025:
1026: -- Entry into mass tax change requests table.
1027: INSERT INTO JAI_CMN_MTAX_HDRS_ALL
1028: (

Line 1060: JAI_CMN_MTAX_HDRS_ALL_S.nextval,

1056: )
1057: VALUES
1058: (
1059: --v_batch_id,
1060: JAI_CMN_MTAX_HDRS_ALL_S.nextval,
1061: ln_org_id,
1062: p_document_type,
1063: p_from_date,
1064: p_to_date,

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

1113: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1114: UTL_FILE.fclose(v_myfilehandle);
1115: END IF;
1116:
1117: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1118:
1119: COMMIT;
1120: RETURN;
1121: END IF;

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

1212: UTL_FILE.PUT_LINE(v_myfilehandle, v_message);
1213: UTL_FILE.fclose(v_myfilehandle);
1214: END IF;
1215:
1216: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
1217:
1218: COMMIT;
1219: RETURN;
1220: END IF;

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

3595: UTL_FILE.fclose(v_myfilehandle);
3596: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
3597: END IF;
3598: v_message := SQLERRM;
3599: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
3600:
3601: p_ret_code := 1;
3602: p_err_buf := v_message;
3603: