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 FND_API

Line 181: l_setup_result varchar2(1) := FND_API.G_FALSE;

177: l_api_version number := 1.0;
178: l_return_status varchar2(1);
179: l_msg_count number;
180: l_msg_data varchar2(80);
181: l_setup_result varchar2(1) := FND_API.G_FALSE;
182: --
183: l_default_approver_id number;
184: l_owner_id number;
185: l_create_flag varchar2(1);

Line 209: p_check_login_user => FND_API.G_FALSE,

205: p_api_version => l_api_version,
206: x_return_status => l_return_status,
207: x_msg_count => l_msg_count,
208: x_msg_data => l_msg_data,
209: p_check_login_user => FND_API.G_FALSE,
210: p_resource_id => user_id,
211: p_include_group_flag => FND_API.G_TRUE,
212: x_result_flag => l_setup_result
213: );

Line 211: p_include_group_flag => FND_API.G_TRUE,

207: x_msg_count => l_msg_count,
208: x_msg_data => l_msg_data,
209: p_check_login_user => FND_API.G_FALSE,
210: p_resource_id => user_id,
211: p_include_group_flag => FND_API.G_TRUE,
212: x_result_flag => l_setup_result
213: );
214:
215: IF l_setup_result = FND_API.G_TRUE THEN

Line 215: IF l_setup_result = FND_API.G_TRUE THEN

211: p_include_group_flag => FND_API.G_TRUE,
212: x_result_flag => l_setup_result
213: );
214:
215: IF l_setup_result = FND_API.G_TRUE THEN
216: return(TRUE);
217: ELSE
218: OPEN Chan_Approvers;
219: FETCH Chan_Approvers INTO l_default_approver_id, l_owner_id;

Line 231: IF l_approver_flag = FND_API.G_TRUE THEN

227: OPEN Sec_Approvers;
228: FETCH Sec_Approvers INTO l_approver_flag;
229: CLOSE Sec_Approvers;
230:
231: IF l_approver_flag = FND_API.G_TRUE THEN
232: return(TRUE);
233: ELSE
234: return(FALSE);
235: END IF;

Line 318: p_check_login_user => FND_API.G_FALSE,

314: p_api_version => l_api_version,
315: x_return_status => l_return_status,
316: x_msg_count => l_msg_count,
317: x_msg_data => l_msg_data,
318: p_check_login_user => FND_API.G_FALSE,
319: p_resource_id => l_requestor_id,
320: p_include_group_flag => FND_API.G_TRUE,
321: x_result_flag => l_setup_result
322: );

Line 320: p_include_group_flag => FND_API.G_TRUE,

316: x_msg_count => l_msg_count,
317: x_msg_data => l_msg_data,
318: p_check_login_user => FND_API.G_FALSE,
319: p_resource_id => l_requestor_id,
320: p_include_group_flag => FND_API.G_TRUE,
321: x_result_flag => l_setup_result
322: );
323:
324: IF l_setup_result = FND_API.G_TRUE THEN

Line 324: IF l_setup_result = FND_API.G_TRUE THEN

320: p_include_group_flag => FND_API.G_TRUE,
321: x_result_flag => l_setup_result
322: );
323:
324: IF l_setup_result = FND_API.G_TRUE THEN
325: resultout := wf_engine.eng_completed||':Y';
326: ELSE
327: OPEN Chn_Publish;
328: FETCH Chn_Publish INTO l_publish_flag;

Line 331: IF l_publish_flag = FND_API.G_TRUE THEN

327: OPEN Chn_Publish;
328: FETCH Chn_Publish INTO l_publish_flag;
329: CLOSE Chn_Publish;
330:
331: IF l_publish_flag = FND_API.G_TRUE THEN
332: IF Is_ChannelApprover(l_channel_id, l_requestor_id) THEN
333: resultout := wf_engine.eng_completed||':Y';
334: ELSE
335: OPEN Chn_Access;

Line 339: IF l_create_flag = FND_API.G_TRUE THEN

335: OPEN Chn_Access;
336: FETCH Chn_Access INTO l_create_flag;
337: CLOSE Chn_Access;
338:
339: IF l_create_flag = FND_API.G_TRUE THEN
340: resultout := wf_engine.eng_completed||':Y';
341: ELSE
342: resultout := wf_engine.eng_completed||':N';
343: END IF;

Line 446: IF l_subscribe_flag = FND_API.G_TRUE THEN

442: OPEN Chn_Subscribe;
443: FETCH Chn_Subscribe INTO l_subscribe_flag;
444: CLOSE Chn_Subscribe;
445:
446: IF l_subscribe_flag = FND_API.G_TRUE THEN
447: IF Is_ChannelApprover(l_channel_id, l_requestor_id) THEN
448: resultout := wf_engine.eng_completed||':Y';
449: ELSE
450: OPEN Chn_Access;

Line 454: IF l_view_flag = FND_API.G_TRUE THEN

450: OPEN Chn_Access;
451: FETCH Chn_Access INTO l_view_flag;
452: CLOSE Chn_Access;
453:
454: IF l_view_flag = FND_API.G_TRUE THEN
455: resultout := wf_engine.eng_completed||':Y';
456: ELSE
457: resultout := wf_engine.eng_completed||':N';
458: END IF;

Line 908: p_init_msg_list => FND_API.G_FALSE,

904:
905: IF l_approval_status is null THEN
906: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
907: p_api_version => l_api_version,
908: p_init_msg_list => FND_API.G_FALSE,
909: p_commit => FND_API.G_FALSE,
910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
911: x_return_status => l_return_status,
912: x_msg_count => l_msg_count,

Line 909: p_commit => FND_API.G_FALSE,

905: IF l_approval_status is null THEN
906: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
907: p_api_version => l_api_version,
908: p_init_msg_list => FND_API.G_FALSE,
909: p_commit => FND_API.G_FALSE,
910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
911: x_return_status => l_return_status,
912: x_msg_count => l_msg_count,
913: x_msg_data => l_msg_data,

Line 910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

906: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
907: p_api_version => l_api_version,
908: p_init_msg_list => FND_API.G_FALSE,
909: p_commit => FND_API.G_FALSE,
910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
911: x_return_status => l_return_status,
912: x_msg_count => l_msg_count,
913: x_msg_data => l_msg_data,
914: p_check_login_user => FND_API.G_FALSE,

Line 914: p_check_login_user => FND_API.G_FALSE,

910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
911: x_return_status => l_return_status,
912: x_msg_count => l_msg_count,
913: x_msg_data => l_msg_data,
914: p_check_login_user => FND_API.G_FALSE,
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,

Line 916: p_channel_name => FND_API.G_MISS_CHAR,

912: x_msg_count => l_msg_count,
913: x_msg_data => l_msg_data,
914: p_check_login_user => FND_API.G_FALSE,
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:

Line 917: p_category_id => FND_API.G_MISS_NUM,

913: x_msg_data => l_msg_data,
914: p_check_login_user => FND_API.G_FALSE,
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

Line 922: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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,
924: itemkey => itemkey,
925: aname => 'AMV_APPROVAL_STATUS',
926: avalue => 'NOTIFIED');

Line 1033: l_mychannel_obj.my_channel_id := FND_API.G_MISS_NUM;

1029: itemkey => itemkey,
1030: aname => 'AMV_REQUESTOR_ID' );
1031:
1032: IF l_approval_status is null THEN
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;

Line 1034: l_mychannel_obj.channel_type := FND_API.G_MISS_CHAR;

1030: aname => 'AMV_REQUESTOR_ID' );
1031:
1032: IF l_approval_status is null THEN
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;

Line 1035: l_mychannel_obj.access_level_type := FND_API.G_MISS_CHAR;

1031:
1032: IF l_approval_status is null THEN
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;

Line 1041: l_mychannel_obj.order_number := FND_API.G_MISS_NUM;

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;
1045: /*

Line 1043: l_mychannel_obj.notify_flag := FND_API.G_FALSE;

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(
1047: FND_API.G_MISS_NUM,

Line 1044: l_mychannel_obj.notification_interval_type := FND_API.G_MISS_CHAR;

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(
1047: FND_API.G_MISS_NUM,
1048: FND_API.G_MISS_CHAR,

Line 1047: FND_API.G_MISS_NUM,

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(
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,

Line 1048: FND_API.G_MISS_CHAR,

1044: l_mychannel_obj.notification_interval_type := FND_API.G_MISS_CHAR;
1045: /*
1046: l_mychannel_obj := amv_my_channel_obj_type(
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,

Line 1049: FND_API.G_MISS_CHAR,

1045: /*
1046: l_mychannel_obj := amv_my_channel_obj_type(
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,

Line 1055: FND_API.G_MISS_NUM,

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);
1059: */

Line 1057: FND_API.G_FALSE,

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:
1061: AMV_MYCHANNEL_PVT.Add_Subscription(

Line 1058: FND_API.G_MISS_CHAR);

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:
1061: AMV_MYCHANNEL_PVT.Add_Subscription(
1062: p_api_version => l_api_version,

Line 1063: p_init_msg_list => FND_API.G_FALSE,

1059: */
1060:
1061: AMV_MYCHANNEL_PVT.Add_Subscription(
1062: p_api_version => l_api_version,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_TRUE,
1065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status => l_return_status,
1067: x_msg_count => l_msg_count,

Line 1064: p_commit => FND_API.G_TRUE,

1060:
1061: AMV_MYCHANNEL_PVT.Add_Subscription(
1062: p_api_version => l_api_version,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_TRUE,
1065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status => l_return_status,
1067: x_msg_count => l_msg_count,
1068: x_msg_data => l_msg_data,

Line 1065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1061: AMV_MYCHANNEL_PVT.Add_Subscription(
1062: p_api_version => l_api_version,
1063: p_init_msg_list => FND_API.G_FALSE,
1064: p_commit => FND_API.G_TRUE,
1065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status => l_return_status,
1067: x_msg_count => l_msg_count,
1068: x_msg_data => l_msg_data,
1069: p_check_login_user => FND_API.G_FALSE,

Line 1069: p_check_login_user => FND_API.G_FALSE,

1065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1066: x_return_status => l_return_status,
1067: x_msg_count => l_msg_count,
1068: x_msg_data => l_msg_data,
1069: p_check_login_user => FND_API.G_FALSE,
1070: p_mychannel_obj => l_mychannel_obj,
1071: x_mychannel_id => l_mychannel_id);
1072:
1073: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1073: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1069: p_check_login_user => FND_API.G_FALSE,
1070: p_mychannel_obj => l_mychannel_obj,
1071: x_mychannel_id => l_mychannel_id);
1072:
1073: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1074: wf_engine.SetItemAttrText ( itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'AMV_APPROVAL_STATUS',
1077: avalue => 'NOTIFIED');

Line 1181: p_init_msg_list => FND_API.G_FALSE,

1177:
1178: IF l_approval_status is null THEN
1179: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
1180: p_api_version => l_api_version,
1181: p_init_msg_list => FND_API.G_FALSE,
1182: p_commit => FND_API.G_FALSE,
1183: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1184: x_return_status => l_return_status,
1185: x_msg_count => l_msg_count,

Line 1182: p_commit => FND_API.G_FALSE,

1178: IF l_approval_status is null THEN
1179: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
1180: p_api_version => l_api_version,
1181: p_init_msg_list => FND_API.G_FALSE,
1182: p_commit => FND_API.G_FALSE,
1183: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1184: x_return_status => l_return_status,
1185: x_msg_count => l_msg_count,
1186: x_msg_data => l_msg_data,

Line 1183: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1179: AMV_CHANNEL_PVT.Set_ChannelApprovalStatus(
1180: p_api_version => l_api_version,
1181: p_init_msg_list => FND_API.G_FALSE,
1182: p_commit => FND_API.G_FALSE,
1183: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1184: x_return_status => l_return_status,
1185: x_msg_count => l_msg_count,
1186: x_msg_data => l_msg_data,
1187: p_check_login_user => FND_API.G_FALSE,

Line 1187: p_check_login_user => FND_API.G_FALSE,

1183: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1184: x_return_status => l_return_status,
1185: x_msg_count => l_msg_count,
1186: x_msg_data => l_msg_data,
1187: p_check_login_user => FND_API.G_FALSE,
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,

Line 1189: p_channel_name => FND_API.G_MISS_CHAR,

1185: x_msg_count => l_msg_count,
1186: x_msg_data => l_msg_data,
1187: p_check_login_user => FND_API.G_FALSE,
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:

Line 1190: p_category_id => FND_API.G_MISS_NUM,

1186: x_msg_data => l_msg_data,
1187: p_check_login_user => FND_API.G_FALSE,
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

Line 1194: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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,
1197: aname => 'AMV_APPROVAL_STATUS',
1198: avalue => 'NOTIFIED');