DBA Data[Home] [Help]

APPS.IBY_IMPORT_PMT_ACK_DATA_PUB dependencies on IBY_ACK_PMT_ERRORS

Line 333: -- Inserting record in to IBY_ACK_PMT_ERRORS

329: ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
330: );
331:
332:
333: -- Inserting record in to IBY_ACK_PMT_ERRORS
334: IF ( P_P_REJECT_DTLS_TBL_TYPE IS NOT NULL) THEN
335: IF P_P_REJECT_DTLS_TBL_TYPE.COUNT > 0 THEN
336: l_counter := P_P_REJECT_DTLS_TBL_TYPE.FIRST;
337:

Line 340: INSERT INTO iby_ack_pmt_errors

336: l_counter := P_P_REJECT_DTLS_TBL_TYPE.FIRST;
337:
338: WHILE (l_counter <= P_P_REJECT_DTLS_TBL_TYPE.LAST)
339: LOOP
340: INSERT INTO iby_ack_pmt_errors
341: ( ack_pmt_error_id , ack_pmt_id , bank_error_code ,bank_error_message , bank_error_location
342: , created_by,creation_date,last_updated_by,last_update_date,last_update_login
343: )
344: VALUES

Line 345: ( IBY_ACK_PMT_ERRORS_S.NEXTVAL, l_ack_pmt_id , P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_CODE

341: ( ack_pmt_error_id , ack_pmt_id , bank_error_code ,bank_error_message , bank_error_location
342: , created_by,creation_date,last_updated_by,last_update_date,last_update_login
343: )
344: VALUES
345: ( IBY_ACK_PMT_ERRORS_S.NEXTVAL, l_ack_pmt_id , P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_CODE
346: ,P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_MESSAGE ,P_P_REJECT_DTLS_TBL_TYPE(l_counter).BANK_ERROR_LOCATION
347: ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id
348: );
349: