eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_TRXN_PUB dependencies on FND_APPLICATION

Line 316: (p_app_short_name IN fnd_application.application_short_name%TYPE,

312: RETURN l_mode;
313: END Get_Extension_Encrypt_Mode;
314:
315: FUNCTION Get_Tangible_Id
316: (p_app_short_name IN fnd_application.application_short_name%TYPE,
317: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
318: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
319: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
320: )

Line 348: (p_app_short_name IN fnd_application.application_short_name%TYPE,

344: END Get_Tangible_Id;
345:
346: --Overloading this function for bug : 7628586
347: FUNCTION Get_Tangible_Id
348: (p_app_short_name IN fnd_application.application_short_name%TYPE,
349: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
350: )
351: RETURN iby_trxn_summaries_all.tangibleid%TYPE
352: IS

Line 388: p_app_short_name IN fnd_application.application_short_name%TYPE,

384: -- [lmallick]
385: -- New Function to generate PSON for a re-authorization
386: FUNCTION Get_Reauth_Tangible_Id
387: (
388: p_app_short_name IN fnd_application.application_short_name%TYPE,
389: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
390: )
391: RETURN iby_trxn_summaries_all.tangibleid%TYPE
392: IS

Line 2813: l_app_short_name fnd_application.application_short_name%TYPE;

2809: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2810: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2811:
2812: l_ecapp_id NUMBER;
2813: l_app_short_name fnd_application.application_short_name%TYPE;
2814: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2815: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2816: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2817: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 2860: iby_external_payers_all p, fnd_application a,

2856: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2857: x.voice_authorization_date, i.card_single_use_flag,
2858: NVL(x.instr_assignment_id,0), x.payment_channel_code
2859: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2860: iby_external_payers_all p, fnd_application a,
2861: iby_fndcpt_pmt_chnnls_b pc
2862: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2863: AND (x.payment_channel_code = pc.payment_channel_code)
2864: AND (x.origin_application_id = a.application_id)

Line 3792: l_app_short_name fnd_application.application_short_name%TYPE;

3788: lx_msg_count NUMBER;
3789: lx_msg_data VARCHAR2(3000);
3790:
3791:
3792: l_app_short_name fnd_application.application_short_name%TYPE;
3793: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3794: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3795: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3796: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 3825: iby_external_payers_all p, fnd_application a,

3821: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
3822: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3823: x.payment_channel_code
3824: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3825: iby_external_payers_all p, fnd_application a,
3826: iby_fndcpt_pmt_chnnls_b pc
3827: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3828: AND (x.payment_channel_code = pc.payment_channel_code)
3829: -- can assume this assignment is for funds capture

Line 4529: fnd.application_short_name

4525: -- Get the shortname of the calling app from the calling
4526: -- app id.
4527: --
4528: SELECT
4529: fnd.application_short_name
4530: INTO
4531: l_app_short_name
4532: FROM
4533: FND_APPLICATION fnd

Line 4533: FND_APPLICATION fnd

4529: fnd.application_short_name
4530: INTO
4531: l_app_short_name
4532: FROM
4533: FND_APPLICATION fnd
4534: WHERE
4535: fnd.application_id = p_calling_app_id;
4536:
4537: -- Read view name from parameter p_order_view_name

Line 4535: fnd.application_id = p_calling_app_id;

4531: l_app_short_name
4532: FROM
4533: FND_APPLICATION fnd
4534: WHERE
4535: fnd.application_id = p_calling_app_id;
4536:
4537: -- Read view name from parameter p_order_view_name
4538: -- if present
4539: IF (p_order_view_name is null) THEN

Line 5622: l_app_short_name fnd_application.application_short_name%TYPE;

5618: l_returned_flag VARCHAR2(1);
5619: l_extension_found BOOLEAN;
5620:
5621: l_ecapp_id NUMBER;
5622: l_app_short_name fnd_application.application_short_name%TYPE;
5623: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
5624: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
5625: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
5626: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;

Line 5661: fnd_application a

5657: FROM iby_trxn_extensions_v x,
5658: iby_fndcpt_tx_extensions xt,
5659: -- iby_pmt_instr_uses_all i,
5660: iby_external_payers_all p,
5661: fnd_application a
5662: -- [lmallick] - Validate the payer context against the payer
5663: -- stamped on the extension. Not the assignment.
5664: WHERE --(x.instr_assignment_id = i.instrument_payment_use_id)
5665: -- can assume this assignment is for funds capture

Line 6066: l_app_short_name fnd_application.application_short_name%TYPE;

6062: l_instrtype IBY_FNDCPT_PMT_CHNNLS_B.instrument_type%TYPE;
6063: l_encrypted VARCHAR2(1);
6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6066: l_app_short_name fnd_application.application_short_name%TYPE;
6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;

Line 6122: fnd_application a,

6118: xt.instrument_security_code, xt.encrypted,
6119: xt.instr_code_sec_segment_id, xt.instr_sec_code_length
6120: FROM iby_fndcpt_tx_extensions xt,
6121: iby_external_payers_all p,
6122: fnd_application a,
6123: iby_fndcpt_pmt_chnnls_b chnl
6124: WHERE (xt.origin_application_id = a.application_id)
6125: AND (xt.EXT_PAYER_ID = p.ext_payer_id)
6126: AND (xt.trxn_extension_id = ci_extension_id)