DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_ASSIGNMENT_APPROVAL_PUB

Line 949: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;

945:
946: -- Start 5130421
947: -- nvl in below clause is needed for flow other than AMG
948: IF nvl(PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE,'N') = 'Y' THEN
949: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
950: ELSE
951: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;
952: END IF;
953:

Line 951: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;

947: -- nvl in below clause is needed for flow other than AMG
948: IF nvl(PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE,'N') = 'Y' THEN
949: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
950: ELSE
951: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;
952: END IF;
953:
954: --RESET the global variable after usage
955: PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE := NULL;

Line 963: -- Commented for PJR Enhancement 5130421 ,p_apprvl_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_working

959: (p_assignment_name => l_assignment_rec.assignment_name
960: ,p_assignment_type => l_assignment_rec.assignment_type
961: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag
962: ,p_status_code => l_assignment_rec.status_code
963: -- Commented for PJR Enhancement 5130421 ,p_apprvl_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_working
964: ,p_apprvl_status_code => l_apprvl_status_code -- Included for 5130421
965: ,p_staffing_priority_code => l_assignment_rec.staffing_priority_code
966: ,p_project_id => l_assignment_rec.project_id
967: ,p_project_role_id => l_assignment_rec.project_role_id

Line 2008: IF l_assignment_rec.apprvl_status_code= PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN

2004: END IF;
2005: */
2006:
2007: --Insert into history table if changing from 'APPROVED' to 'WORKING'
2008: IF l_assignment_rec.apprvl_status_code= PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
2009:
2010: --Log Message
2011: IF P_DEBUG_MODE = 'Y' THEN
2012: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.insert_history'

Line 2038: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_update_action

2034: -- Get the status code after action performed.
2035: /* bug 8233045: GSI ER, skipping the following validation only when call is in bulk mode. This might need to be revisited later */
2036: -- bug#9441844
2037: -- if (PA_ASSIGNMENTS_PUB.G_update_assignment_bulk_call <> 'Y') then
2038: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_update_action
2039: ,p_status_code => l_assignment_rec.apprvl_status_code
2040: -- ,x_status_code => l_assignment_rec.apprvl_status_code * commented for Bug: 4537865
2041: ,x_status_code => l_new_status_code -- added for Bug: 4537865
2042: ,x_return_status => l_return_status);