7: X_LAST_UPDATED_BY out nocopy NUMBER,
8: X_LAST_UPDATE_LOGIN out nocopy NUMBER
9: ) is
10: begin
11: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
13: X_LAST_UPDATE_LOGIN := 0;
14: end OWNER_TO_WHO;
15:
8: X_LAST_UPDATE_LOGIN out nocopy NUMBER
9: ) is
10: begin
11: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
13: X_LAST_UPDATE_LOGIN := 0;
14: end OWNER_TO_WHO;
15:
16: procedure KEY_TO_IDS (
100: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
101: X_CUSTOM_MODE in varchar2 default null)
102: return boolean as
103: begin
104: return AME_SEED_UTILITY.MERGE_ROW_TEST
105: (X_OWNER => X_OWNER
106: ,X_CURRENT_OWNER => X_CURRENT_OWNER
107: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
108: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
174: X_LAST_UPDATED_BY,
175: X_LAST_UPDATE_DATE,
176: X_LAST_UPDATE_LOGIN,
177: X_START_DATE,
178: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
179: X_OBJECT_VERSION_NUMBER);
180: end if;
181: end INSERT_ROW;
182:
325: X_LAST_UPDATED_BY,
326: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
327: X_LAST_UPDATE_LOGIN,
328: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
329: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
330: X_CURRENT_OVN + 1);
331: else
332: if DO_UPDATE_INSERT
333: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
329: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
330: X_CURRENT_OVN + 1);
331: else
332: if DO_UPDATE_INSERT
333: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
334: X_CURRENT_OWNER,
335: X_LAST_UPDATE_DATE,
336: X_CURRENT_LAST_UPDATE_DATE) then
337: UPDATE_ROW (