APPS.PA_PROGRESS_REPORT_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

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

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

Line 1985: -- from wf_item_activity_statuses

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

Line 1993: from wf_item_activity_statuses wias, pa_project_statuses pps

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

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

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

Line 2213: -- from wf_item_activity_statuses

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

Line 2222: from wf_item_activity_statuses wias, pa_project_statuses pps

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

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

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

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

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