APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 368: PROCEDURE INSERT_PAYEE_ROW(ext_payee_rec IN IBY_EXTERNAL_PAYEES_ALL%ROWTYPE,

364: FND_MSG_PUB.ADD;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: END MERGE_BANKS;
367:
368: PROCEDURE INSERT_PAYEE_ROW(ext_payee_rec IN IBY_EXTERNAL_PAYEES_ALL%ROWTYPE,
369: P_EXT_PAYEE_ID IN OUT NOCOPY NUMBER,
370: x_return_status OUT NOCOPY VARCHAR2 ,
371: X_MSG_COUNT IN OUT NOCOPY NUMBER,
372: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 376: SELECT IBY_EXTERNAL_PAYEES_ALL_S.NEXTVAL

372: X_MSG_DATA OUT NOCOPY VARCHAR2)
373: IS
374:
375: CURSOR get_next_ext_payee_id IS
376: SELECT IBY_EXTERNAL_PAYEES_ALL_S.NEXTVAL
377: FROM DUAL;
378:
379: BEGIN
380: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 386: INSERT INTO IBY_EXTERNAL_PAYEES_ALL(

382: OPEN get_next_ext_payee_id;
383: FETCH get_next_ext_payee_id INTO P_EXT_PAYEE_ID;
384: CLOSE get_next_ext_payee_id;
385:
386: INSERT INTO IBY_EXTERNAL_PAYEES_ALL(
387: EXT_PAYEE_ID,
388: PAYEE_PARTY_ID,
389: PAYMENT_FUNCTION,
390: EXCLUSIVE_PAYMENT_FLAG,

Line 472: FROM IBY_EXTERNAL_PAYEES_ALL

468: )IS
469:
470: CURSOR cur_get_payee_dtls (cp_ext_payee_id IN NUMBER) IS
471: SELECT *
472: FROM IBY_EXTERNAL_PAYEES_ALL
473: WHERE ext_payee_id = cp_ext_payee_id;
474:
475: ext_payee_tab IBY_DISBURSEMENT_SETUP_PUB.External_Payee_Tab_Type;
476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;

Line 480: l_Ext_payee_rec IBY_EXTERNAL_PAYEES_ALL%ROWTYPE;

476: ext_payee_id_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Id_Tab_Type;
477: ext_payee_create_tab IBY_DISBURSEMENT_SETUP_PUB.Ext_Payee_Create_Tab_Type;
478:
479: l_Disb_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
480: l_Ext_payee_rec IBY_EXTERNAL_PAYEES_ALL%ROWTYPE;
481:
482: l_pay_return_status VARCHAR2(50);
483: l_pay_msg_count NUMBER;
484: l_pay_msg_data VARCHAR2(1000);

Line 554: Iby_external_payees_all payee

550: Payee.ext_payee_id,
551: Uses.instrument_id bank_account_id
552: FROM
553: Iby_pmt_instr_uses_all uses,
554: Iby_external_payees_all payee
555: WHERE
556: Payee.ext_payee_id = uses.ext_pmt_party_id
557: AND uses.payment_function = 'PAYABLES_DISB'
558: AND uses.payment_flow = 'DISBURSEMENTS'

Line 573: FROM Iby_external_payees_all payee

569: WHERE vendor_site_id = cp_vendor_site_id;
570:
571: CURSOR cur_get_ext_payee_id (cp_party_id IN NUMBER, cp_vendor_site_id IN NUMBER, cp_party_site_id IN NUMBER, cp_org_id IN NUMBER, cp_org_type IN VARCHAR2) IS
572: SELECT ext_payee_id
573: FROM Iby_external_payees_all payee
574: WHERE payee.payee_party_id = cp_party_id
575: AND (((payee.supplier_site_id IS NULL) AND (cp_vendor_site_id IS NULL)) OR (payee.supplier_site_id = cp_vendor_site_id))
576: AND (((payee.party_site_id IS NULL) AND (cp_party_site_id IS NULL)) OR (payee.party_site_id = cp_party_site_id))
577: AND (((payee.org_id IS NULL) AND (cp_org_id IS NULL)) OR (payee.org_id = cp_org_id))

Line 827: FROM Iby_external_payees_all

823: UPDATE iby_pmt_instr_uses_all
824: SET end_date = SYSDATE
825: WHERE ext_pmt_party_id IN
826: (SELECT ext_payee_id
827: FROM Iby_external_payees_all
828: WHERE payee_party_id = P_from_party_id
829: AND supplier_site_id = P_from_vendor_site_id )
830: AND payment_function = 'PAYABLES_DISB'
831: AND payment_flow = 'DISBURSEMENTS'