eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTIONS_PUB dependencies on PA_LOOKUPS

Line 7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;

3:
4: Invalid_Arg_Exc_Dlv EXCEPTION ;
5: g_plsql_max_array_size NUMBER := 200 ;
6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';
7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;

Line 8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;

4: Invalid_Arg_Exc_Dlv EXCEPTION ;
5: g_plsql_max_array_size NUMBER := 200 ;
6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';
7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;

Line 9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;

5: g_plsql_max_array_size NUMBER := 200 ;
6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';
7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';

Line 10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;

6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';
7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';

Line 11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;

7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';

Line 12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;

8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';

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

9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';

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

10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;
11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';

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

11: g_modified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'MODIFIED' ;
12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';

Line 16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';

12: g_unmodified CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNMODIFIED' ;
13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';

Line 17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';

13: g_billing CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BILLING';
14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';

Line 18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';

14: g_shipping CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SHIPPING';
15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';
22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';

Line 19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';

15: g_procurement CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROCUREMENT';
16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';
22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';
23:

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

16: g_item CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ITEM';
17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';
22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';
23:
24: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK

Line 21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';

17: g_document CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DOCUMENT';
18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';
22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';
23:
24: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK
25: -- Type : PROCEDURE

Line 22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';

18: g_others CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'OTHERS';
19: g_deliverables CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DELIVERABLES';
20: g_dlvr_types CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA_DLVR_TYPES';
21: g_dlv_action_ship CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'WSH';
22: g_dlv_action_proc CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE:= 'REQ';
23:
24: -- SubProgram : CREATE_DLV_ACTIONS_IN_BULK
25: -- Type : PROCEDURE
26: -- Purpose : Public API to create to Deliverable Actions

Line 116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

112: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
113: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
119: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
120: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

360: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
361: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null
363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 549: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'
548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
549: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
550: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
551: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
552: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
553: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

756: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
757: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
763: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
764: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 1449: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

1445: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1446: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1447: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
1448: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
1449: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
1450: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1451: ,p_carrying_out_org_id IN NUMBER := null
1452: ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1453: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null

Line 1484: l_function_code PA_LOOKUPS.LOOKUP_CODE%TYPE := NULL;

1480: l_completed_date DATE ;
1481: l_completed_flag VARCHAR2(1) ;
1482:
1483: l_is_dlv_itembased VARCHAR2(1);
1484: l_function_code PA_LOOKUPS.LOOKUP_CODE%TYPE := NULL;
1485: l_function_code_valid VARCHAR2(1) := 'N';
1486: l_carrying_out_org_id NUMBER;
1487: l_action_owner_id NUMBER;
1488:

Line 4367: ,p_function IN pa_lookups.lookup_code%TYPE

4363: PROCEDURE RUN_ACTION_CONC_PROCESS
4364: (
4365: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4366: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4367: ,p_function IN pa_lookups.lookup_code%TYPE
4368: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL
4369: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL
4370: )
4371: IS

Line 4885: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

4881: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4882: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4883: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4884: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4885: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
4886: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
4887: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
4888: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
4889: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'