APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 1493: FROM pa_object_page_layouts

1489:
1490: CURSOR check_object_page_layout_exits
1491: IS
1492: SELECT page_id, approval_required
1493: FROM pa_object_page_layouts
1494: WHERE
1495: object_page_layout_id = p_object_page_layout_id;
1496:
1497:

Line 1575: -- remove from pa_object_page_layouts table

1571:
1572:
1573: -- if page_name is not passed in, we will remove the pagelayout
1574: IF (p_page_name IS NULL) then
1575: -- remove from pa_object_page_layouts table
1576:
1577: --debug_msg('delete from pa_object_page_layouts' );
1578:
1579: DELETE FROM pa_object_page_layouts

Line 1577: --debug_msg('delete from pa_object_page_layouts' );

1573: -- if page_name is not passed in, we will remove the pagelayout
1574: IF (p_page_name IS NULL) then
1575: -- remove from pa_object_page_layouts table
1576:
1577: --debug_msg('delete from pa_object_page_layouts' );
1578:
1579: DELETE FROM pa_object_page_layouts
1580: WHERE object_id = p_object_id AND object_type = p_object_type
1581: AND page_type_code = p_page_type_code

Line 1579: DELETE FROM pa_object_page_layouts

1575: -- remove from pa_object_page_layouts table
1576:
1577: --debug_msg('delete from pa_object_page_layouts' );
1578:
1579: DELETE FROM pa_object_page_layouts
1580: WHERE object_id = p_object_id AND object_type = p_object_type
1581: AND page_type_code = p_page_type_code
1582: and nvl(report_Type_id,-99) = nvl(p_report_type_id,-99);
1583:

Line 1599: --debug_msg('delete from pa_object_page_layouts done' );

1595: ,x_msg_count => x_msg_count
1596: ,x_msg_data => x_msg_data);
1597: end if;
1598:
1599: --debug_msg('delete from pa_object_page_layouts done' );
1600:
1601:
1602: RETURN;
1603: ELSE

Line 1759: -- we will insert into pa_object_page_layouts

1755:
1756: IF check_object_page_layout_exits%NOTFOUND THEN
1757: CLOSE check_object_page_layout_exits;
1758:
1759: -- we will insert into pa_object_page_layouts
1760: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
1761:
1762: pa_progress_report_pkg.insert_object_page_layout_row
1763: (

Line 1838: -- we will insert into pa_object_page_layouts

1834: l_object_page_layout_id := x_object_page_layout_id;
1835: ELSE
1836: CLOSE check_object_page_layout_exits;
1837:
1838: -- we will insert into pa_object_page_layouts
1839: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
1840:
1841:
1842: pa_progress_report_pkg.update_object_page_layout_row

Line 2185: FROM pa_object_page_layouts p1,

2181: SELECT 'Y' FROM dual
2182: WHERE exists
2183: (
2184: SELECT p1.approval_required
2185: FROM pa_object_page_layouts p1,
2186: pa_progress_report_vers p2
2187: WHERE
2188: p2.version_id = p_version_id
2189: AND p2.object_id = p1.object_id

Line 2435: FROM pa_object_page_layouts p1,

2431: l_version_id NUMBER;
2432:
2433: CURSOR check_auto_approve IS
2434: SELECT p1.approval_required
2435: FROM pa_object_page_layouts p1,
2436: pa_progress_report_vers p2
2437: WHERE
2438: p2.version_id = l_version_id
2439: AND p2.object_id = p1.object_id

Line 2457: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

2453: popl.reminder_days, popl.reminder_days_type, popl.record_version_number,popl.pers_function_name,
2454: popl.page_type_code, popl.initial_progress_status, popl.final_progress_status,popl.rollup_progress_status,
2455: popl.report_type_id, popl.approver_source_id, popl.approver_source_type, popl.effective_from,
2456: popl.effective_to, popl.object_page_layout_id
2457: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv
2458: WHERE pprv.version_id = p_version_id
2459: AND popl.object_id = pprv.object_id
2460: AND popl.object_type = pprv.object_type
2461: AND popl.page_type_code = 'PPR'

Line 3212: FROM pa_object_page_layouts popl, pa_page_layouts ppl

3208:
3209: CURSOR get_page_id_type
3210: IS
3211: SELECT popl.page_id, popl.page_type_code, popl.reporting_cycle_id, popl.report_offset_days,popl.effective_from
3212: FROM pa_object_page_layouts popl, pa_page_layouts ppl
3213: WHERE popl.object_id = p_object_id
3214: AND popl.object_type = p_object_type
3215: AND popl.report_type_id = p_report_type_id
3216: AND popl.page_id = ppl.page_id