[Home] [Help]
4851: cursor csr_valid_eff_date(p_position_id number,
4852: p_validation_start_date date,
4853: p_validation_end_date date) is
4854: select p_validation_start_date start_date
4855: from dual
4856: union
4857: select effective_start_date start_date
4858: from hr_all_positions_f
4859: where effective_start_date between p_validation_start_date
7349: l_exists := NULL;
7350: begin
7351: select '1'
7352: into l_exists
7353: from sys.dual
7354: where exists(SELECT NULL
7355: from PER_BUDGET_ELEMENTS BE
7356: where BE.POSITION_ID = p_position_id);
7357: exception when no_data_found then
7367: end if;
7368: begin
7369: select '1'
7370: into l_exists
7371: from sys.dual
7372: where exists(SELECT NULL
7373: from PER_ALL_VACANCIES VAC
7374: where VAC.POSITION_ID = p_position_id);
7375: exception when no_data_found then
7407: -- if l_pos_structure_element_id is null then -- condition removed (Bug 9146790)
7408: begin
7409: select '1'
7410: into l_exists
7411: from sys.dual
7412: where exists(SELECT NULL
7413: FROM PER_POS_STRUCTURE_ELEMENTS PSE
7414: WHERE PSE.PARENT_POSITION_ID = p_position_id
7415: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
7431: end if;
7432: begin
7433: select '1'
7434: into l_exists
7435: from sys.dual
7436: where exists(SELECT NULL
7437: FROM PER_VALID_GRADES VG1
7438: WHERE business_group_id + 0 = p_business_group_id
7439: AND VG1.POSITION_ID = p_position_id);
7453: end if;
7454: begin
7455: select '1'
7456: into l_exists
7457: from sys.dual
7458: where exists(select null
7459: from per_job_requirements jre1
7460: where jre1.position_id = p_position_id);
7461: exception when no_data_found then
7471: end if;
7472: begin
7473: select '1'
7474: into l_exists
7475: from sys.dual
7476: where exists(select null
7477: from per_job_evaluations jev1
7478: where jev1.position_id = p_position_id);
7479: exception when no_data_found then
7490: end if;
7491: begin
7492: select '1'
7493: into l_exists
7494: from sys.dual
7495: where exists(select null
7496: from hr_all_positions_f
7497: where successor_position_id = p_position_id);
7498: exception when no_data_found then
7511: end if;
7512: begin
7513: select '1'
7514: into l_exists
7515: from sys.dual
7516: where exists(select null
7517: from hr_all_positions_f
7518: where supervisor_position_id = p_position_id);
7519: exception when no_data_found then
7533: /*
7534: begin
7535: select '1'
7536: into l_exists
7537: from sys.dual
7538: where exists(select null
7539: from per_position_extra_info
7540: where position_id = p_position_id);
7541: exception when no_data_found then
7553:
7554: begin
7555: select '1'
7556: into l_exists
7557: from sys.dual
7558: where exists(select null
7559: from per_mm_positions
7560: where new_position_id = p_position_id);
7561: exception when no_data_found then
7575: --
7576: begin
7577: select '1'
7578: into l_exists
7579: from sys.dual
7580: where exists(select null
7581: from pqh_position_transactions
7582: where position_id = p_position_id);
7583: exception when no_data_found then
7596: --
7597: begin
7598: select '1'
7599: into l_exists
7600: from sys.dual
7601: where exists(select null
7602: from pqh_attribute_ranges
7603: where position_id = p_position_id);
7604: exception when no_data_found then
7617: --
7618: begin
7619: select '1'
7620: into l_exists
7621: from sys.dual
7622: where exists(select null
7623: from pqh_budgets
7624: where position_id = p_position_id);
7625: exception when no_data_found then
7638: --
7639: begin
7640: select '1'
7641: into l_exists
7642: from sys.dual
7643: where exists(select null
7644: from pqh_worksheet_details
7645: where position_id = p_position_id);
7646: exception when no_data_found then
7658: -- fix for bug 8439584
7659: -- if p_po_ins = 'Y' then
7660: begin
7661: l_sql_text := 'select null '
7662: ||' from sys.dual '
7663: ||' where exists( select null '
7664: ||' from po_system_parameters '
7665: ||' where security_position_structure_id = '
7666: ||to_char(p_position_id)
8186: l_proc varchar2(72) := g_package||'chk_ref_int_del';
8187: --
8188: cursor csr_assgt is
8189: select null
8190: from sys.dual
8191: where exists(select null
8192: from per_all_assignments_f
8193: where position_id = p_position_id
8194: and (p_datetrack_mode = 'ZAP'
8196: and effective_start_date >= p_validation_start_date)));
8197:
8198: cursor csr_element_links is
8199: select null
8200: from sys.dual
8201: where exists(select null
8202: from pay_element_links_f
8203: where position_id = p_position_id
8204: and (p_datetrack_mode = 'ZAP'
8206: and effective_start_date >= p_validation_start_date)));
8207:
8208: cursor csr_budget_details is
8209: select null
8210: from sys.dual
8211: where exists(select null
8212: from pqh_budget_details
8213: where position_id = p_position_id
8214: and p_datetrack_mode = 'ZAP');