2813: WHERE list_header_id = p_list_header_id;
2814:
2815: CURSOR c_resource_id(cv_source IN VARCHAR2) IS
2816: SELECT jtf.resource_id
2817: FROM JTF_RS_RESOURCE_EXTNS jtf,fnd_user fnd
2818: WHERE fnd.user_name = cv_source
2819: AND fnd.user_id = jtf.user_id;
2820:
2821:
2814:
2815: CURSOR c_resource_id(cv_source IN VARCHAR2) IS
2816: SELECT jtf.resource_id
2817: FROM JTF_RS_RESOURCE_EXTNS jtf,fnd_user fnd
2818: WHERE fnd.user_name = cv_source
2819: AND fnd.user_id = jtf.user_id;
2820:
2821:
2822: CURSOR c_uom ( p_product_id NUMBER
2815: CURSOR c_resource_id(cv_source IN VARCHAR2) IS
2816: SELECT jtf.resource_id
2817: FROM JTF_RS_RESOURCE_EXTNS jtf,fnd_user fnd
2818: WHERE fnd.user_name = cv_source
2819: AND fnd.user_id = jtf.user_id;
2820:
2821:
2822: CURSOR c_uom ( p_product_id NUMBER
2823: , p_org_id NUMBER) IS