APPS.PA_DELIVERABLE_PVT dependencies on PA_LOOKUPS

Line 6: g_deliverable_based CONSTANT pa_lookups.lookup_code%TYPE := 'DELIVERABLE' ;

2: /* $Header: PADLVPVB.pls 120.3 2006/01/27 04:39:32 vkadimes noship $ */
3:
4: Invalid_Arg_Exc_Dlv EXCEPTION ;
5: g_module_name VARCHAR2(100) := 'PA_DELIVERABLE_PVT';
6: g_deliverable_based CONSTANT pa_lookups.lookup_code%TYPE := 'DELIVERABLE' ;
7:
8: -- Procedure : Create_Deliverable
9: -- Type : PRIVATE
10: -- Purpose : Create_Deliverable Procedure will be called for creation of deliverable

Line 3846: l_suffix pa_lookups.meaning%TYPE ;

3842: l_parent_structure_id NUMBER ;
3843: l_parent_structure_version_id NUMBER ;
3844: l_y_or_n VARCHAR2(1) ;
3845: l_project_name pa_projects_all.name%TYPE ;
3846: l_suffix pa_lookups.meaning%TYPE ;
3847: l_name VARCHAR2(250);
3848:
3849: l_element_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3850: l_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;

Line 3921: FROM pa_lookups

3917: -- Below two selects are used for creating structure level
3918: -- element name .
3919: SELECT meaning
3920: INTO l_suffix
3921: FROM pa_lookups
3922: WHERE lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
3923: AND lookup_code = 'DELIVERABLE';
3924:
3925: SELECT name