eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_TRANS_TYPE_API dependencies on AME_UTIL

Line 40: where name = ame_util.headerItemClassName

36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id
39: from ame_item_classes
40: where name = ame_util.headerItemClassName
41: and sysdate between start_date and
42: nvl(end_date - (1/86400), sysdate);
43: type attribTypeList is table of ame_attributes.attribute_type%type
44: index by binary_integer;

Line 55: l_attributeIds ame_util.idList;

51: l_start_date date;
52: l_end_date date;
53: l_start_date_child date;
54: l_end_date_child date;
55: l_attributeIds ame_util.idList;
56: l_attributeTypes attribTypeList;
57: l_queryString varchar2(5);
58: --
59: begin

Line 117: ,p_item_class_par_mode => ame_util.serialItems

113: ame_item_class_api.create_ame_item_class_usage
114: (p_validate => p_validate
115: ,p_item_id_query => 'select :transactionId from dual'
116: ,p_item_class_order_number => 1
117: ,p_item_class_par_mode => ame_util.serialItems
118: ,p_item_class_sublist_mode => ame_util.serialSublists
119: ,p_application_id => l_application_id
120: ,p_item_class_id => l_header_item_class_id
121: ,p_object_version_number => l_ovn_child

Line 118: ,p_item_class_sublist_mode => ame_util.serialSublists

114: (p_validate => p_validate
115: ,p_item_id_query => 'select :transactionId from dual'
116: ,p_item_class_order_number => 1
117: ,p_item_class_par_mode => ame_util.serialItems
118: ,p_item_class_sublist_mode => ame_util.serialSublists
119: ,p_application_id => l_application_id
120: ,p_item_class_id => l_header_item_class_id
121: ,p_object_version_number => l_ovn_child
122: ,p_start_date => l_start_date_child

Line 135: l_queryString := ame_util.booleanAttributeFalse;

131: close getMandatoryAttributesCur;
132: for indx in 1..l_attributeIds.count
133: loop
134: if(LOWER(l_attributeTypes(indx)) = 'boolean') then
135: l_queryString := ame_util.booleanAttributeFalse;
136: else
137: l_queryString := null;
138: end if;
139: ame_attribute_api.create_ame_attribute_usage

Line 143: ,p_is_static => ame_util.booleanTrue

139: ame_attribute_api.create_ame_attribute_usage
140: (p_validate => p_validate
141: ,p_attribute_id => l_attributeIds(indx)
142: ,p_application_id => l_application_id
143: ,p_is_static => ame_util.booleanTrue
144: ,p_query_string => l_queryString
145: ,p_object_version_number => l_ovn_child
146: ,p_start_date => l_start_date_child
147: ,p_end_date => l_end_date_child

Line 374: and nvl(end_date - ame_util.oneSecond, sysdate)) or

370: object_version_number
371: from ame_rule_usages
372: where item_id = p_application_id
373: and ((sysdate between start_date
374: and nvl(end_date - ame_util.oneSecond, sysdate)) or
375: (sysdate < start_date and
376: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
377: cursor getAttributeUsageCur is
378: select atu.attribute_id,

Line 376: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

372: where item_id = p_application_id
373: and ((sysdate between start_date
374: and nvl(end_date - ame_util.oneSecond, sysdate)) or
375: (sysdate < start_date and
376: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
377: cursor getAttributeUsageCur is
378: select atu.attribute_id,
379: atu.object_version_number
380: from ame_attribute_usages atu

Line 385: nvl(atu.end_date - ame_util.oneSecond, sysdate)

381: ,ame_attributes att
382: where application_id = p_application_id
383: and att.attribute_id = atu.attribute_id
384: and sysdate between atu.start_date and
385: nvl(atu.end_date - ame_util.oneSecond, sysdate)
386: and sysdate between att.start_date and
387: nvl(att.end_date - ame_util.oneSecond, sysdate);
388: cursor getItemClassUsageCur is
389: select item_class_id,

Line 387: nvl(att.end_date - ame_util.oneSecond, sysdate);

383: and att.attribute_id = atu.attribute_id
384: and sysdate between atu.start_date and
385: nvl(atu.end_date - ame_util.oneSecond, sysdate)
386: and sysdate between att.start_date and
387: nvl(att.end_date - ame_util.oneSecond, sysdate);
388: cursor getItemClassUsageCur is
389: select item_class_id,
390: object_version_number
391: from ame_item_class_usages

Line 394: nvl(end_date - ame_util.oneSecond, sysdate);

390: object_version_number
391: from ame_item_class_usages
392: where application_id = p_application_id
393: and sysdate between start_date and
394: nvl(end_date - ame_util.oneSecond, sysdate);
395: cursor getApprovalGroupConfigCur is
396: select approval_group_id,
397: object_version_number
398: from ame_approval_group_config

Line 401: nvl(end_date - ame_util.oneSecond, sysdate);

397: object_version_number
398: from ame_approval_group_config
399: where application_id = p_application_id
400: and sysdate between start_date and
401: nvl(end_date - ame_util.oneSecond, sysdate);
402: cursor getActionTypesConfigCur is
403: select action_type_id,
404: object_version_number
405: from ame_action_type_config

Line 408: nvl(end_date - ame_util.oneSecond, sysdate);

404: object_version_number
405: from ame_action_type_config
406: where application_id = p_application_id
407: and sysdate between start_date and
408: nvl(end_date - ame_util.oneSecond, sysdate);
409: cursor getConfigVarsCur is
410: select variable_name,
411: object_version_number
412: from ame_config_vars

Line 415: nvl(end_date - ame_util.oneSecond, sysdate);

411: object_version_number
412: from ame_config_vars
413: where application_id = p_application_id
414: and sysdate between start_date and
415: nvl(end_date - ame_util.oneSecond, sysdate);
416: type varsList is table of ame_config_vars.variable_name%type
417: index by binary_integer;
418: l_proc varchar2(72) := g_package||'delete_ame_transaction_type';
419: l_object_version_number number;

Line 424: l_ruleIds ame_util.idList;

420: l_start_date date;
421: l_end_date date;
422: l_start_date_child date;
423: l_end_date_child date;
424: l_ruleIds ame_util.idList;
425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;

Line 425: l_ruleStartDates ame_util.dateList;

421: l_end_date date;
422: l_start_date_child date;
423: l_end_date_child date;
424: l_ruleIds ame_util.idList;
425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;

Line 426: l_ruleEndDates ame_util.dateList;

422: l_start_date_child date;
423: l_end_date_child date;
424: l_ruleIds ame_util.idList;
425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;

Line 427: l_attributeIds ame_util.idList;

423: l_end_date_child date;
424: l_ruleIds ame_util.idList;
425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;
431: l_configVarsList varsList;

Line 428: l_itemClassIds ame_util.idList;

424: l_ruleIds ame_util.idList;
425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;
431: l_configVarsList varsList;
432: l_objectVersionNumbers ame_util.idList;

Line 429: l_approvalGroupIds ame_util.idList;

425: l_ruleStartDates ame_util.dateList;
426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;
431: l_configVarsList varsList;
432: l_objectVersionNumbers ame_util.idList;
433: --

Line 430: l_actionTypeIds ame_util.idList;

426: l_ruleEndDates ame_util.dateList;
427: l_attributeIds ame_util.idList;
428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;
431: l_configVarsList varsList;
432: l_objectVersionNumbers ame_util.idList;
433: --
434: begin

Line 432: l_objectVersionNumbers ame_util.idList;

428: l_itemClassIds ame_util.idList;
429: l_approvalGroupIds ame_util.idList;
430: l_actionTypeIds ame_util.idList;
431: l_configVarsList varsList;
432: l_objectVersionNumbers ame_util.idList;
433: --
434: begin
435: hr_utility.set_location('Entering:'|| l_proc, 10);
436: --