APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_SERVICE_PACKAGES

Line 1865: from PSB_SERVICE_PACKAGES

1861: l_return_status VARCHAR2(1);
1862:
1863: cursor c_sp is
1864: select *
1865: from PSB_SERVICE_PACKAGES
1866: where global_worksheet_id = p_local_worksheet_id;
1867:
1868: cursor c_sp_exists (name VARCHAR2) is
1869: select service_package_id

Line 1870: from PSB_SERVICE_PACKAGES

1866: where global_worksheet_id = p_local_worksheet_id;
1867:
1868: cursor c_sp_exists (name VARCHAR2) is
1869: select service_package_id
1870: from PSB_SERVICE_PACKAGES
1871: where short_name = name
1872: and global_worksheet_id = g_global_worksheet_id;
1873:
1874: cursor c_sp_seq is

Line 1875: select PSB_SERVICE_PACKAGES_S.NEXTVAL seq

1871: where short_name = name
1872: and global_worksheet_id = g_global_worksheet_id;
1873:
1874: cursor c_sp_seq is
1875: select PSB_SERVICE_PACKAGES_S.NEXTVAL seq
1876: from dual;
1877:
1878: BEGIN
1879:

Line 1897: insert into PSB_SERVICE_PACKAGES

1893: for c_sp_seq_rec in c_sp_seq loop
1894: l_service_package_id := c_sp_seq_rec.seq;
1895: end loop;
1896:
1897: insert into PSB_SERVICE_PACKAGES
1898: (service_package_id, global_worksheet_id, base_service_package, name,
1899: short_name, description, priority, last_update_date, last_updated_by,
1900: last_update_login, created_by, creation_date)
1901: values (l_service_package_id, g_global_worksheet_id, c_sp_rec.base_service_package, c_sp_rec.name,

Line 2020: from PSB_SERVICE_PACKAGES a,

2016: and b.worksheet_id = p_global_worksheet_id);
2017:
2018: cursor c_re_sp (spid NUMBER) is
2019: select a.service_package_id
2020: from PSB_SERVICE_PACKAGES a,
2021: PSB_SERVICE_PACKAGES b
2022: where a.short_name = b.short_name
2023: and a.global_worksheet_id = g_global_worksheet_id
2024: and b.service_package_id = spid;

Line 2021: PSB_SERVICE_PACKAGES b

2017:
2018: cursor c_re_sp (spid NUMBER) is
2019: select a.service_package_id
2020: from PSB_SERVICE_PACKAGES a,
2021: PSB_SERVICE_PACKAGES b
2022: where a.short_name = b.short_name
2023: and a.global_worksheet_id = g_global_worksheet_id
2024: and b.service_package_id = spid;
2025: