259: END;
260:
261: --this function is copied from qltsswfb.plb to get the user_name from a user_id
262: FUNCTION get_user_name(u_id IN NUMBER) RETURN VARCHAR2 IS
263: u_name fnd_user.user_name%TYPE;
264: cursor c IS
265: SELECT DISTINCT fu.user_name FROM
266: fnd_user fu
267: WHERE
262: FUNCTION get_user_name(u_id IN NUMBER) RETURN VARCHAR2 IS
263: u_name fnd_user.user_name%TYPE;
264: cursor c IS
265: SELECT DISTINCT fu.user_name FROM
266: fnd_user fu
267: WHERE
268: fu.user_id = u_id;
269: BEGIN
270: open c;
810: dest_id NUMBER;
811: child_id NUMBER;
812: l_request_id NUMBER;
813:
814: user_name fnd_user.user_name%TYPE := get_user_name(fnd_global.user_id);
815: --user_name fnd_user.user_name%TYPE := 'MFG';
816: CURSOR C1(parent_id NUMBER) IS
817: SELECT child_plan_id
818: FROM qa_pc_plan_relationship
811: child_id NUMBER;
812: l_request_id NUMBER;
813:
814: user_name fnd_user.user_name%TYPE := get_user_name(fnd_global.user_id);
815: --user_name fnd_user.user_name%TYPE := 'MFG';
816: CURSOR C1(parent_id NUMBER) IS
817: SELECT child_plan_id
818: FROM qa_pc_plan_relationship
819: WHERE parent_plan_id = parent_id;