DBA Data[Home] [Help]

APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_SEED_UTILITY

Line 301: if rec.end_date is null or rec.end_date = AME_SEED_UTILITY.END_OF_TIME then

297: loop
298: creationDate := minStartDate + (recCounter*oneSecond);
299: startDate := creationDate;
300: lastUpdateDate := minStartDate + ((recCounter+1)*oneSecond);
301: if rec.end_date is null or rec.end_date = AME_SEED_UTILITY.END_OF_TIME then
302: endDate := AME_SEED_UTILITY.END_OF_TIME;
303: X_CURRENT_LAST_UPDATE_DATE := lastUpdateDate;
304: else
305: endDate := lastUpdateDate;

Line 302: endDate := AME_SEED_UTILITY.END_OF_TIME;

298: creationDate := minStartDate + (recCounter*oneSecond);
299: startDate := creationDate;
300: lastUpdateDate := minStartDate + ((recCounter+1)*oneSecond);
301: if rec.end_date is null or rec.end_date = AME_SEED_UTILITY.END_OF_TIME then
302: endDate := AME_SEED_UTILITY.END_OF_TIME;
303: X_CURRENT_LAST_UPDATE_DATE := lastUpdateDate;
304: else
305: endDate := lastUpdateDate;
306: end if;

Line 335: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

331: X_LAST_UPDATED_BY out nocopy NUMBER,
332: X_LAST_UPDATE_LOGIN out nocopy NUMBER
333: ) is
334: begin
335: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
336: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
337: X_LAST_UPDATE_LOGIN := 0;
338: end OWNER_TO_WHO;
339: procedure VALIDATE_IS_STATIC (

Line 336: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

332: X_LAST_UPDATE_LOGIN out nocopy NUMBER
333: ) is
334: begin
335: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
336: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
337: X_LAST_UPDATE_LOGIN := 0;
338: end OWNER_TO_WHO;
339: procedure VALIDATE_IS_STATIC (
340: X_IS_STATIC in VARCHAR2

Line 516: return AME_SEED_UTILITY.MERGE_ROW_TEST

512: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
513: X_CUSTOM_MODE in VARCHAR2 default null)
514: return boolean as
515: begin
516: return AME_SEED_UTILITY.MERGE_ROW_TEST
517: (X_OWNER => X_OWNER
518: ,X_CURRENT_OWNER => X_CURRENT_OWNER
519: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
520: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 629: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

625: X_LAST_UPDATED_BY,
626: X_LAST_UPDATE_DATE,
627: X_LAST_UPDATE_LOGIN,
628: X_START_DATE,
629: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
630: X_USER_EDITABLE,
631: X_VALUE_SET_ID,
632: X_OBJECT_VERSION_NUMBER
633: );

Line 850: if(AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_OWNER) = false and

846: 1);
847: -- the current row was found end date the current row
848: -- insert a row with the same attribute id
849: else
850: if(AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_OWNER) = false and
851: IS_SEED_USG_RULE_MODIFIED(X_ATTRIBUTE_ID => X_ATTRIBUTE_ID,
852: X_APPLICATION_ID => X_APPLICATION_ID)) then
853: RECTIFY_RULE_MOD_SEED_USAGE(X_ATTRIBUTE_ID => X_ATTRIBUTE_ID,
854: X_APPLICATION_ID => X_APPLICATION_ID,

Line 857: X_CURRENT_OWNER := AME_SEED_UTILITY.USER_ID_OF_SEED_USER;

853: RECTIFY_RULE_MOD_SEED_USAGE(X_ATTRIBUTE_ID => X_ATTRIBUTE_ID,
854: X_APPLICATION_ID => X_APPLICATION_ID,
855: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
856: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE);
857: X_CURRENT_OWNER := AME_SEED_UTILITY.USER_ID_OF_SEED_USER;
858: end if;
859: if X_CUSTOM_MODE = 'FORCE' then
860: X_CALCULATED_USE_COUNT := CALCULATE_USE_COUNT(X_ATTRIBUTE_ID => X_ATTRIBUTE_ID,
861: X_APPLICATION_ID => X_APPLICATION_ID);

Line 875: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

871: X_LAST_UPDATED_BY,
872: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
873: X_LAST_UPDATE_LOGIN,
874: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
875: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
876: X_CURRENT_OVN + 1);
877: else
878: if DO_UPDATE_INSERT
879: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

Line 879: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

875: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
876: X_CURRENT_OVN + 1);
877: else
878: if DO_UPDATE_INSERT
879: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
880: X_CURRENT_OWNER,
881: X_LAST_UPDATE_DATE,
882: X_CURRENT_LAST_UPDATE_DATE) then
883: