APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 1492: FROM pa_object_page_layouts

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

Line 1574: -- remove from pa_object_page_layouts table

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

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

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

Line 1578: DELETE FROM pa_object_page_layouts

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

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

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

Line 1758: -- we will insert into pa_object_page_layouts

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

Line 1837: -- we will insert into pa_object_page_layouts

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

Line 2184: FROM pa_object_page_layouts p1,

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

Line 2434: FROM pa_object_page_layouts p1,

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

Line 2456: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

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

Line 3211: FROM pa_object_page_layouts popl, pa_page_layouts ppl

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