APPS.PA_SCHEDULE_PVT dependencies on DUAL

Line 5477: FROM DUAL;

5473: SELECT DECODE(p_start_date, null, temp_start_date, p_start_date),
5474: DECODE(p_end_date, null, temp_end_date, p_end_date)
5475: INTO l_start_date,
5476: l_end_date
5477: FROM DUAL;
5478: ELSE
5479: l_start_date := temp_start_date;
5480: l_end_date := temp_end_date;
5481: END IF;

Line 5602: FROM DUAL;

5598: SELECT DECODE(p_start_date, null, temp_start_date, p_start_date),
5599: DECODE(p_end_date, null, temp_end_date, p_end_date)
5600: INTO l_start_date,
5601: l_end_date
5602: FROM DUAL;
5603: ELSE
5604: IF (p_number_of_shift is NOT NULL) THEN
5605: -- compute shifted_days
5606: IF (p_duration_shift_unit_code = 'DAYS') THEN

Line 6104: from dual;

6100: l_intra_txn_conflict_flag_tbl(l_intra_txn_conflict_flag_tbl.LAST) := 'N';
6101: ELSE
6102: select v_c1.assignment_id, 'N'
6103: bulk collect into l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6104: from dual;
6105: -- l_assignment_id_tbl(1) := v_c1.assignment_id;
6106: -- l_intra_txn_conflict_flag_tbl(1) := 'N';
6107: END IF;
6108: END IF;

Line 7147: FROM DUAL;

7143: FOR v_c2 in c2 LOOP
7144:
7145: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
7146: INTO l_item_key
7147: FROM DUAL;
7148:
7149: l_conflict_proj_id := v_c2.project_id;
7150: l_conflict_proj_mgr_id := PA_PROJECTS_MAINT_UTILS.get_project_manager(v_c2.project_id);
7151: PA_SCHEDULE_UTILS.debug('l_conflict_proj_mgr_id = '||l_conflict_proj_mgr_id);

Line 7309: FROM DUAL;

7305: PA_SCHEDULE_UTILS.debug('Send self overcommitment notifications');
7306: -- Create the WF process
7307: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
7308: INTO l_item_key
7309: FROM DUAL;
7310: wf_engine.CreateProcess ( ItemType => l_item_type,
7311: ItemKey => l_item_key,
7312: process => 'PRO_SELF_OVC_WARN');
7313: