DBA Data[Home] [Help]

APPS.PA_PROJECT_WF dependencies on PA_OBJ_STATUS_CHANGES_S

Line 573: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

569: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'NOTE' );
572:
573: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
574: FROM dual;
575:
576: OPEN cur_get_system_status(l_success_status_code);
577: FETCH cur_get_system_status INTO l_new_sys_status;

Line 715: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

711: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,
712: itemkey => itemkey,
713: aname => 'PROJECT_STATUS_CODE' );
714:
715: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
716: FROM dual;
717:
718: OPEN cur_get_system_status(l_failure_status_code);
719: FETCH cur_get_system_status INTO l_new_sys_status;