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.AMV_WFAPPROVAL_PVT dependencies on AMV_UTILITY_PVT

Line 71: IF WorkflowProcess = AMV_UTILITY_PVT.G_PUB_APPROVAL THEN

67: OPEN ItemKey_csr;
68: FETCH ItemKey_csr INTO l_item_key;
69: CLOSE ItemKey_csr;
70:
71: IF WorkflowProcess = AMV_UTILITY_PVT.G_PUB_APPROVAL THEN
72: --
73: OPEN Item_Name;
74: FETCH Item_Name INTO l_item_name;
75: CLOSE Item_Name;

Line 197: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

193:
194: CURSOR Sec_Approvers IS
195: select chl_approver_flag
196: from amv_u_access
197: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
198: and access_to_table_record_id = channel_id
199: and user_or_group_type = AMV_UTILITY_PVT.G_USER
200: and user_or_group_id = user_id;
201:

Line 199: and user_or_group_type = AMV_UTILITY_PVT.G_USER

195: select chl_approver_flag
196: from amv_u_access
197: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
198: and access_to_table_record_id = channel_id
199: and user_or_group_type = AMV_UTILITY_PVT.G_USER
200: and user_or_group_id = user_id;
201:
202: BEGIN
203: --

Line 287: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

283: --
284: CURSOR Chn_Access IS
285: select can_create_flag
286: from amv_u_access
287: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
288: and access_to_table_record_id = l_channel_id
289: and user_or_group_type = AMV_UTILITY_PVT.G_USER
290: and user_or_group_id = l_requestor_id;
291:

Line 289: and user_or_group_type = AMV_UTILITY_PVT.G_USER

285: select can_create_flag
286: from amv_u_access
287: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
288: and access_to_table_record_id = l_channel_id
289: and user_or_group_type = AMV_UTILITY_PVT.G_USER
290: and user_or_group_id = l_requestor_id;
291:
292: CURSOR Chn_Publish IS
293: select pub_need_approval_flag

Line 417: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

413: --
414: CURSOR Chn_Access IS
415: select can_view_flag
416: from amv_u_access
417: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
418: and access_to_table_record_id = l_channel_id
419: and user_or_group_type = AMV_UTILITY_PVT.G_USER
420: and user_or_group_id = l_requestor_id;
421:

Line 419: and user_or_group_type = AMV_UTILITY_PVT.G_USER

415: select can_view_flag
416: from amv_u_access
417: where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
418: and access_to_table_record_id = l_channel_id
419: and user_or_group_type = AMV_UTILITY_PVT.G_USER
420: and user_or_group_id = l_requestor_id;
421:
422: CURSOR Chn_Subscribe IS
423: select sub_need_approval_flag

Line 535: where acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL

531: CURSOR Secn_Approvers IS
532: select fu.user_name
533: from amv_u_access acc
534: , fnd_user fu
535: where acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
536: and acc.access_to_table_record_id = GetApprover.channel_id
537: and acc.user_or_group_type = AMV_UTILITY_PVT.G_USER
538: and acc.user_or_group_id = fu.user_id;
539: --

Line 537: and acc.user_or_group_type = AMV_UTILITY_PVT.G_USER

533: from amv_u_access acc
534: , fnd_user fu
535: where acc.access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
536: and acc.access_to_table_record_id = GetApprover.channel_id
537: and acc.user_or_group_type = AMV_UTILITY_PVT.G_USER
538: and acc.user_or_group_id = fu.user_id;
539: --
540: BEGIN
541: OPEN Chan_Approvers(channel_id);

Line 545: IF approver_in_type = AMV_UTILITY_PVT.G_DEFAULT THEN

541: OPEN Chan_Approvers(channel_id);
542: FETCH Chan_Approvers INTO l_default_approver;
543: CLOSE Chan_Approvers;
544:
545: IF approver_in_type = AMV_UTILITY_PVT.G_DEFAULT THEN
546: approvers := l_default_approver;
547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;
548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN
549: approvers := l_channel_owner;

Line 547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;

543: CLOSE Chan_Approvers;
544:
545: IF approver_in_type = AMV_UTILITY_PVT.G_DEFAULT THEN
546: approvers := l_default_approver;
547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;
548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN
549: approvers := l_channel_owner;
550: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
551: ELSIF approver_in_type = AMV_UTILITY_PVT.G_SECONDARY THEN

Line 548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN

544:
545: IF approver_in_type = AMV_UTILITY_PVT.G_DEFAULT THEN
546: approvers := l_default_approver;
547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;
548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN
549: approvers := l_channel_owner;
550: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
551: ELSIF approver_in_type = AMV_UTILITY_PVT.G_SECONDARY THEN
552: OPEN Secn_Approvers;

Line 550: approver_out_type := AMV_UTILITY_PVT.G_OWNER;

546: approvers := l_default_approver;
547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;
548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN
549: approvers := l_channel_owner;
550: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
551: ELSIF approver_in_type = AMV_UTILITY_PVT.G_SECONDARY THEN
552: OPEN Secn_Approvers;
553: LOOP
554: FETCH Secn_Approvers INTO l_secn_approver;

Line 551: ELSIF approver_in_type = AMV_UTILITY_PVT.G_SECONDARY THEN

547: approver_out_type := AMV_UTILITY_PVT.G_DEFAULT;
548: ELSIF approver_in_type = AMV_UTILITY_PVT.G_OWNER THEN
549: approvers := l_channel_owner;
550: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
551: ELSIF approver_in_type = AMV_UTILITY_PVT.G_SECONDARY THEN
552: OPEN Secn_Approvers;
553: LOOP
554: FETCH Secn_Approvers INTO l_secn_approver;
555: EXIT WHEN Secn_Approvers%NOTFOUND;

Line 558: approver_out_type := AMV_UTILITY_PVT.G_SECONDARY;

554: FETCH Secn_Approvers INTO l_secn_approver;
555: EXIT WHEN Secn_Approvers%NOTFOUND;
556: l_record_counter := l_record_counter + 1;
557: approvers := approvers||' '||l_secn_approver;
558: approver_out_type := AMV_UTILITY_PVT.G_SECONDARY;
559: END LOOP;
560: CLOSE Secn_Approvers;
561:
562: IF (l_record_counter is null) THEN

Line 564: approver_out_type := AMV_UTILITY_PVT.G_OWNER;

560: CLOSE Secn_Approvers;
561:
562: IF (l_record_counter is null) THEN
563: approvers := l_channel_owner;
564: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
565: END IF;
566: ELSE
567: approver_out_type := AMV_UTILITY_PVT.G_DONE;
568: END IF;

Line 567: approver_out_type := AMV_UTILITY_PVT.G_DONE;

563: approvers := l_channel_owner;
564: approver_out_type := AMV_UTILITY_PVT.G_OWNER;
565: END IF;
566: ELSE
567: approver_out_type := AMV_UTILITY_PVT.G_DONE;
568: END IF;
569:
570: EXCEPTION
571: WHEN OTHERS THEN

Line 669: l_forward_to_usertype := AMV_UTILITY_PVT.G_DEFAULT;

665: aname => 'AMV_WORKFLOW_PROCESS' );
666:
667: --
668: IF ( l_forward_to_usertype is null ) THEN
669: l_forward_to_usertype := AMV_UTILITY_PVT.G_DEFAULT;
670: END IF;
671: --
672:
673: -- Call Application API to retrieve an approver

Line 682: IF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN

678:
679: -- NOTE role name and display name are unique
680: -- NOTE set the notification to type
681: --
682: IF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN
683: l_role_name := 'AMV_CHN:'||l_channel_id;
684: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN
685: l_role_name := 'AMV_APPR';
686: ELSE

Line 684: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN

680: -- NOTE set the notification to type
681: --
682: IF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN
683: l_role_name := 'AMV_CHN:'||l_channel_id;
684: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN
685: l_role_name := 'AMV_APPR';
686: ELSE
687: l_role_name := l_forward_to_username;
688: END IF;

Line 704: IF l_out_usertype = AMV_UTILITY_PVT.G_DEFAULT THEN

700: aname => 'AMV_FORWARD_TO_USERNAME',
701: avalue => l_forward_to_username);
702: --
703:
704: IF l_out_usertype = AMV_UTILITY_PVT.G_DEFAULT THEN
705: --
706: l_forward_to_usertype := AMV_UTILITY_PVT.G_SECONDARY;
707: resultout := 'COMPLETE:DEFAULT';
708: --

Line 706: l_forward_to_usertype := AMV_UTILITY_PVT.G_SECONDARY;

702: --
703:
704: IF l_out_usertype = AMV_UTILITY_PVT.G_DEFAULT THEN
705: --
706: l_forward_to_usertype := AMV_UTILITY_PVT.G_SECONDARY;
707: resultout := 'COMPLETE:DEFAULT';
708: --
709: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN
710: --

Line 709: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN

705: --
706: l_forward_to_usertype := AMV_UTILITY_PVT.G_SECONDARY;
707: resultout := 'COMPLETE:DEFAULT';
708: --
709: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN
710: --
711: l_forward_to_usertype := AMV_UTILITY_PVT.G_OWNER;
712: resultout := 'COMPLETE:SECONDARY';
713: --

Line 711: l_forward_to_usertype := AMV_UTILITY_PVT.G_OWNER;

707: resultout := 'COMPLETE:DEFAULT';
708: --
709: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_SECONDARY THEN
710: --
711: l_forward_to_usertype := AMV_UTILITY_PVT.G_OWNER;
712: resultout := 'COMPLETE:SECONDARY';
713: --
714: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN
715: --

Line 714: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN

710: --
711: l_forward_to_usertype := AMV_UTILITY_PVT.G_OWNER;
712: resultout := 'COMPLETE:SECONDARY';
713: --
714: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN
715: --
716: l_forward_to_usertype := AMV_UTILITY_PVT.G_DONE;
717: resultout := 'COMPLETE:OWNER';
718: --

Line 716: l_forward_to_usertype := AMV_UTILITY_PVT.G_DONE;

712: resultout := 'COMPLETE:SECONDARY';
713: --
714: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_OWNER THEN
715: --
716: l_forward_to_usertype := AMV_UTILITY_PVT.G_DONE;
717: resultout := 'COMPLETE:OWNER';
718: --
719: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_DONE THEN
720: --

Line 719: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_DONE THEN

715: --
716: l_forward_to_usertype := AMV_UTILITY_PVT.G_DONE;
717: resultout := 'COMPLETE:OWNER';
718: --
719: ELSIF l_out_usertype = AMV_UTILITY_PVT.G_DONE THEN
720: --
721: l_forward_to_usertype := null;
722: resultout := 'COMPLETE:NONE';
723: --

Line 919: p_approval_status => AMV_UTILITY_PVT.G_APPROVED);

915: p_channel_id => l_channel_id,
916: p_channel_name => FND_API.G_MISS_CHAR,
917: p_category_id => FND_API.G_MISS_NUM,
918: p_item_id => l_item_id,
919: p_approval_status => AMV_UTILITY_PVT.G_APPROVED);
920:
921: -- Check if api completes sucessfully
922: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
923: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1037: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;

1033: l_mychannel_obj.my_channel_id := FND_API.G_MISS_NUM;
1034: l_mychannel_obj.channel_type := FND_API.G_MISS_CHAR;
1035: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;
1036: l_mychannel_obj.user_or_group_id := l_requestor_id;
1037: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1038: l_mychannel_obj.subscribing_to_id := l_channel_id;
1039: l_mychannel_obj.subscribing_to_type := AMV_UTILITY_PVT.G_CHANNEL;
1040: l_mychannel_obj.subscription_reason_type:=AMV_UTILITY_PVT.G_SUBSCRIBED;
1041: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;

Line 1039: l_mychannel_obj.subscribing_to_type := AMV_UTILITY_PVT.G_CHANNEL;

1035: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;
1036: l_mychannel_obj.user_or_group_id := l_requestor_id;
1037: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1038: l_mychannel_obj.subscribing_to_id := l_channel_id;
1039: l_mychannel_obj.subscribing_to_type := AMV_UTILITY_PVT.G_CHANNEL;
1040: l_mychannel_obj.subscription_reason_type:=AMV_UTILITY_PVT.G_SUBSCRIBED;
1041: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1042: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1043: l_mychannel_obj.notify_flag := FND_API.G_FALSE;

Line 1040: l_mychannel_obj.subscription_reason_type:=AMV_UTILITY_PVT.G_SUBSCRIBED;

1036: l_mychannel_obj.user_or_group_id := l_requestor_id;
1037: l_mychannel_obj.user_or_group_type :=AMV_UTILITY_PVT.G_USER;
1038: l_mychannel_obj.subscribing_to_id := l_channel_id;
1039: l_mychannel_obj.subscribing_to_type := AMV_UTILITY_PVT.G_CHANNEL;
1040: l_mychannel_obj.subscription_reason_type:=AMV_UTILITY_PVT.G_SUBSCRIBED;
1041: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1042: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1043: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1044: l_mychannel_obj.notification_interval_type := FND_API.G_MISS_CHAR;

Line 1042: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;

1038: l_mychannel_obj.subscribing_to_id := l_channel_id;
1039: l_mychannel_obj.subscribing_to_type := AMV_UTILITY_PVT.G_CHANNEL;
1040: l_mychannel_obj.subscription_reason_type:=AMV_UTILITY_PVT.G_SUBSCRIBED;
1041: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;
1042: l_mychannel_obj.status := AMV_UTILITY_PVT.G_ACTIVE;
1043: l_mychannel_obj.notify_flag := FND_API.G_FALSE;
1044: l_mychannel_obj.notification_interval_type := FND_API.G_MISS_CHAR;
1045: /*
1046: l_mychannel_obj := amv_my_channel_obj_type(

Line 1051: AMV_UTILITY_PVT.G_USER,

1047: FND_API.G_MISS_NUM,
1048: FND_API.G_MISS_CHAR,
1049: FND_API.G_MISS_CHAR,
1050: l_requestor_id,
1051: AMV_UTILITY_PVT.G_USER,
1052: l_channel_id,
1053: AMV_UTILITY_PVT.G_CHANNEL,
1054: AMV_UTILITY_PVT.G_SUBSCRIBED,
1055: FND_API.G_MISS_NUM,

Line 1053: AMV_UTILITY_PVT.G_CHANNEL,

1049: FND_API.G_MISS_CHAR,
1050: l_requestor_id,
1051: AMV_UTILITY_PVT.G_USER,
1052: l_channel_id,
1053: AMV_UTILITY_PVT.G_CHANNEL,
1054: AMV_UTILITY_PVT.G_SUBSCRIBED,
1055: FND_API.G_MISS_NUM,
1056: AMV_UTILITY_PVT.G_ACTIVE,
1057: FND_API.G_FALSE,

Line 1054: AMV_UTILITY_PVT.G_SUBSCRIBED,

1050: l_requestor_id,
1051: AMV_UTILITY_PVT.G_USER,
1052: l_channel_id,
1053: AMV_UTILITY_PVT.G_CHANNEL,
1054: AMV_UTILITY_PVT.G_SUBSCRIBED,
1055: FND_API.G_MISS_NUM,
1056: AMV_UTILITY_PVT.G_ACTIVE,
1057: FND_API.G_FALSE,
1058: FND_API.G_MISS_CHAR);

Line 1056: AMV_UTILITY_PVT.G_ACTIVE,

1052: l_channel_id,
1053: AMV_UTILITY_PVT.G_CHANNEL,
1054: AMV_UTILITY_PVT.G_SUBSCRIBED,
1055: FND_API.G_MISS_NUM,
1056: AMV_UTILITY_PVT.G_ACTIVE,
1057: FND_API.G_FALSE,
1058: FND_API.G_MISS_CHAR);
1059: */
1060:

Line 1192: p_approval_status => AMV_UTILITY_PVT.G_REJECTED);

1188: p_channel_id => l_channel_id,
1189: p_channel_name => FND_API.G_MISS_CHAR,
1190: p_category_id => FND_API.G_MISS_NUM,
1191: p_item_id => l_item_id,
1192: p_approval_status => AMV_UTILITY_PVT.G_REJECTED);
1193:
1194: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1195: wf_engine.SetItemAttrText ( itemtype => itemtype,
1196: itemkey => itemkey,