APPS.PA_STATUS_LIST_ITEMS_PKG dependencies on PA_STATUS_LIST_ITEMS_S

Line 22: SELECT pa_status_list_items_s.nextval into l_status_list_item_id FROM dual;

18: l_status_list_item_id NUMBER;
19: begin
20: l_status_list_item_id := x_status_list_item_id; --Added for bug 4565156
21: IF (X_STATUS_LIST_ITEM_ID = -99) THEN
22: SELECT pa_status_list_items_s.nextval into l_status_list_item_id FROM dual;
23: X_STATUS_LIST_ITEM_ID := l_status_list_item_id;
24: END IF;
25:
26: insert into PA_STATUS_LIST_ITEMS (

Line 104: update PA_STATUS_LIST_ITEMS set

100: X_CREATION_DATE IN DATE ,
101: X_CREATED_BY IN NUMBER
102: ) is
103: begin
104: update PA_STATUS_LIST_ITEMS set
105: STATUS_LIST_ID = X_STATUS_LIST_ID,
106: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER,
107: PROJECT_STATUS_CODE = X_PROJECT_STATUS_CODE,
108: STATUS_LIST_ITEM_ID = X_STATUS_LIST_ITEM_ID,