APPS.CSFW_DEBRIEF_PUB dependencies on CSF_DEBRIEF_HEADERS

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 1032: select DEBRIEF_HEADER_ID from csf_debrief_headers where debrief_number = v_dbf_nr;

1028: r_party c_party%ROWTYPE;
1029: */
1030:
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:

Line 2437: from CSF_DEBRIEF_HEADERS

2433: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
2434: ATTRIBUTE_CATEGORY, object_version_number,
2435: TRAVEL_START_TIME, TRAVEL_END_TIME,
2436: TRAVEL_DISTANCE_IN_KM
2437: from CSF_DEBRIEF_HEADERS
2438: where DEBRIEF_HEADER_ID = v_hrd_id
2439: and TASK_ASSIGNMENT_ID = v_asgn_id;
2440:
2441: Begin