[Home] [Help]
10052: -- first check whether the payment function is populated or not
10053: begin
10054: select count(1)
10055: into l_count
10056: from IBY_USER_PAY_FUNS_GT;
10057: exception
10058: WHEN OTHERS THEN
10059:
10060: /* now rows means success */
10083: fnd_global.user_name);
10084:
10085: if(l_bool) then
10086: --print_debuginfo(l_module_name, 'User has access to:' || l_func);
10087: insert into IBY_USER_PAY_FUNS_GT(payment_function)
10088: values(l_func);
10089: end if;
10090: end loop;
10091: close c_pay_function;
10163: where object_id=p_object_id
10164: and object_type=p_object_type
10165: and pfun.payment_function not in
10166: (select payment_function
10167: from IBY_USER_PAY_FUNS_GT
10168: );
10169: print_debuginfo(l_module_name, 'Number of Missing Payment Function:' ||l_function_count);
10170:
10171: select count(1)
11522: 'REMOVED_PAYMENT_VOIDED')
11523: AND docs.payment_service_request_id = p_pay_service_request_id
11524: and docs.payment_function not in
11525: (select payment_function
11526: from IBY_USER_PAY_FUNS_GT
11527: );
11528: print_debuginfo(l_module_name, 'Number of Missing Payment Function for rejected documents:' ||l_doc_function_count);
11529:
11530: select count(1)