APPS.PA_PROGRESS_REPORT_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1962: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292

1958:
1959: IS
1960:
1961: l_rowid ROWID;
1962: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292
1963: l_wf_status VARCHAR2(30);
1964: l_dummy VARCHAR2(1);
1965:
1966: l_item_type VARCHAR2(30);

Line 1986: -- from wf_item_activity_statuses

1982: -- CURSOR get_wf_status IS
1983: -- select 'Y' FROM dual
1984: -- WHERE exists
1985: -- (SELECT *
1986: -- from wf_item_activity_statuses
1987: -- WHERE item_type = 'PAWFPPRA'
1988: -- AND item_key = l_item_key
1989: -- AND activity_status = 'ACTIVE');
1990: CURSOR get_wf_status IS

Line 1994: from wf_item_activity_statuses wias, pa_project_statuses pps

1990: CURSOR get_wf_status IS
1991: select 'Y' FROM dual
1992: WHERE exists
1993: (SELECT *
1994: from wf_item_activity_statuses wias, pa_project_statuses pps
1995: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
1996: AND wias.item_key = l_item_key
1997: AND wias.activity_status = 'ACTIVE'
1998: AND pps.status_type = 'PROGRESS_REPORT'

Line 2175: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292

2171: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2172: ) IS
2173:
2174: l_rowid ROWID;
2175: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292
2176: l_wf_status VARCHAR2(30);
2177: l_item_type VARCHAR2(30);
2178: l_dummy VARCHAR2(30) := 'N';
2179:

Line 2214: -- from wf_item_activity_statuses

2210: -- CURSOR get_wf_status IS
2211: -- select 'Y' FROM dual
2212: -- WHERE exists
2213: -- (SELECT *
2214: -- from wf_item_activity_statuses
2215: -- WHERE item_type = 'PAWFPPRA'
2216: -- AND item_key = l_item_key
2217: -- AND activity_status = 'ACTIVE');
2218:

Line 2223: from wf_item_activity_statuses wias, pa_project_statuses pps

2219: CURSOR get_wf_status IS
2220: select 'Y' FROM dual
2221: WHERE exists
2222: (SELECT *
2223: from wf_item_activity_statuses wias, pa_project_statuses pps
2224: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
2225: AND wias.item_key = l_item_key
2226: AND wias.activity_status = 'ACTIVE'
2227: AND pps.status_type = 'PROGRESS_REPORT'

Line 2728: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292

2724: AND report_status_code = 'PROGRESS_REPORT_WORKING';
2725:
2726:
2727:
2728: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292
2729: l_dummy VARCHAR2(1);
2730:
2731: CURSOR get_template_type
2732: is

Line 2964: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292

2960: x_report_end_date DATE;
2961: x_version_id NUMBER;
2962: l_record_version_number NUMBER;
2963: l_summary_version_number NUMBER;
2964: l_item_key wf_item_activity_statuses.item_key%TYPE; --Bug 5217292
2965: l_dummy VARCHAR2(1);
2966:
2967: CURSOR get_object_id IS
2968: SELECT object_id, report_end_date, report_type_id