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:
386: Recinfo.request_id,
387: Recinfo.program_application_id,
388: Recinfo.program_id,
389: Recinfo.program_date,
390: fnd_global.user_id,
391: fnd_global.login_id);
392:
393: l_progress := '040';
394:
387: Recinfo.program_application_id,
388: Recinfo.program_id,
389: Recinfo.program_date,
390: fnd_global.user_id,
391: fnd_global.login_id);
392:
393: l_progress := '040';
394:
395: commit;
490: Recinfo.request_id,
491: Recinfo.program_application_id,
492: Recinfo.program_id,
493: Recinfo.program_date,
494: fnd_global.user_id,
495: fnd_global.login_id);
496:
497: end if;
498:
491: Recinfo.program_application_id,
492: Recinfo.program_id,
493: Recinfo.program_date,
494: fnd_global.user_id,
495: fnd_global.login_id);
496:
497: end if;
498:
499: /*
534: Recinfo.object_type_code,
535: p_more_info_id,
536: 'NO ACTION',
537: NULL,
538: fnd_global.user_id,
539: fnd_global.login_id
540: );
541:
542: /*
535: p_more_info_id,
536: 'NO ACTION',
537: NULL,
538: fnd_global.user_id,
539: fnd_global.login_id
540: );
541:
542: /*
543: ** insert a new NULL row into PO_ACTION_HISTORY for
561: Recinfo.request_id,
562: Recinfo.program_application_id,
563: Recinfo.program_id,
564: Recinfo.program_date,
565: fnd_global.user_id,
566: fnd_global.login_id);
567:
568: -- dbms_output.put_line ('l_progress!! -' || l_progress );
569:
562: Recinfo.program_application_id,
563: Recinfo.program_id,
564: Recinfo.program_date,
565: fnd_global.user_id,
566: fnd_global.login_id);
567:
568: -- dbms_output.put_line ('l_progress!! -' || l_progress );
569:
570: END IF;
583: ** update pending row of action history with approval action
584: */
585: UPDATE PO_ACTION_HISTORY
586: SET last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id, --x_user_id,
588: last_update_login = fnd_global.login_id, --x_login_id,
589: action_date = sysdate,
590: action_code = p_action_code, --x_action_code,
591: note = l_note, --x_note,
584: */
585: UPDATE PO_ACTION_HISTORY
586: SET last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id, --x_user_id,
588: last_update_login = fnd_global.login_id, --x_login_id,
589: action_date = sysdate,
590: action_code = p_action_code, --x_action_code,
591: note = l_note, --x_note,
592: offline_code = NULL
611: Recinfo.request_id,
612: Recinfo.program_application_id,
613: Recinfo.program_id,
614: Recinfo.program_date,
615: fnd_global.user_id,
616: fnd_global.login_id);
617: END IF;
618: END IF;
619:
612: Recinfo.program_application_id,
613: Recinfo.program_id,
614: Recinfo.program_date,
615: fnd_global.user_id,
616: fnd_global.login_id);
617: END IF;
618: END IF;
619:
620: l_progress := '080';