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_DISBURSEMENT_SETUP_PUB dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 684: INSERT INTO IBY_EXT_PARTY_PMT_MTHDS

680: where payment_method_code=p_ext_payee_tab(counter).Default_Pmt_method;
681:
682: IF (l_pm_count>0) then
683: -- insert into the external payment method table
684: INSERT INTO IBY_EXT_PARTY_PMT_MTHDS
685: (EXT_PARTY_PMT_MTHD_ID,
686: PAYMENT_METHOD_CODE,
687: PAYMENT_FLOW,
688: EXT_PMT_PARTY_ID,

Line 700: IBY_EXT_PARTY_PMT_MTHDS_S.nextval,

696: OBJECT_VERSION_NUMBER
697: )
698: VALUES
699: (
700: IBY_EXT_PARTY_PMT_MTHDS_S.nextval,
701: p_ext_payee_tab(counter).Default_Pmt_method,
702: 'DISBURSEMENTS',
703: l_ext_payee_id,
704: p_ext_payee_tab(counter).Payment_function,

Line 2735: l_primary_flag iby_ext_party_pmt_mthds.primary_flag%TYPE;

2731: l_payee_cnt NUMBER;
2732: l_payee_id NUMBER;
2733: l_pm_count NUMBER;
2734: l_message FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2735: l_primary_flag iby_ext_party_pmt_mthds.primary_flag%TYPE;
2736:
2737: l_ext_payee_upd_rec Ext_Payee_Update_Rec_Type;
2738: l_payee_upd_status VARCHAR2(30);
2739:

Line 2932: UPDATE iby_ext_party_pmt_mthds

2928:
2929: -- update default payment method
2930: IF(p_ext_payee_tab(counter).Default_Pmt_method IS NULL) THEN
2931: BEGIN
2932: UPDATE iby_ext_party_pmt_mthds
2933: SET primary_flag = 'N',
2934: last_update_date = SYSDATE,
2935: last_updated_by = fnd_global.user_id,
2936: last_update_login = fnd_global.user_id,

Line 2957: FROM iby_ext_party_pmt_mthds

2953: -- payment method exists
2954: BEGIN
2955: SELECT primary_flag
2956: INTO l_primary_flag
2957: FROM iby_ext_party_pmt_mthds
2958: WHERE ext_pmt_party_id = p_ext_payee_id_tab(counter).ext_payee_id
2959: AND payment_function = p_ext_payee_tab(counter).payment_function
2960: AND payment_method_code=p_ext_payee_tab(counter).Default_Pmt_method;
2961:

Line 2964: INSERT INTO IBY_EXT_PARTY_PMT_MTHDS

2960: AND payment_method_code=p_ext_payee_tab(counter).Default_Pmt_method;
2961:
2962: EXCEPTION
2963: WHEN no_data_found THEN
2964: INSERT INTO IBY_EXT_PARTY_PMT_MTHDS
2965: (EXT_PARTY_PMT_MTHD_ID,
2966: PAYMENT_METHOD_CODE,
2967: PAYMENT_FLOW,
2968: EXT_PMT_PARTY_ID,

Line 2978: IBY_EXT_PARTY_PMT_MTHDS_S.nextval,

2974: LAST_UPDATE_DATE,
2975: LAST_UPDATE_LOGIN,
2976: OBJECT_VERSION_NUMBER
2977: ) VALUES (
2978: IBY_EXT_PARTY_PMT_MTHDS_S.nextval,
2979: p_ext_payee_tab(counter).Default_Pmt_method,
2980: 'DISBURSEMENTS',
2981: p_ext_payee_id_tab(counter).ext_payee_id,
2982: p_ext_payee_tab(counter).Payment_function,

Line 2996: UPDATE iby_ext_party_pmt_mthds

2992: END;
2993:
2994: -- update primary_flag for all rows.
2995: BEGIN
2996: UPDATE iby_ext_party_pmt_mthds
2997: SET primary_flag = DECODE(payment_method_code,
2998: p_ext_payee_tab(counter).Default_Pmt_method, 'Y', 'N'),
2999: last_update_date = SYSDATE, -- bug 13881024
3000: last_updated_by = fnd_global.user_id,