62: , p_start_date
63: , p_start_date_old
64: , p_end_date
65: , p_end_date_old
66: , fnd_global.user_id
67: , SYSDATE
68: , NULL
69: , SYSDATE
70: , fnd_global.user_id
66: , fnd_global.user_id
67: , SYSDATE
68: , NULL
69: , SYSDATE
70: , fnd_global.user_id
71: , SYSDATE
72: , fnd_global.login_id
73: , fnd_global.user_id
74: , p_org_id
68: , NULL
69: , SYSDATE
70: , fnd_global.user_id
71: , SYSDATE
72: , fnd_global.login_id
73: , fnd_global.user_id
74: , p_org_id
75: )
76: RETURNING event_log_id INTO x_event_log_id;
69: , SYSDATE
70: , fnd_global.user_id
71: , SYSDATE
72: , fnd_global.login_id
73: , fnd_global.user_id
74: , p_org_id
75: )
76: RETURNING event_log_id INTO x_event_log_id;
77: EXCEPTION
376: , SYSDATE
377: , 'INCOMPLETE'
378: , DECODE(p_revert_to_state, 'COL', 4, 'CLS', 6, 'ROLL', 8, 'POP', 10, 'CALC', 12)
379: , SYSDATE
380: , fnd_global.user_id
381: , SYSDATE
382: , fnd_global.login_id
383: , fnd_global.user_id
384: , p_org_id
378: , DECODE(p_revert_to_state, 'COL', 4, 'CLS', 6, 'ROLL', 8, 'POP', 10, 'CALC', 12)
379: , SYSDATE
380: , fnd_global.user_id
381: , SYSDATE
382: , fnd_global.login_id
383: , fnd_global.user_id
384: , p_org_id
385: );
386: END IF;
379: , SYSDATE
380: , fnd_global.user_id
381: , SYSDATE
382: , fnd_global.login_id
383: , fnd_global.user_id
384: , p_org_id
385: );
386: END IF;
387:
987: , SYSDATE
988: , 'INCOMPLETE'
989: , DECODE(p_revert_to_state, 'COL', 4, 'CLS', 6, 'ROLL', 8, 'POP', 10, 'CALC', 12)
990: , SYSDATE
991: , fnd_global.user_id
992: , SYSDATE
993: , fnd_global.login_id
994: , fnd_global.user_id
995: , p_org_id
989: , DECODE(p_revert_to_state, 'COL', 4, 'CLS', 6, 'ROLL', 8, 'POP', 10, 'CALC', 12)
990: , SYSDATE
991: , fnd_global.user_id
992: , SYSDATE
993: , fnd_global.login_id
994: , fnd_global.user_id
995: , p_org_id
996: );
997:
990: , SYSDATE
991: , fnd_global.user_id
992: , SYSDATE
993: , fnd_global.login_id
994: , fnd_global.user_id
995: , p_org_id
996: );
997:
998: x_action_link_id := l_notify_log_id;