APPS.PA_PROJECT_WF dependencies on PA_OBJ_STATUS_CHANGES_S

Line 551: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

547: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
548: itemkey => itemkey,
549: aname => 'NOTE' );
550:
551: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
552: FROM dual;
553:
554: OPEN cur_get_system_status(l_success_status_code);
555: FETCH cur_get_system_status INTO l_new_sys_status;

Line 693: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

689: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'PROJECT_STATUS_CODE' );
692:
693: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
694: FROM dual;
695:
696: OPEN cur_get_system_status(l_failure_status_code);
697: FETCH cur_get_system_status INTO l_new_sys_status;