DBA Data[Home] [Help]

APPS.IBY_IMPORT_PMT_ACK_DATA_PUB dependencies on FND_GLOBAL

Line 219: WHERE APPLICATION_ID = FND_GLOBAL.resp_appl_id;

215:
216: CURSOR get_app_name IS
217: SELECT APPLICATION_SHORT_NAME
218: FROM FND_APPLICATION
219: WHERE APPLICATION_ID = FND_GLOBAL.resp_appl_id;
220:
221: l_access NUMBER;
222: BEGIN
223:

Line 329: ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id

325: ,P_PAYEE_NAME,P_PAYEE_BANK_NAME,P_PAYEE_BANK_BRANCH_NAME,P_PAYEE_BANK_SWIFT_CODE,P_PAYEE_BANK_ACCOUNT_NUMBER,P_PAYEE_BANK_IBAN_NUMBER
326: ,P_PAYMENT_AMOUNT,P_BANK_CHARGE_AMOUNT,P_PAYMENT_CURRENCY_CODE
327: ,P_EXCHANGE_RATE,l_calculated_amt,l_calculated_bank_charge_amt
328: ,P_VALUE_DATE,P_REQUESTED_EXECUTION_DATE
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

Line 347: ,fnd_global.user_id,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.login_id

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:
350: l_counter := l_counter + 1;
351: END LOOP;