DBA Data[Home] [Help]

APPS.PA_ACTIONS_PUB dependencies on PA_LOOKUPS

Line 74: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

70: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
71: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
72: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
73: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
74: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
75: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
76: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
77: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
78: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 122: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

118: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
119: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
120: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694, added default value
121: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
122: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
123: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
124: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
125: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
126: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 140: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

136: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
137: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
138: ,p_debug_mode IN VARCHAR2 :='N'
139: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
141: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
142: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
144: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 170: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

166: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
167: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
168: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
169: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
170: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
171: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
172: ,p_carrying_out_org_id IN NUMBER := null
173: ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
174: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null

Line 220: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

216: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
217: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
218: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
219: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
220: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
221: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
222: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
223: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
224: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 282: ,p_function IN pa_lookups.lookup_code%TYPE

278: PROCEDURE RUN_ACTION_CONC_PROCESS
279: (
280: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
281: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282: ,p_function IN pa_lookups.lookup_code%TYPE
283: ,p_project_number_from IN pa_projects_all.segment1%TYPE :=NULL
284: ,p_project_number_to IN pa_projects_all.segment1%TYPE :=NULL
285: );
286:

Line 326: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

322: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
323: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
324: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
325: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
326: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
327: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
328: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
329: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
330: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'