DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_ASSIGNMENT_APPROVAL_PUB

Line 918: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;

914:
915: -- Start 5130421
916: -- nvl in below clause is needed for flow other than AMG
917: IF nvl(PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE,'N') = 'Y' THEN
918: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
919: ELSE
920: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;
921: END IF;
922:

Line 920: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;

916: -- nvl in below clause is needed for flow other than AMG
917: IF nvl(PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE,'N') = 'Y' THEN
918: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
919: ELSE
920: l_apprvl_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working ;
921: END IF;
922:
923: --RESET the global variable after usage
924: PA_STAFFED_ASSIGNMENT_PVT.G_AUTO_APPROVE := NULL;

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

928: (p_assignment_name => l_assignment_rec.assignment_name
929: ,p_assignment_type => l_assignment_rec.assignment_type
930: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag
931: ,p_status_code => l_assignment_rec.status_code
932: -- Commented for PJR Enhancement 5130421 ,p_apprvl_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_working
933: ,p_apprvl_status_code => l_apprvl_status_code -- Included for 5130421
934: ,p_staffing_priority_code => l_assignment_rec.staffing_priority_code
935: ,p_project_id => l_assignment_rec.project_id
936: ,p_project_role_id => l_assignment_rec.project_role_id

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

1973: END IF;
1974: */
1975:
1976: --Insert into history table if changing from 'APPROVED' to 'WORKING'
1977: IF l_assignment_rec.apprvl_status_code= PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
1978:
1979: --Log Message
1980: IF P_DEBUG_MODE = 'Y' THEN
1981: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.insert_history'

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

2000: ,x_log_level => 5);
2001:
2002: END IF;
2003: -- Get the status code after action performed.
2004: PA_ASSIGNMENT_APPROVAL_PVT.Get_Next_Status_After_Action ( p_action_code => PA_ASSIGNMENT_APPROVAL_PUB.g_update_action
2005: ,p_status_code => l_assignment_rec.apprvl_status_code
2006: -- ,x_status_code => l_assignment_rec.apprvl_status_code * commented for Bug: 4537865
2007: ,x_status_code => l_new_status_code -- added for Bug: 4537865
2008: ,x_return_status => l_return_status);