DBA Data[Home] [Help]

APPS.PER_PEOPLE_INFO_TYPES_SEC_PKG dependencies on PER_INFO_TYPE_SECURITY_S

Line 78: select per_info_type_security_s.nextval

74: select responsibility_id
75: from fnd_responsibility_vl
76: where responsibility_key = X_RESPONSIBILITY_KEY;
77: cursor C_SEC_ID is
78: select per_info_type_security_s.nextval
79: from sys.dual;
80: cursor C is select ROWID from PER_INFO_TYPE_SECURITY
81: where application_id = l_appl_id
82: and responsibility_id = l_resp_id

Line 216: update PER_INFO_TYPE_SECURITY set

212: close C_APPL;
213: open C_RESP;
214: fetch C_RESP into l_resp_id;
215: close C_RESP;
216: update PER_INFO_TYPE_SECURITY set
217: INFORMATION_TYPE = X_INFORMATION_TYPE_NEW,
218: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
219: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
220: LAST_UPDATED_BY = X_LAST_UPDATED_BY,