DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on PA_DELIVERABLE_UTILS

Line 550: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c1info.pa_action_id ), 1, 250);

546: FETCH c4 INTO L_Flag;
547: CLOSE c4;
548:
549: -- Get deliverable description from PA
550: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c1info.pa_action_id ), 1, 250);
551: PA_DELIVERABLE_UTILS.Get_Action_Project_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
552: , x_project_id => l_project_id
553: , x_project_name => l_header_number );
554: PA_DELIVERABLE_UTILS.Get_Action_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id

Line 551: PA_DELIVERABLE_UTILS.Get_Action_Project_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id

547: CLOSE c4;
548:
549: -- Get deliverable description from PA
550: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c1info.pa_action_id ), 1, 250);
551: PA_DELIVERABLE_UTILS.Get_Action_Project_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
552: , x_project_id => l_project_id
553: , x_project_name => l_header_number );
554: PA_DELIVERABLE_UTILS.Get_Action_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
555: , x_name => l_action_name

Line 554: PA_DELIVERABLE_UTILS.Get_Action_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id

550: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c1info.pa_action_id ), 1, 250);
551: PA_DELIVERABLE_UTILS.Get_Action_Project_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
552: , x_project_id => l_project_id
553: , x_project_name => l_header_number );
554: PA_DELIVERABLE_UTILS.Get_Action_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
555: , x_name => l_action_name
556: , x_number => l_action_number );
557: PA_DELIVERABLE_UTILS.Get_Dlvr_Detail ( p_dlvr_ver_id => c1info.source_deliverable_id
558: , x_name => l_deliverable_name

Line 557: PA_DELIVERABLE_UTILS.Get_Dlvr_Detail ( p_dlvr_ver_id => c1info.source_deliverable_id

553: , x_project_name => l_header_number );
554: PA_DELIVERABLE_UTILS.Get_Action_Detail ( p_dlvr_action_ver_id => c1info.pa_action_id
555: , x_name => l_action_name
556: , x_number => l_action_number );
557: PA_DELIVERABLE_UTILS.Get_Dlvr_Detail ( p_dlvr_ver_id => c1info.source_deliverable_id
558: , x_name => l_deliverable_name
559: , x_number => l_deliverable_number );
560: --
561: -- Leave 25 for deliverable short name if over 150 after concat

Line 756: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c2info.pa_action_id ), 1, 240);

752: FETCH c1 INTO L_Employee;
753: CLOSE c1;
754:
755: L_Context := 'Y';
756: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c2info.pa_action_id ), 1, 240);
757:
758: IF c2info.reference1>0 THEN
759: DELETE FROM po_requisitions_interface_all
760: WHERE oke_contract_deliverable_id = c2info.action_id