DBA Data[Home] [Help]

APPS.EAM_POPULATE_STATUSES_PKG dependencies on EAM_WO_STATUSES_B_S

Line 22: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;

18:
19: cursor C is select ROWID from EAM_WO_STATUSES_B
20: where STATUS_ID = X_STATUS_ID ;
21:
22: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;
23:
24: begin
25: if (X_Status_Id is NULL) then
26: OPEN C2;

Line 115: update EAM_WO_STATUSES_B set

111: l_resp_id NUMBER;
112: l_request_id NUMBER;
113: begin
114:
115: update EAM_WO_STATUSES_B set
116: SEEDED_FLAG = P_SEEDED_FLAG,
117: SYSTEM_STATUS = P_SYSTEM_STATUS,
118: ENABLED_FLAG = P_ENABLED_FLAG,
119: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,