APPS.CSFW_DEBRIEF_PUB dependencies on DUAL

Line 22: cursor c_header_id is select CSF_DEBRIEF_HEADERS_S1.nextval from dual;

18: l_user number;
19: l_data varchar2(2000);
20: l_msg_index_out number;
21:
22: cursor c_header_id is select CSF_DEBRIEF_HEADERS_S1.nextval from dual;
23: cursor c_header_number is select CSF_DEBRIEF_HEADERS_S2.nextval from dual;
24:
25: Begin
26: p_error_id := 0; --Assume success

Line 23: cursor c_header_number is select CSF_DEBRIEF_HEADERS_S2.nextval from dual;

19: l_data varchar2(2000);
20: l_msg_index_out number;
21:
22: cursor c_header_id is select CSF_DEBRIEF_HEADERS_S1.nextval from dual;
23: cursor c_header_number is select CSF_DEBRIEF_HEADERS_S2.nextval from dual;
24:
25: Begin
26: p_error_id := 0; --Assume success
27:

Line 191: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;

187:
188: r_find_resource find_resource%ROWTYPE;
189:
190:
191: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
192:
193: cursor c_uom_code(v_org_id number, v_item_id number)
194: is
195: select primary_uom_code from mtl_system_items_vl

Line 565: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;

561: l_expenditure_org_id number;
562: l_project_id number;
563: l_project_task_id number;
564:
565: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
566: cursor c_uom_code (v_org_id number, v_item_id number)
567: is
568: select primary_uom_code from mtl_system_items_vl
569: where organization_id = v_org_id

Line 1279: --select FND_GLOBAL.user_id into l_user from dual;

1275: fetch c_DEBRIEF_HEADER_ID into l_header_id;
1276: close c_DEBRIEF_HEADER_ID;
1277:
1278:
1279: --select FND_GLOBAL.user_id into l_user from dual;
1280: l_user :=FND_GLOBAL.user_id ;
1281:
1282: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1283:

Line 1719: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;

1715: cursor c_DEBRIEF_HEADER_ID(v_dbf_nr varchar2) is
1716: select DEBRIEF_HEADER_ID from csf_debrief_headers where debrief_number = v_dbf_nr;
1717:
1718:
1719: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1720:
1721: cursor c_status_name(v_partStatusCd varchar2) is
1722: select name
1723: from csi_instance_statuses