DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_DELIVERABLE_UTILS

Line 5213: Pa_Deliverable_Utils.enable_deliverable(

5209:
5210: i := p_deliverables_in.first();
5211:
5212: IF ( G_DLVR_STRUCTURE_ENABLED = 'Y' ) THEN
5213: Pa_Deliverable_Utils.enable_deliverable(
5214: p_api_version => p_api_version_number
5215: , p_init_msg_list => FND_API.G_FALSE
5216: , p_commit => FND_API.G_FALSE--bug 3766967
5217: , p_debug_mode => l_debug_mode

Line 7298: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

7294:
7295: IF ( ( p_deliverable_id IS NOT NULL AND p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
7296: ( p_deliverable IS NOT NULL AND p_deliverable <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
7297:
7298: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
7299: ( p_deliverable_reference => p_deliverable
7300: , p_deliverable_id => p_deliverable_id
7301: , p_project_id => l_project_id
7302: , p_out_deliverable_id => l_deliverable_id

Line 21607: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

21603: -- then call below api to validate reference and id
21604:
21605: IF p_deliverables_in(i).deliverable_id IS NOT NULL AND p_deliverables_in(i).deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
21606:
21607: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
21608: ( p_deliverable_reference => p_deliverables_in(i).pm_deliverable_reference
21609: , p_deliverable_id => p_deliverables_in(i).deliverable_id
21610: , p_project_id => l_project_id
21611: , p_out_deliverable_id => l_deliverable_id

Line 21637: pa_deliverable_utils.is_dlvr_reference_unique (

21633: l_dlvr_dml_action := G_UPDATE_MODE;
21634: ELSE
21635: -- Bug 3651538 Moved the call of api from outside IF condition to inside else part
21636: -- as need to check for reference uniqueness only if ID is not passed.
21637: pa_deliverable_utils.is_dlvr_reference_unique (
21638: p_deliverable_reference => p_deliverables_in(i).pm_deliverable_reference
21639: , p_project_id => l_project_id
21640: , x_unique_flag => l_unique_flag
21641: , x_return_status => x_return_status );

Line 29664: PA_Deliverable_Utils.is_dlvr_reference_unique(

29660:
29661: END IF;
29662:
29663: -- Validate Deliverable reference - not null, unique
29664: PA_Deliverable_Utils.is_dlvr_reference_unique(
29665: p_deliverable_reference => p_pm_deliverable_reference
29666: , p_project_id => l_project_id
29667: , x_unique_flag => l_unique_flag
29668: , x_return_status => x_return_status );

Line 29742: Pa_Deliverable_Utils.enable_deliverable(

29738: END IF;
29739:
29740: IF ( l_dlvr_enabled = 'N' ) THEN
29741:
29742: Pa_Deliverable_Utils.enable_deliverable(
29743: p_api_version => p_api_version
29744: , p_init_msg_list => FND_API.G_FALSE
29745: , p_commit => p_commit
29746: , p_debug_mode => p_debug_mode

Line 29755: pa_debug.write(g_pkg_name,'Pa_Deliverable_Utils.enable_deliverable Return Status ['||x_return_status||']',3) ;

29751: , x_msg_data => x_msg_data
29752: );
29753:
29754: IF p_debug_mode = 'Y' THEN
29755: pa_debug.write(g_pkg_name,'Pa_Deliverable_Utils.enable_deliverable Return Status ['||x_return_status||']',3) ;
29756: END IF;
29757:
29758: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
29759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 29776: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_OWNER

29772: -- here in defaulting , considered only project flow
29773: -- task flow is not considered and passing task ver id as NULL
29774:
29775: IF p_deliverable_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
29776: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_OWNER
29777: (
29778: p_project_id => p_project_id
29779: ,p_task_ver_id => NULL
29780: ,x_owner_id => l_dlvr_owner_id

Line 29788: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_DATE

29784: l_dlvr_owner_id := p_deliverable_owner_id;
29785: END IF;
29786:
29787: IF p_due_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
29788: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_DATE
29789: (
29790: p_project_id => p_project_id
29791: ,p_task_ver_id => NULL
29792: ,x_due_date => l_default_date

Line 29867: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO

29863: END IF;
29864: -- Will create actions only when deliverable type of deliverable
29865: -- has action creation enabled.
29866:
29867: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO
29868: (
29869: p_dlvr_type_id => p_deliverable_type_id
29870: ,x_dlvr_prg_enabled => l_dlvr_prg_enabled
29871: ,x_dlvr_action_enabled => l_dlvr_action_enabled

Line 30256: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(

30252: RAISE FND_API.G_EXC_ERROR;
30253: END IF;
30254:
30255: -- Validate Deliverable reference / ID
30256: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(
30257: p_deliverable_reference => p_deliverable_reference
30258: , p_deliverable_id => p_deliverable_id
30259: , p_project_id => l_project_id
30260: , p_out_deliverable_id => l_deliverable_id

Line 30297: pa_deliverable_utils.is_action_reference_unique (

30293:
30294: END IF;
30295:
30296: -- Validate Action reference - not null, unique
30297: pa_deliverable_utils.is_action_reference_unique (
30298: p_action_reference => p_pm_action_reference
30299: , p_deliverable_id => l_deliverable_id
30300: , p_project_id => l_project_id
30301: , x_unique_flag => l_unique_flag

Line 30327: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO

30323:
30324: -- Will create actions only when deliverable type of deliverable
30325: -- has action creation enabled.
30326:
30327: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO
30328: (
30329: p_dlvr_type_id => l_dlvr_type_id
30330: ,x_dlvr_prg_enabled => l_dlvr_prg_enabled
30331: ,x_dlvr_action_enabled => l_dlvr_action_enabled

Line 30802: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

30798: END IF;
30799: END IF;
30800:
30801: -- Validate Deliverable reference / id- not null, unique
30802: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
30803: ( p_deliverable_reference => p_pm_deliverable_reference
30804: , p_deliverable_id => px_deliverable_id
30805: , p_project_id => l_project_id
30806: , p_out_deliverable_id => l_deliverable_id

Line 30913: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

30909:
30910: -- deriving deliverable id from deliverable reference
30911:
30912: IF i IS NOT NULL THEN
30913: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
30914: ( p_deliverable_reference => p_action_in_tbl(i).pm_deliverable_reference
30915: , p_deliverable_id => p_action_in_tbl(i).deliverable_id
30916: , p_project_id => l_project_id
30917: , p_out_deliverable_id => l_dlvr_id

Line 30948: Pa_Deliverable_Utils.Convert_pm_actionref_to_id (

30944: -- if action id not null, then and only then , action reference to id validation should be done
30945: -- in case of new action below validon will fail and will not allow user to create new actions from update_deliverable
30946:
30947: IF l_action_id IS NOT NULL THEN
30948: Pa_Deliverable_Utils.Convert_pm_actionref_to_id (
30949: p_action_reference => p_action_in_tbl(i_actn).pm_action_reference
30950: ,p_action_id => l_action_id
30951: ,p_deliverable_id => l_deliverable_id
30952: ,p_project_id => l_Project_id

Line 31335: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(

31331: RAISE FND_API.G_EXC_ERROR;
31332: END IF;
31333:
31334: -- Validate Deliverable reference / ID
31335: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(
31336: p_deliverable_reference => p_deliverable_reference
31337: , p_deliverable_id => p_deliverable_id
31338: , p_project_id => l_project_id
31339: , p_out_deliverable_id => l_deliverable_id

Line 31354: PA_Deliverable_Utils.Convert_pm_actionref_to_id(

31350: END IF;
31351:
31352:
31353: -- 3729250 Validate Deliverable Action reference / ID
31354: PA_Deliverable_Utils.Convert_pm_actionref_to_id(
31355: p_action_reference => p_pm_action_reference
31356: , p_action_id => p_action_id
31357: , p_deliverable_id => l_deliverable_id
31358: , p_project_id => l_project_id

Line 31681: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

31677: RAISE FND_API.G_EXC_ERROR;
31678: END IF;
31679:
31680: -- Validate Deliverable Reference / ID
31681: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
31682: ( p_deliverable_reference => p_pm_dlv_source_reference
31683: -- for bug# 3729250
31684: , p_deliverable_id => p_deliverable_id
31685: , p_project_id => l_project_id

Line 31701: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

31697: RAISE FND_API.G_EXC_ERROR;
31698: END IF;
31699:
31700: -- Derive deliverable version ID and call api Delete Deliverable. It
31701: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
31702:
31703: IF l_debug_mode = 'Y' THEN
31704: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
31705: END IF;

Line 31954: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

31950: RAISE FND_API.G_EXC_ERROR;
31951: END IF;
31952:
31953: -- Validate Deliverable Reference / ID
31954: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
31955: ( p_deliverable_reference => p_pm_deliverable_reference
31956: , p_deliverable_id => p_deliverable_id
31957: , p_project_id => l_project_id
31958: , p_out_deliverable_id => l_deliverable_id

Line 31973: Pa_Deliverable_Utils.Convert_pm_actionref_to_id

31969: RAISE FND_API.G_EXC_ERROR;
31970: END IF;
31971:
31972: -- Validate Action Reference / ID
31973: Pa_Deliverable_Utils.Convert_pm_actionref_to_id
31974: (
31975: p_action_reference => p_action_source_reference
31976: ,p_action_id => p_action_id
31977: ,p_deliverable_id => l_deliverable_id -- 3749480 earlier p_deliverable_id was used

Line 31994: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

31990: RAISE FND_API.G_EXC_ERROR;
31991: END IF;
31992:
31993: -- Derive Deliverable_version_id
31994: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
31995:
31996: IF l_debug_mode = 'Y' THEN
31997: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
31998: END IF;

Line 32001: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;

31997: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
31998: END IF;
31999:
32000: -- Derive Action_version_id and Function Code
32001: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;
32002: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;
32003:
32004: IF l_debug_mode = 'Y' THEN
32005: pa_debug.write(g_pkg_name,'Derived Action version ID ['||l_action_version_id||']and function code ['||l_function_code||']',3) ;

Line 32002: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;

31998: END IF;
31999:
32000: -- Derive Action_version_id and Function Code
32001: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;
32002: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;
32003:
32004: IF l_debug_mode = 'Y' THEN
32005: pa_debug.write(g_pkg_name,'Derived Action version ID ['||l_action_version_id||']and function code ['||l_function_code||']',3) ;
32006: END IF;

Line 32248: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32244: RAISE FND_API.G_EXC_ERROR;
32245: END IF;
32246:
32247: -- Validate Deliverable Reference / ID
32248: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32249: ( p_deliverable_reference => p_pm_deliverable_reference
32250: , p_deliverable_id => p_deliverable_id
32251: , p_project_id => l_project_id
32252: , p_out_deliverable_id => l_deliverable_id

Line 32293: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32289: END IF;
32290:
32291:
32292: -- Derive Deliverable_version_id
32293: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32294:
32295: -- Derive Object Relationship ID
32296: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);
32297:

Line 32296: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);

32292: -- Derive Deliverable_version_id
32293: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32294:
32295: -- Derive Object Relationship ID
32296: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);
32297:
32298: -- Calling deliverable api to Delete Association
32299: pa_deliverable_pub.DELETE_DLV_TASK_ASSOCIATION
32300: (p_api_version => p_api_version

Line 32537: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32533: RAISE FND_API.G_EXC_ERROR;
32534: END IF;
32535:
32536: -- Validate Deliverable Reference / ID
32537: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32538: ( p_deliverable_reference => p_deliverable_reference -- 3729250, earlier null was passed
32539: , p_deliverable_id => p_deliverable_id
32540: , p_project_id => l_project_id
32541: , p_out_deliverable_id => l_deliverable_id

Line 32592: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32588:
32589: -- 5462298 end
32590:
32591: -- Derive Deliverable_version_id
32592: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32593:
32594: -- Calling deliverable api to Create Association
32595: pa_deliverable_pvt.CREATE_DLV_TASK_ASSOCIATION
32596: (p_api_version => p_api_version

Line 32824: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32820: RAISE FND_API.G_EXC_ERROR;
32821: END IF;
32822:
32823: -- Validate Deliverable Reference / ID
32824: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32825: ( p_deliverable_reference => p_deliverable_reference -- 3729250 , earlier passed was null
32826: , p_deliverable_id => p_deliverable_id
32827: , p_project_id => l_project_id
32828: , p_out_deliverable_id => l_deliverable_id

Line 32872: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32868: RAISE FND_API.G_EXC_ERROR;
32869: END IF;
32870:
32871: -- Derive Deliverable_version_id
32872: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32873:
32874: -- Calling deliverable api to Create Association
32875: pa_deliverable_pvt.CREATE_DLV_TASK_ASSOCIATION
32876: (p_api_version => p_api_version

Line 33142: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

33138: -- 3888280 start
33139: -- Added code to validate Deliverable Reference and Id
33140:
33141: -- Validate Deliverable Reference / ID
33142: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
33143: ( p_deliverable_reference => p_pm_deliverable_reference
33144: , p_deliverable_id => p_deliverable_id
33145: , p_project_id => l_project_id
33146: , p_out_deliverable_id => l_deliverable_id