[Home] [Help]
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
1127: | NOTES:
1128: |
1129: *---------------------------------------------------------------------*/
1130: FUNCTION derivePayeeIdFromContext(
1131: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1128: |
1129: *---------------------------------------------------------------------*/
1130: FUNCTION derivePayeeIdFromContext(
1131: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1129: *---------------------------------------------------------------------*/
1130: FUNCTION derivePayeeIdFromContext(
1131: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1137: )
1130: FUNCTION derivePayeeIdFromContext(
1131: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1137: )
1138: RETURN NUMBER;
1131: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1137: )
1138: RETURN NUMBER;
1139:
1132: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1133: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1134: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1135: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1136: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1137: )
1138: RETURN NUMBER;
1139:
1140: /*--------------------------------------------------------------------
1156: | NOTES:
1157: |
1158: *---------------------------------------------------------------------*/
1159: FUNCTION deriveExactPayeeIdFromContext(
1160: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1157: |
1158: *---------------------------------------------------------------------*/
1159: FUNCTION deriveExactPayeeIdFromContext(
1160: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1158: *---------------------------------------------------------------------*/
1159: FUNCTION deriveExactPayeeIdFromContext(
1160: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1166: )
1159: FUNCTION deriveExactPayeeIdFromContext(
1160: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1166: )
1167: RETURN NUMBER;
1160: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1166: )
1167: RETURN NUMBER;
1168:
1161: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
1162: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
1163: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
1164: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
1165: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
1166: )
1167: RETURN NUMBER;
1168:
1169: /*--------------------------------------------------------------------