DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on FND_APPLICATION

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

262: RETURN l_mode;
263: END Get_Extension_Encrypt_Mode;
264:
265: FUNCTION Get_Tangible_Id
266: (p_app_short_name IN fnd_application.application_short_name%TYPE,
267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )

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

285: END Get_Tangible_Id;
286:
287: --Overloading this function for bug : 7628586
288: FUNCTION Get_Tangible_Id
289: (p_app_short_name IN fnd_application.application_short_name%TYPE,
290: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
291: )
292: RETURN iby_trxn_summaries_all.tangibleid%TYPE
293: IS

Line 2306: l_app_short_name fnd_application.application_short_name%TYPE;

2302: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2303: l_single_use iby_fndcpt_payer_assgn_instr_v.card_single_use_flag%TYPE;
2304:
2305: l_ecapp_id NUMBER;
2306: l_app_short_name fnd_application.application_short_name%TYPE;
2307: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
2308: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
2309: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
2310: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 2345: iby_external_payers_all p, fnd_application a,

2341: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
2342: x.voice_authorization_date, i.card_single_use_flag,
2343: NVL(x.instr_assignment_id,0), x.payment_channel_code
2344: FROM iby_fndcpt_tx_extensions x, iby_fndcpt_payer_assgn_instr_v i,
2345: iby_external_payers_all p, fnd_application a,
2346: iby_fndcpt_pmt_chnnls_b pc
2347: WHERE (x.instr_assignment_id = i.instr_assignment_id(+))
2348: AND (x.payment_channel_code = pc.payment_channel_code)
2349: AND (x.origin_application_id = a.application_id)

Line 3041: l_app_short_name fnd_application.application_short_name%TYPE;

3037: lx_msg_count NUMBER;
3038: lx_msg_data VARCHAR2(3000);
3039:
3040:
3041: l_app_short_name fnd_application.application_short_name%TYPE;
3042: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
3043: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
3044: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
3045: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;

Line 3074: iby_external_payers_all p, fnd_application a,

3070: x.po_number, x.voice_authorization_flag, x.voice_authorization_code,
3071: x.voice_authorization_date, NVL(x.instr_assignment_id,0),
3072: x.payment_channel_code
3073: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i,
3074: iby_external_payers_all p, fnd_application a,
3075: iby_fndcpt_pmt_chnnls_b pc
3076: WHERE (x.instr_assignment_id = i.instrument_payment_use_id(+))
3077: AND (x.payment_channel_code = pc.payment_channel_code)
3078: -- can assume this assignment is for funds capture

Line 3696: fnd.application_short_name

3692: -- Get the shortname of the calling app from the calling
3693: -- app id.
3694: --
3695: SELECT
3696: fnd.application_short_name
3697: INTO
3698: l_app_short_name
3699: FROM
3700: FND_APPLICATION fnd

Line 3700: FND_APPLICATION fnd

3696: fnd.application_short_name
3697: INTO
3698: l_app_short_name
3699: FROM
3700: FND_APPLICATION fnd
3701: WHERE
3702: fnd.application_id = p_calling_app_id;
3703:
3704: -- Read view name from parameter p_order_view_name

Line 3702: fnd.application_id = p_calling_app_id;

3698: l_app_short_name
3699: FROM
3700: FND_APPLICATION fnd
3701: WHERE
3702: fnd.application_id = p_calling_app_id;
3703:
3704: -- Read view name from parameter p_order_view_name
3705: -- if present
3706: IF (p_order_view_name is null) THEN

Line 4545: l_app_short_name fnd_application.application_short_name%TYPE;

4541: l_returned_flag VARCHAR2(1);
4542: l_extension_found BOOLEAN;
4543:
4544: l_ecapp_id NUMBER;
4545: l_app_short_name fnd_application.application_short_name%TYPE;
4546: l_order_id iby_fndcpt_tx_extensions.order_id%TYPE;
4547: l_trxn_ref1 iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE;
4548: l_trxn_ref2 iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE;
4549: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;

Line 4579: iby_external_payers_all p, fnd_application a

4575: x.origin_application_id, a.application_short_name,
4576: x.order_id, x.trxn_ref_number1, x.trxn_ref_number2,
4577: x.payment_channel_code
4578: FROM iby_trxn_extensions_v x, iby_pmt_instr_uses_all i,
4579: iby_external_payers_all p, fnd_application a
4580: WHERE (x.instr_assignment_id = i.instrument_payment_use_id)
4581: -- can assume this assignment is for funds capture
4582: AND (x.origin_application_id = a.application_id)
4583: AND (i.ext_pmt_party_id = p.ext_payer_id)