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 152: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;

148:
149: r_find_resource find_resource%ROWTYPE;
150:
151:
152: cursor c_dbf_line_id is select CSF_DEBRIEF_LINES_S.nextval from dual;
153:
154: cursor c_uom_code(v_org_id number, v_item_id number)
155: is
156: select primary_uom_code from mtl_system_items_vl

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

363: l_estimate_detail_id NUMBER;
364: l_line_number NUMBER;
365: l_charge_Entry VARCHAR2(1);
366:
367: cursor c_dbf_lineId is select CSF_DEBRIEF_LINES_S.nextval from dual;
368: cursor c_uom_code (v_org_id number, v_item_id number)
369: is
370: select primary_uom_code from mtl_system_items_vl
371: where organization_id = v_org_id

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

668: fetch c_DEBRIEF_HEADER_ID into l_header_id;
669: close c_DEBRIEF_HEADER_ID;
670:
671:
672: --select FND_GLOBAL.user_id into l_user from dual;
673: l_user :=FND_GLOBAL.user_id ;
674:
675: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
676:

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

1031: cursor c_DEBRIEF_HEADER_ID(v_dbf_nr varchar2) is
1032: select DEBRIEF_HEADER_ID from csf_debrief_headers where debrief_number = v_dbf_nr;
1033:
1034:
1035: cursor c_dbf_lines is select CSF_DEBRIEF_LINES_S.nextval from dual;
1036:
1037: cursor c_status_name(v_partStatusCd varchar2) is
1038: select name
1039: from csi_instance_statuses