338: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE
339: INDEX BY BINARY_INTEGER;
340:
341: TYPE t_bank_instruction1_code IS TABLE OF
342: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE
343: INDEX BY BINARY_INTEGER;
344: TYPE t_bank_instruction2_code IS TABLE OF
345: IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE
346: INDEX BY BINARY_INTEGER;
341: TYPE t_bank_instruction1_code IS TABLE OF
342: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE
343: INDEX BY BINARY_INTEGER;
344: TYPE t_bank_instruction2_code IS TABLE OF
345: IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE t_payment_text_message1 IS TABLE OF
348: IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE
349: INDEX BY BINARY_INTEGER;
344: TYPE t_bank_instruction2_code IS TABLE OF
345: IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE
346: INDEX BY BINARY_INTEGER;
347: TYPE t_payment_text_message1 IS TABLE OF
348: IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE
349: INDEX BY BINARY_INTEGER;
350: TYPE t_payment_text_message2 IS TABLE OF
351: IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE
352: INDEX BY BINARY_INTEGER;
347: TYPE t_payment_text_message1 IS TABLE OF
348: IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE
349: INDEX BY BINARY_INTEGER;
350: TYPE t_payment_text_message2 IS TABLE OF
351: IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE t_payment_text_message3 IS TABLE OF
354: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE
355: INDEX BY BINARY_INTEGER;
350: TYPE t_payment_text_message2 IS TABLE OF
351: IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE
352: INDEX BY BINARY_INTEGER;
353: TYPE t_payment_text_message3 IS TABLE OF
354: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE
355: INDEX BY BINARY_INTEGER;
356:
357: TYPE t_group_by_remittance_message IS TABLE OF
358: IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE
1020: | NOTES:
1021: |
1022: *---------------------------------------------------------------------*/
1023: FUNCTION derivePayeeIdFromContext(
1024: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1021: |
1022: *---------------------------------------------------------------------*/
1023: FUNCTION derivePayeeIdFromContext(
1024: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1022: *---------------------------------------------------------------------*/
1023: FUNCTION derivePayeeIdFromContext(
1024: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1030: )
1023: FUNCTION derivePayeeIdFromContext(
1024: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1030: )
1031: RETURN NUMBER;
1024: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1030: )
1031: RETURN NUMBER;
1032:
1025: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1026: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1027: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1028: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1029: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1030: )
1031: RETURN NUMBER;
1032:
1033: /*--------------------------------------------------------------------
1049: | NOTES:
1050: |
1051: *---------------------------------------------------------------------*/
1052: FUNCTION deriveExactPayeeIdFromContext(
1053: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1050: |
1051: *---------------------------------------------------------------------*/
1052: FUNCTION deriveExactPayeeIdFromContext(
1053: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1051: *---------------------------------------------------------------------*/
1052: FUNCTION deriveExactPayeeIdFromContext(
1053: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1059: )
1052: FUNCTION deriveExactPayeeIdFromContext(
1053: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1059: )
1060: RETURN NUMBER;
1053: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1059: )
1060: RETURN NUMBER;
1061:
1054: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1055: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1056: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1057: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1058: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1059: )
1060: RETURN NUMBER;
1061:
1062: /*--------------------------------------------------------------------