[Home] [Help]
824: || 'icr.group_by_rfc , '
825: || 'icr.group_by_payment_method '
826: || 'FROM '
827: || 'IBY_PAYMENTS_SEC_V pmts, '
828: || 'IBY_INSTR_CREATION_RULES icr, '
829: || 'IBY_PAY_SERVICE_REQUESTS prq, '
830: || 'IBY_SYS_PMT_PROFILES_B sppf, '
831: || 'IBY_ACCT_PMT_PROFILES_B appf, '
832: || 'HZ_PARTIES branch_party, '
6269: l_module_name VARCHAR2(200) := G_PKG_NAME || '.retrieveSortingOptions';
6270:
6271: /*
6272: * Cursor to pick up all available profiles with their sorting
6273: * options from the IBY_INSTR_CREATION_RULES table.
6274: */
6275: CURSOR c_sorting_options
6276: IS
6277: SELECT
6282: sort_order_2,
6283: sort_option_3,
6284: sort_order_3
6285: FROM
6286: IBY_INSTR_CREATION_RULES;
6287:
6288: BEGIN
6289:
6290: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6301: IF (x_sortOptionsTab.COUNT = 0) THEN
6302:
6303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6304: print_debuginfo(l_module_name, 'No records were found in '
6305: || 'IBY_INSTR_CREATION_RULES. Exiting .. '
6306: );
6307:
6308: print_debuginfo(l_module_name, 'EXIT');
6309:
7340: l_module_name VARCHAR2(200) := G_PKG_NAME || '.retrieveSortOptionForProfile';
7341:
7342: /*
7343: * Cursor to pick up the sorting options for the given
7344: * profile from the IBY_INSTR_CREATION_RULES table.
7345: */
7346: CURSOR c_sorting_options
7347: IS
7348: SELECT
7353: icr.sort_order_2,
7354: icr.sort_option_3,
7355: icr.sort_order_3
7356: FROM
7357: IBY_INSTR_CREATION_RULES icr,
7358: IBY_PAYMENT_PROFILES prof
7359: WHERE
7360: prof.payment_profile_id = p_profile_id AND
7361: icr.system_profile_code = prof.system_profile_code
7377: IF (x_sortOptionsTab.COUNT = 0) THEN
7378:
7379: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7380: print_debuginfo(l_module_name, 'No records were found in '
7381: || 'IBY_INSTR_CREATION_RULES. Exiting .. '
7382: );
7383:
7384: print_debuginfo(l_module_name, 'EXIT');
7385: