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

1712: r_party c_party%ROWTYPE;
1713: */
1714:
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:

Line 3286: from CSF_DEBRIEF_HEADERS

3282: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
3283: ATTRIBUTE_CATEGORY, object_version_number,
3284: TRAVEL_START_TIME, TRAVEL_END_TIME,
3285: TRAVEL_DISTANCE_IN_KM
3286: from CSF_DEBRIEF_HEADERS
3287: where DEBRIEF_HEADER_ID = v_hrd_id
3288: and TASK_ASSIGNMENT_ID = v_asgn_id;
3289:
3290: Begin