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 847: if(AME_SEED_UTILITY.IS_SEED_USER(X_CURRENT_OWNER) = false and

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

Line 854: X_CURRENT_OWNER := AME_SEED_UTILITY.USER_ID_OF_SEED_USER;

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

Line 872: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

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

Line 876: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

872: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
873: X_CURRENT_OVN + 1);
874: else
875: if DO_UPDATE_INSERT
876: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
877: X_CURRENT_OWNER,
878: X_LAST_UPDATE_DATE,
879: X_CURRENT_LAST_UPDATE_DATE) then
880: UPDATE_ROW (