[Home] [Help]
573:
574: CURSOR c_resource IS
575: SELECT resource_id
576: FROM ams_jtf_rs_emp_v
577: WHERE user_id = FND_GLOBAL.user_id ;
578:
579: CURSOR c_child IS
580: SELECT 1
581: FROM DUAL
2630: p_activity_id => p_campaign_id,
2631: p_activity_type => 'CAMP',
2632: p_approval_type => 'BUDGET',
2633: p_act_budget_id => null,
2634: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2635: x_must_preview => l_start_wf_process,
2636: x_return_status => l_return_status);
2637:
2638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2660: p_object_version_number => l_object_version,
2661: p_orig_stat_id => l_old_status_id,
2662: p_new_stat_id => p_user_status_id,
2663: p_reject_stat_id => l_deny_status_id,
2664: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2665: p_workflowprocess => 'AMS_APPROVAL',
2666: p_item_type => 'AMSAPRV'
2667: );
2668: ELSE -- If user equals approver
2701: p_activity_id => p_campaign_id,
2702: p_activity_type => 'CAMP',
2703: p_approval_type => 'CONCEPT',
2704: p_act_budget_id => null,
2705: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2706: x_must_preview => l_start_wf_process,
2707: x_return_status => l_return_status);
2708:
2709: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2730: p_object_version_number => l_object_version,
2731: p_orig_stat_id => l_old_status_id,
2732: p_new_stat_id => p_user_status_id,
2733: p_reject_stat_id => l_deny_status_id,
2734: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2735: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
2736: p_item_type => 'AMSAPRV'
2737: );
2738: