[Home] [Help]
323: END IF;
324: END LOOP;
325:
326:
327: -- Create an entry in JL_BR_EILOG table
328: INSERT INTO JL_BR_EILOG (
329: OCCURRENCE_ID,
330: OCCURRENCE_DATE,
331: CUSTOMER_TRX_ID,
324: END LOOP;
325:
326:
327: -- Create an entry in JL_BR_EILOG table
328: INSERT INTO JL_BR_EILOG (
329: OCCURRENCE_ID,
330: OCCURRENCE_DATE,
331: CUSTOMER_TRX_ID,
332: ELECTRONIC_INV_STATUS,
336: LAST_UPDATE_LOGIN,
337: CREATION_DATE,
338: CREATED_BY)
339: VALUES
340: (JL_BR_EILOG_S.NEXTVAL,
341: P_OCCURRENCE_DATE,
342: P_CUSTOMER_TRX_ID,
343: P_ELECT_INV_STATUS,
344: P_MESSAGE_TEXT,