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_DYNAMIC_APPROVAL_PKG dependencies on AME_UTIL

Line 43: c_approver_rec2 ame_util.approverRecord2;

39: PRAGMA AUTONOMOUS_TRANSACTION;
40: --local variables
41: l_proc constant varchar2(100) := 'insert_ame_approver';
42:
43: c_approver_rec2 ame_util.approverRecord2;
44: c_insertion_record2 ame_util.insertionRecord2;
45: lv_parameter varchar2(650);
46: BEGIN
47:

Line 44: c_insertion_record2 ame_util.insertionRecord2;

40: --local variables
41: l_proc constant varchar2(100) := 'insert_ame_approver';
42:
43: c_approver_rec2 ame_util.approverRecord2;
44: c_insertion_record2 ame_util.insertionRecord2;
45: lv_parameter varchar2(650);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);

Line 80: lv_parameter := replace(lv_parameter,'^',ame_util.fieldDelimiter);

76: -- to take care of '\v' special character not passivated,
77: -- so replacing with another special charater which will be
78: -- passivated.
79: lv_parameter := p_insertionIn(1).parameter;
80: lv_parameter := replace(lv_parameter,'^',ame_util.fieldDelimiter);
81: c_insertion_record2.parameter := lv_parameter;
82:
83: c_insertion_record2.description := p_insertionIn(1).description;
84:

Line 85: if (ame_util.firstAuthority = c_insertion_record2.order_type) then

81: c_insertion_record2.parameter := lv_parameter;
82:
83: c_insertion_record2.description := p_insertionIn(1).description;
84:
85: if (ame_util.firstAuthority = c_insertion_record2.order_type) then
86: begin
87: -- for now, we are not inserting COA first Authoriry approvers
88: -- setFirstAuthority is accepting only Authority Insertion, but
89: -- getAvailableOption returning 'Y'

Line 100: c_insertion_record2.action_type_id := ame_util.nullInsertionActionTypeId;

96: end;
97: else
98: begin
99: -- These parameters need to be null for adhoc approvers
100: c_insertion_record2.action_type_id := ame_util.nullInsertionActionTypeId;
101: c_insertion_record2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
102:
103: c_approver_rec2.action_type_id := ame_util.nullInsertionActionTypeId;
104: c_approver_rec2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;

Line 101: c_insertion_record2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;

97: else
98: begin
99: -- These parameters need to be null for adhoc approvers
100: c_insertion_record2.action_type_id := ame_util.nullInsertionActionTypeId;
101: c_insertion_record2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
102:
103: c_approver_rec2.action_type_id := ame_util.nullInsertionActionTypeId;
104: c_approver_rec2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
105:

Line 103: c_approver_rec2.action_type_id := ame_util.nullInsertionActionTypeId;

99: -- These parameters need to be null for adhoc approvers
100: c_insertion_record2.action_type_id := ame_util.nullInsertionActionTypeId;
101: c_insertion_record2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
102:
103: c_approver_rec2.action_type_id := ame_util.nullInsertionActionTypeId;
104: c_approver_rec2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
105:
106: ame_api3.insertApprover(applicationIdIn =>p_application_id,
107: transactionIdIn =>p_transaction_id,

Line 104: c_approver_rec2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;

100: c_insertion_record2.action_type_id := ame_util.nullInsertionActionTypeId;
101: c_insertion_record2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
102:
103: c_approver_rec2.action_type_id := ame_util.nullInsertionActionTypeId;
104: c_approver_rec2.group_or_chain_id := ame_util.nullInsertionGroupOrChainId;
105:
106: ame_api3.insertApprover(applicationIdIn =>p_application_id,
107: transactionIdIn =>p_transaction_id,
108: approverIn =>c_approver_rec2,

Line 139: c_approver_rec2 ame_util.approverRecord2;

135: as
136: PRAGMA AUTONOMOUS_TRANSACTION;
137: --local variables
138: l_proc constant varchar2(100) := 'delete_ame_approver';
139: c_approver_rec2 ame_util.approverRecord2;
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);

Line 158: if(p_approverIn(1).api_Insertion = ame_util.apiInsertion) then

154: c_approver_rec2.api_insertion := p_approverIn(1).api_insertion;
155: c_approver_rec2.occurrence := p_approverIn(1).occurrence;
156:
157:
158: if(p_approverIn(1).api_Insertion = ame_util.apiInsertion) then
159: begin
160: -- API Inserrted Adhoc approver, so call clearInsertion
161: ame_api3.clearInsertion(applicationIdIn =>p_application_id,
162: transactionTypeIn => p_transaction_type,

Line 209: errString ame_util.longestStringType;

205: --local variables
206:
207: l_proc constant varchar2(100) := 'get_ame_apprs_and_ins_list';
208: lv_parameter varchar2(650);
209: errString ame_util.longestStringType;
210: CURSOR c_active_order_type_name (
211: p_order_type IN varchar2
212: )
213: IS

Line 249: c_all_approvers ame_util.approversTable2;

245: l_default_approver ame_approver_record2_ss;
246: l_default_insertions_list ame_insertion_record2_table_ss := ame_insertion_record2_table_ss();
247: l_default_insertion ame_insertion_record2_ss;
248: ln_approver_index NUMBER;
249: c_all_approvers ame_util.approversTable2;
250: c_all_insertions ame_util2.insertionsTable3;
251: ln_approver_list_cnt NUMBER ;
252: ln_insertions_index NUMBER;
253: ln_insertion_record2_num number;

Line 250: c_all_insertions ame_util2.insertionsTable3;

246: l_default_insertions_list ame_insertion_record2_table_ss := ame_insertion_record2_table_ss();
247: l_default_insertion ame_insertion_record2_ss;
248: ln_approver_index NUMBER;
249: c_all_approvers ame_util.approversTable2;
250: c_all_insertions ame_util2.insertionsTable3;
251: ln_approver_list_cnt NUMBER ;
252: ln_insertions_index NUMBER;
253: ln_insertion_record2_num number;
254: lv_approval_status varchar2(10);

Line 257: allowDeletingOamApprovers ame_util.attributeValueType;

253: ln_insertion_record2_num number;
254: lv_approval_status varchar2(10);
255: ln_approver_group_name varchar2(240);
256: bactiveApproversYNIn varchar2(1);
257: allowDeletingOamApprovers ame_util.attributeValueType;
258: ruleIdList ame_util.idList;
259: sourceDescription ame_util.stringType;
260: allow_delete varchar2(30);
261: ln_order_type_name varchar2(100);

Line 258: ruleIdList ame_util.idList;

254: lv_approval_status varchar2(10);
255: ln_approver_group_name varchar2(240);
256: bactiveApproversYNIn varchar2(1);
257: allowDeletingOamApprovers ame_util.attributeValueType;
258: ruleIdList ame_util.idList;
259: sourceDescription ame_util.stringType;
260: allow_delete varchar2(30);
261: ln_order_type_name varchar2(100);
262: active_apr_index number;

Line 259: sourceDescription ame_util.stringType;

255: ln_approver_group_name varchar2(240);
256: bactiveApproversYNIn varchar2(1);
257: allowDeletingOamApprovers ame_util.attributeValueType;
258: ruleIdList ame_util.idList;
259: sourceDescription ame_util.stringType;
260: allow_delete varchar2(30);
261: ln_order_type_name varchar2(100);
262: active_apr_index number;
263: last_active_apr_name varchar2(100);

Line 279: bactiveApproversYNIn := ame_util.booleanTrue;

275:
276: -- set flag based on user selection for Active or All Approvers
277: -- zero means active approver
278: if(p_apprs_view_type = '0' or p_apprs_view_type is null) then
279: bactiveApproversYNIn := ame_util.booleanTrue;
280: else
281: bactiveApproversYNIn := ame_util.booleanFalse;
282: end if;
283:

Line 281: bactiveApproversYNIn := ame_util.booleanFalse;

277: -- zero means active approver
278: if(p_apprs_view_type = '0' or p_apprs_view_type is null) then
279: bactiveApproversYNIn := ame_util.booleanTrue;
280: else
281: bactiveApproversYNIn := ame_util.booleanFalse;
282: end if;
283:
284: -- get Active/All AME Approvers
285: ame_api5.getAllApproversAndInsertions(applicationIdIn =>p_application_id,

Line 290: coaInsertionsYNIN => ame_util.booleanFalse,

286: transactionIdIn=>p_transaction_id,
287: transactionTypeIn =>p_transaction_type,
288: activeApproversYNIn => bactiveApproversYNIn,
289: -- currently not getting COA approvers
290: coaInsertionsYNIN => ame_util.booleanFalse,
291: approvalProcessCompleteYNOut =>lv_approval_status,
292: approversOut=>c_all_approvers,
293: availableInsertionsOut => c_all_insertions);
294:

Line 307: ame_util.parseSourceValue(sourceValueIn => c_all_approvers(tempIndex).source,

303: begin
304: -- count for approvers
305: ln_approver_list_cnt:= ln_approver_list_cnt + 1;
306: -- parse the source to see if the approver was inserted.
307: ame_util.parseSourceValue(sourceValueIn => c_all_approvers(tempIndex).source,
308: sourceDescriptionOut => sourceDescription,
309: ruleIdListOut => ruleIdList);
310:
311: -- If the approver was OAM generated, check whether deleting OAM-generated approvers

Line 314: if(c_all_approvers(tempIndex).api_insertion = ame_util.oamGenerated or

310:
311: -- If the approver was OAM generated, check whether deleting OAM-generated approvers
312: -- is allowed or not. If so, record the deletion.
313: allow_delete := 'AMEDeleteEnabled';
314: if(c_all_approvers(tempIndex).api_insertion = ame_util.oamGenerated or
315: sourceDescription = ame_util.ruleGeneratedSource ) then
316: begin
317: allowDeletingOamApprovers :=
318: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);

Line 315: sourceDescription = ame_util.ruleGeneratedSource ) then

311: -- If the approver was OAM generated, check whether deleting OAM-generated approvers
312: -- is allowed or not. If so, record the deletion.
313: allow_delete := 'AMEDeleteEnabled';
314: if(c_all_approvers(tempIndex).api_insertion = ame_util.oamGenerated or
315: sourceDescription = ame_util.ruleGeneratedSource ) then
316: begin
317: allowDeletingOamApprovers :=
318: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
319: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then

Line 318: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);

314: if(c_all_approvers(tempIndex).api_insertion = ame_util.oamGenerated or
315: sourceDescription = ame_util.ruleGeneratedSource ) then
316: begin
317: allowDeletingOamApprovers :=
318: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
319: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
320: begin
321: allow_delete := 'AMEDeleteDisabled';
322: end;

Line 319: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then

315: sourceDescription = ame_util.ruleGeneratedSource ) then
316: begin
317: allowDeletingOamApprovers :=
318: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
319: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
320: begin
321: allow_delete := 'AMEDeleteDisabled';
322: end;
323: end if;

Line 330: (ame_util.approveAndForwardStatus

326:
327: -- if approver already responded then disable delete button
328: if (c_all_approvers(tempIndex).approval_status is not null and
329: c_all_approvers(tempIndex).approval_status in
330: (ame_util.approveAndForwardStatus
331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus

Line 331: ,ame_util.approvedStatus

327: -- if approver already responded then disable delete button
328: if (c_all_approvers(tempIndex).approval_status is not null and
329: c_all_approvers(tempIndex).approval_status in
330: (ame_util.approveAndForwardStatus
331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus

Line 332: ,ame_util.notifiedStatus

328: if (c_all_approvers(tempIndex).approval_status is not null and
329: c_all_approvers(tempIndex).approval_status in
330: (ame_util.approveAndForwardStatus
331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus
336: ,ame_util.suppressedStatus)) then

Line 333: ,ame_util.notifiedByRepeatedStatus

329: c_all_approvers(tempIndex).approval_status in
330: (ame_util.approveAndForwardStatus
331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus
336: ,ame_util.suppressedStatus)) then
337: begin

Line 334: ,ame_util.approvedByRepeatedStatus

330: (ame_util.approveAndForwardStatus
331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus
336: ,ame_util.suppressedStatus)) then
337: begin
338: allow_delete := 'AMEDeleteDisabled';

Line 335: ,ame_util.rejectedByRepeatedStatus

331: ,ame_util.approvedStatus
332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus
336: ,ame_util.suppressedStatus)) then
337: begin
338: allow_delete := 'AMEDeleteDisabled';
339: end;

Line 336: ,ame_util.suppressedStatus)) then

332: ,ame_util.notifiedStatus
333: ,ame_util.notifiedByRepeatedStatus
334: ,ame_util.approvedByRepeatedStatus
335: ,ame_util.rejectedByRepeatedStatus
336: ,ame_util.suppressedStatus)) then
337: begin
338: allow_delete := 'AMEDeleteDisabled';
339: end;
340: end if;

Line 473: lv_parameter := replace(lv_parameter,ame_util.fieldDelimiter,'^');

469: -- to take care of '\v' special character not passivated,
470: -- so replacing with another special charater which will be
471: -- passivated.
472: lv_parameter := c_all_insertions(j).parameter;
473: lv_parameter := replace(lv_parameter,ame_util.fieldDelimiter,'^');
474:
475: l_default_insertion := ame_insertion_record2_ss(
476: c_all_insertions(j).position, -- position index
477: c_all_insertions(j).item_class, -- item_class

Line 509: ame_util.runtimeException(packageNameIn => 'ame_dynamic_approval_pkg',

505: hr_utility.set_location('Leaving: get_ame_apprs_and_ins_list', 2);
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: ame_util.runtimeException(packageNameIn => 'ame_dynamic_approval_pkg',
510: routineNameIn => 'get_ame_apprs_and_ins_list',
511: exceptionNumberIn => sqlcode,
512: exceptionStringIn => sqlerrm);
513: if sqlcode = -20001 then