709: || 'icr.group_by_rfc , '
710: || 'icr.group_by_payment_method '
711: || 'FROM '
712: || 'IBY_PAYMENTS_SEC_V pmts, '
713: || 'IBY_INSTR_CREATION_RULES icr, '
714: || 'IBY_PAY_SERVICE_REQUESTS prq, '
715: || 'IBY_SYS_PMT_PROFILES_B sppf, '
716: || 'IBY_ACCT_PMT_PROFILES_B appf, '
717: || 'HZ_PARTIES branch_party, '
5645: l_module_name VARCHAR2(200) := G_PKG_NAME || '.retrieveSortingOptions';
5646:
5647: /*
5648: * Cursor to pick up all available profiles with their sorting
5649: * options from the IBY_INSTR_CREATION_RULES table.
5650: */
5651: CURSOR c_sorting_options
5652: IS
5653: SELECT
5658: sort_order_2,
5659: sort_option_3,
5660: sort_order_3
5661: FROM
5662: IBY_INSTR_CREATION_RULES;
5663:
5664: BEGIN
5665:
5666: print_debuginfo(l_module_name, 'ENTER');
5674:
5675: IF (x_sortOptionsTab.COUNT = 0) THEN
5676:
5677: print_debuginfo(l_module_name, 'No records were found in '
5678: || 'IBY_INSTR_CREATION_RULES. Exiting .. '
5679: );
5680:
5681: print_debuginfo(l_module_name, 'EXIT');
5682:
6662: l_module_name VARCHAR2(200) := G_PKG_NAME || '.retrieveSortOptionForProfile';
6663:
6664: /*
6665: * Cursor to pick up the sorting options for the given
6666: * profile from the IBY_INSTR_CREATION_RULES table.
6667: */
6668: CURSOR c_sorting_options
6669: IS
6670: SELECT
6675: icr.sort_order_2,
6676: icr.sort_option_3,
6677: icr.sort_order_3
6678: FROM
6679: IBY_INSTR_CREATION_RULES icr,
6680: IBY_PAYMENT_PROFILES prof
6681: WHERE
6682: prof.payment_profile_id = p_profile_id AND
6683: icr.system_profile_code = prof.system_profile_code
6696:
6697: IF (x_sortOptionsTab.COUNT = 0) THEN
6698:
6699: print_debuginfo(l_module_name, 'No records were found in '
6700: || 'IBY_INSTR_CREATION_RULES. Exiting .. '
6701: );
6702:
6703: print_debuginfo(l_module_name, 'EXIT');
6704: