DBA Data[Home] [Help]

APPS.PA_ACTIONS_PVT dependencies on PA_LOOKUPS

Line 7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';

3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pvt';
5:
6: Invalid_Arg_Exc_Dlv EXCEPTION ;
7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';

Line 8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';

4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pvt';
5:
6: Invalid_Arg_Exc_Dlv EXCEPTION ;
7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';

Line 9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';

5:
6: Invalid_Arg_Exc_Dlv EXCEPTION ;
7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';

Line 10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';

6: Invalid_Arg_Exc_Dlv EXCEPTION ;
7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
14:

Line 11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';

7: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
14:
15: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK

Line 12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';

8: g_actions CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_ACTIONS';
9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
14:
15: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK
16: -- Type : PROCEDURE

Line 13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';

9: g_dlvr_type_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DLVR_TYPE_TO_ACTION';
10: g_dlvr_to_action CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELIVERABLE_TO_ACTION';
11: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
12: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
13: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
14:
15: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK
16: -- Type : PROCEDURE
17: -- Purpose : Private API to create to Deliverable Actions

Line 105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

101: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
102: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
103: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
104: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
107: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
108: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
109: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

516: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
517: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
518: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
522: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
523: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
524: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 682: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
680: ,p_debug_mode IN VARCHAR2 :='N'
681: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
682: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
683: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
684: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
685: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
686: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()