100: Recinfo.object_type_code,
101: Recinfo.employee_id,
102: 'FORWARD',
103: l_note,
104: fnd_global.user_id,
105: fnd_global.login_id
106: );
107:
108: l_progress := '015';
101: Recinfo.employee_id,
102: 'FORWARD',
103: l_note,
104: fnd_global.user_id,
105: fnd_global.login_id
106: );
107:
108: l_progress := '015';
109:
131: Recinfo.request_id,
132: Recinfo.program_application_id,
133: Recinfo.program_id,
134: Recinfo.program_date,
135: fnd_global.user_id,
136: fnd_global.login_id);
137:
138: l_progress := '040';
139:
132: Recinfo.program_application_id,
133: Recinfo.program_id,
134: Recinfo.program_date,
135: fnd_global.user_id,
136: fnd_global.login_id);
137:
138: l_progress := '040';
139:
140:
297: WHERE WFU.NAME = l_original_recipient
298: AND WFU.ORIG_SYSTEM NOT IN ('POS', 'ENG_LIST', 'CUST_CONT');
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: l_original_recipient_id := fnd_global.employee_id;
302: END;
303:
304: END IF;
305:
409: Recinfo.request_id,
410: Recinfo.program_application_id,
411: Recinfo.program_id,
412: Recinfo.program_date,
413: fnd_global.user_id,
414: fnd_global.login_id);
415:
416: l_progress := '040';
417:
410: Recinfo.program_application_id,
411: Recinfo.program_id,
412: Recinfo.program_date,
413: fnd_global.user_id,
414: fnd_global.login_id);
415:
416: l_progress := '040';
417:
418: commit;
514: Recinfo.request_id,
515: Recinfo.program_application_id,
516: Recinfo.program_id,
517: Recinfo.program_date,
518: fnd_global.user_id,
519: fnd_global.login_id);
520:
521: end if;
522:
515: Recinfo.program_application_id,
516: Recinfo.program_id,
517: Recinfo.program_date,
518: fnd_global.user_id,
519: fnd_global.login_id);
520:
521: end if;
522:
523: /*
558: Recinfo.object_type_code,
559: p_more_info_id,
560: 'NO ACTION',
561: NULL,
562: fnd_global.user_id,
563: fnd_global.login_id
564: );
565:
566: /*
559: p_more_info_id,
560: 'NO ACTION',
561: NULL,
562: fnd_global.user_id,
563: fnd_global.login_id
564: );
565:
566: /*
567: ** insert a new NULL row into PO_ACTION_HISTORY for
586: Recinfo.request_id,
587: Recinfo.program_application_id,
588: Recinfo.program_id,
589: Recinfo.program_date,
590: fnd_global.user_id,
591: fnd_global.login_id);
592:
593: -- dbms_output.put_line ('l_progress!! -' || l_progress );
594:
587: Recinfo.program_application_id,
588: Recinfo.program_id,
589: Recinfo.program_date,
590: fnd_global.user_id,
591: fnd_global.login_id);
592:
593: -- dbms_output.put_line ('l_progress!! -' || l_progress );
594:
595: END IF;
611: Bug 14580064 : Replaced p_responder_id by p_original_recipient_id for the case when recepient and responder are different.
612: */
613: UPDATE PO_ACTION_HISTORY
614: SET last_update_date = sysdate,
615: last_updated_by = fnd_global.user_id, --x_user_id,
616: last_update_login = fnd_global.login_id, --x_login_id,
617: action_date = sysdate,
618: action_code = p_action_code, --x_action_code,
619: note = l_note, --x_note,
612: */
613: UPDATE PO_ACTION_HISTORY
614: SET last_update_date = sysdate,
615: last_updated_by = fnd_global.user_id, --x_user_id,
616: last_update_login = fnd_global.login_id, --x_login_id,
617: action_date = sysdate,
618: action_code = p_action_code, --x_action_code,
619: note = l_note, --x_note,
620: offline_code = NULL
642: Recinfo.request_id,
643: Recinfo.program_application_id,
644: Recinfo.program_id,
645: Recinfo.program_date,
646: fnd_global.user_id,
647: fnd_global.login_id);
648: END IF;
649: END IF;
650:
643: Recinfo.program_application_id,
644: Recinfo.program_id,
645: Recinfo.program_date,
646: fnd_global.user_id,
647: fnd_global.login_id);
648: END IF;
649: END IF;
650:
651: l_progress := '080';