17: -- CURSOR check_override_function(cp_party_id NUMBER)
18: -- IS
19: -- SELECT 'X'
20: -- FROM fnd_form_functions functions,
21: -- fnd_user users,
22: -- fnd_menu_entries role_privileges,
23: -- fnd_responsibility resp,
24: -- fnd_user_resp_groups user_resps
25: -- WHERE users.customer_id=cp_party_id
20: -- FROM fnd_form_functions functions,
21: -- fnd_user users,
22: -- fnd_menu_entries role_privileges,
23: -- fnd_responsibility resp,
24: -- fnd_user_resp_groups user_resps
25: -- WHERE users.customer_id=cp_party_id
26: -- AND user_resps.start_date<= sysdate
27: -- AND nvl( user_resps.end_date,sysdate+1 ) >= sysdate
28: -- AND users.user_id=user_resps.user_id
613:
614:
615: CURSOR get_party_id(cp_user_id NUMBER) IS
616: SELECT customer_id
617: FROM fnd_user
618: WHERE user_id=cp_user_id;
619:
620: BEGIN
621:
751:
752:
753: CURSOR get_party_id(cp_user_id NUMBER) IS
754: SELECT customer_id
755: FROM fnd_user
756: WHERE user_id=cp_user_id;
757: BEGIN
758:
759: OPEN get_party_id (cp_user_id => p_user_id);
1046: -- END OF comments
1047: l_party_id NUMBER;
1048: CURSOR get_party_id(cp_user_id NUMBER) IS
1049: SELECT customer_id
1050: FROM fnd_user
1051: WHERE user_id=cp_user_id;
1052:
1053: BEGIN
1054: