APPS.PA_SCHEDULE_PVT dependencies on DUAL

Line 5765: FROM DUAL;

5761: SELECT DECODE(p_start_date, null, temp_start_date, p_start_date),
5762: DECODE(p_end_date, null, temp_end_date, p_end_date)
5763: INTO l_start_date,
5764: l_end_date
5765: FROM DUAL;
5766: ELSE
5767: l_start_date := temp_start_date;
5768: l_end_date := temp_end_date;
5769: END IF;

Line 5890: FROM DUAL;

5886: SELECT DECODE(p_start_date, null, temp_start_date, p_start_date),
5887: DECODE(p_end_date, null, temp_end_date, p_end_date)
5888: INTO l_start_date,
5889: l_end_date
5890: FROM DUAL;
5891: ELSE
5892: IF (p_number_of_shift is NOT NULL) THEN
5893: -- compute shifted_days
5894: IF (p_duration_shift_unit_code = 'DAYS') THEN

Line 6397: from dual;

6393: l_intra_txn_conflict_flag_tbl(l_intra_txn_conflict_flag_tbl.LAST) := 'N';
6394: ELSE
6395: select v_c1.assignment_id, 'N'
6396: bulk collect into l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6397: from dual;
6398: -- l_assignment_id_tbl(1) := v_c1.assignment_id;
6399: -- l_intra_txn_conflict_flag_tbl(1) := 'N';
6400: END IF;
6401: END IF;

Line 7440: FROM DUAL;

7436: FOR v_c2 in c2 LOOP
7437:
7438: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
7439: INTO l_item_key
7440: FROM DUAL;
7441:
7442: l_conflict_proj_id := v_c2.project_id;
7443: l_conflict_proj_mgr_id := PA_PROJECTS_MAINT_UTILS.get_project_manager(v_c2.project_id);
7444: PA_SCHEDULE_UTILS.debug('l_conflict_proj_mgr_id = '||l_conflict_proj_mgr_id);

Line 7602: FROM DUAL;

7598: PA_SCHEDULE_UTILS.debug('Send self overcommitment notifications');
7599: -- Create the WF process
7600: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
7601: INTO l_item_key
7602: FROM DUAL;
7603: wf_engine.CreateProcess ( ItemType => l_item_type,
7604: ItemKey => l_item_key,
7605: process => 'PRO_SELF_OVC_WARN');
7606: