APPS.WIP_MOVE_TXN_INTERFACE_CLEANUP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  procedure fetch_and_delete(
    p_grp_id in     number,
    p_moves  in out nocopy wip_move_txn_interface_rec) is

    i number := 0;

Line: 11

    select
      TRANSACTION_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATED_BY_NAME,
      CREATION_DATE,
      CREATED_BY,
      CREATED_BY_NAME,
      LAST_UPDATE_LOGIN,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      GROUP_ID,
      SOURCE_CODE,
      SOURCE_LINE_ID,
      PROCESS_PHASE,
      PROCESS_STATUS,
      TRANSACTION_TYPE,
      ORGANIZATION_ID,
      ORGANIZATION_CODE,
      WIP_ENTITY_ID,
      WIP_ENTITY_NAME,
      ENTITY_TYPE,
      PRIMARY_ITEM_ID,
      LINE_ID,
      LINE_CODE,
      REPETITIVE_SCHEDULE_ID,
      TRANSACTION_DATE,
      ACCT_PERIOD_ID,
      FM_OPERATION_SEQ_NUM,
      FM_OPERATION_CODE,
      FM_DEPARTMENT_ID,
      FM_DEPARTMENT_CODE,
      FM_INTRAOPERATION_STEP_TYPE,
      TO_OPERATION_SEQ_NUM,
      TO_OPERATION_CODE,
      TO_DEPARTMENT_ID,
      TO_DEPARTMENT_CODE,
      TO_INTRAOPERATION_STEP_TYPE,
      TRANSACTION_QUANTITY,
      TRANSACTION_UOM,
      PRIMARY_QUANTITY,
      PRIMARY_UOM,
      SCRAP_ACCOUNT_ID,
      REASON_ID,
      REASON_NAME,
      REFERENCE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      qa_collection_id,
      overcompletion_transaction_id,
      overcompletion_transaction_qty,
      overcompletion_primary_qty
    from wip_move_txn_interface
    where group_id = c_grp_id;

Line: 103

      p_moves.LAST_UPDATE_DATE(i) := move_rec.LAST_UPDATE_DATE;

Line: 104

      p_moves.LAST_UPDATED_BY(i) := move_rec.LAST_UPDATED_BY;

Line: 105

      p_moves.LAST_UPDATED_BY_NAME(i) := move_rec.LAST_UPDATED_BY_NAME;

Line: 109

      p_moves.LAST_UPDATE_LOGIN(i) := move_rec.LAST_UPDATE_LOGIN;

Line: 113

      p_moves.PROGRAM_UPDATE_DATE(i) := move_rec.PROGRAM_UPDATE_DATE;

Line: 174

      delete from wip_move_txn_interface
      where group_id = p_grp_id;

Line: 177

  end fetch_and_delete;

Line: 179

  procedure insert_rows(
    p_moves in wip_move_txn_interface_rec) is
    i number := 1;

Line: 184

      insert into wip_move_txn_interface (
        TRANSACTION_ID,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATED_BY_NAME,
        CREATION_DATE,
        CREATED_BY,
        CREATED_BY_NAME,
        LAST_UPDATE_LOGIN,
        REQUEST_ID,
        PROGRAM_APPLICATION_ID,
        PROGRAM_ID,
        PROGRAM_UPDATE_DATE,
        GROUP_ID,
        SOURCE_CODE,
        SOURCE_LINE_ID,
        PROCESS_PHASE,
        PROCESS_STATUS,
        TRANSACTION_TYPE,
        ORGANIZATION_ID,
        ORGANIZATION_CODE,
        WIP_ENTITY_ID,
        WIP_ENTITY_NAME,
        ENTITY_TYPE,
        PRIMARY_ITEM_ID,
        LINE_ID,
        LINE_CODE,
        REPETITIVE_SCHEDULE_ID,
        TRANSACTION_DATE,
        ACCT_PERIOD_ID,
        FM_OPERATION_SEQ_NUM,
        FM_OPERATION_CODE,
        FM_DEPARTMENT_ID,
        FM_DEPARTMENT_CODE,
        FM_INTRAOPERATION_STEP_TYPE,
        TO_OPERATION_SEQ_NUM,
        TO_OPERATION_CODE,
        TO_DEPARTMENT_ID,
        TO_DEPARTMENT_CODE,
        TO_INTRAOPERATION_STEP_TYPE,
        TRANSACTION_QUANTITY,
        TRANSACTION_UOM,
        PRIMARY_QUANTITY,
        PRIMARY_UOM,
        SCRAP_ACCOUNT_ID,
        REASON_ID,
        REASON_NAME,
        REFERENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        qa_collection_id,
	overcompletion_transaction_id,
	overcompletion_transaction_qty,
	overcompletion_primary_qty
      ) values (
        p_moves.TRANSACTION_ID(i),
        p_moves.LAST_UPDATE_DATE(i),
        p_moves.LAST_UPDATED_BY(i),
        p_moves.LAST_UPDATED_BY_NAME(i),
        p_moves.CREATION_DATE(i),
        p_moves.CREATED_BY(i),
        p_moves.CREATED_BY_NAME(i),
        p_moves.LAST_UPDATE_LOGIN(i),
        p_moves.REQUEST_ID(i),
        p_moves.PROGRAM_APPLICATION_ID(i),
        p_moves.PROGRAM_ID(i),
        p_moves.PROGRAM_UPDATE_DATE(i),
        p_moves.GROUP_ID(i),
        p_moves.SOURCE_CODE(i),
        p_moves.SOURCE_LINE_ID(i),
        p_moves.PROCESS_PHASE(i),
        p_moves.PROCESS_STATUS(i),
        p_moves.TRANSACTION_TYPE(i),
        p_moves.ORGANIZATION_ID(i),
        p_moves.ORGANIZATION_CODE(i),
        p_moves.WIP_ENTITY_ID(i),
        p_moves.WIP_ENTITY_NAME(i),
        p_moves.ENTITY_TYPE(i),
        p_moves.PRIMARY_ITEM_ID(i),
        p_moves.LINE_ID(i),
        p_moves.LINE_CODE(i),
        p_moves.REPETITIVE_SCHEDULE_ID(i),
        p_moves.TRANSACTION_DATE(i),
        p_moves.ACCT_PERIOD_ID(i),
        p_moves.FM_OPERATION_SEQ_NUM(i),
        p_moves.FM_OPERATION_CODE(i),
        p_moves.FM_DEPARTMENT_ID(i),
        p_moves.FM_DEPARTMENT_CODE(i),
        p_moves.FM_INTRAOPERATION_STEP_TYPE(i),
        p_moves.TO_OPERATION_SEQ_NUM(i),
        p_moves.TO_OPERATION_CODE(i),
        p_moves.TO_DEPARTMENT_ID(i),
        p_moves.TO_DEPARTMENT_CODE(i),
        p_moves.TO_INTRAOPERATION_STEP_TYPE(i),
        p_moves.TRANSACTION_QUANTITY(i),
        p_moves.TRANSACTION_UOM(i),
        p_moves.PRIMARY_QUANTITY(i),
        p_moves.PRIMARY_UOM(i),
        p_moves.SCRAP_ACCOUNT_ID(i),
        p_moves.REASON_ID(i),
        p_moves.REASON_NAME(i),
        p_moves.REFERENCE(i),
        p_moves.ATTRIBUTE_CATEGORY(i),
        p_moves.ATTRIBUTE1(i),
        p_moves.ATTRIBUTE2(i),
        p_moves.ATTRIBUTE3(i),
        p_moves.ATTRIBUTE4(i),
        p_moves.ATTRIBUTE5(i),
        p_moves.ATTRIBUTE6(i),
        p_moves.ATTRIBUTE7(i),
        p_moves.ATTRIBUTE8(i),
        p_moves.ATTRIBUTE9(i),
        p_moves.ATTRIBUTE10(i),
        p_moves.ATTRIBUTE11(i),
        p_moves.ATTRIBUTE12(i),
        p_moves.ATTRIBUTE13(i),
        p_moves.ATTRIBUTE14(i),
        p_moves.ATTRIBUTE15(i),
        p_moves.QA_COLLECTION_ID(i),
	p_moves.overcompletion_transaction_id(i),
	p_moves.overcompletion_transaction_qty(i),
	p_moves.overcompletion_primary_qty(i)
      );

Line: 324

  end insert_rows;