APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_PUB

Line 95: l_deb_rec csf_debrief_pub.debrief_rec_type;

91: where task_assignment_id = b_task_assignment_id;
92:
93: r_deb_head c_deb_head%rowtype;
94:
95: l_deb_rec csf_debrief_pub.debrief_rec_type;
96: l_line_rec csf_debrief_pub.debrief_line_rec_type;
97: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
98:
99: l_debrief_header_id number;

Line 96: l_line_rec csf_debrief_pub.debrief_line_rec_type;

92:
93: r_deb_head c_deb_head%rowtype;
94:
95: l_deb_rec csf_debrief_pub.debrief_rec_type;
96: l_line_rec csf_debrief_pub.debrief_line_rec_type;
97: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
98:
99: l_debrief_header_id number;
100: l_date date := sysdate;

Line 97: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;

93: r_deb_head c_deb_head%rowtype;
94:
95: l_deb_rec csf_debrief_pub.debrief_rec_type;
96: l_line_rec csf_debrief_pub.debrief_line_rec_type;
97: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
98:
99: l_debrief_header_id number;
100: l_date date := sysdate;
101:

Line 169: csf_debrief_pub.create_debrief

165: l_deb_rec.TRAVEL_START_TIME := p_record.TRAVEL_START_TIME;
166: l_deb_rec.TRAVEL_END_TIME := p_record.TRAVEL_END_TIME;
167: l_deb_rec.TRAVEL_DISTANCE_IN_KM := p_record.TRAVEL_DISTANCE_IN_KM;
168: -- Create a debrief header.
169: csf_debrief_pub.create_debrief
170: ( p_api_version_number => 1.0
171: , p_init_msg_list => FND_API.G_TRUE
172: , p_commit => FND_API.G_FALSE
173: , p_debrief_rec => l_deb_rec

Line 190: || ' ROOT ERROR: csf_debrief_pub.create_debrief'

186: (
187: p_api_error => TRUE
188: );
189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
190: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
191: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: return;
194: ELSE

Line 322: csf_debrief_pub.Update_debrief(

318: l_deb_rec.TRAVEL_DISTANCE_IN_KM := p_record.TRAVEL_DISTANCE_IN_KM;
319:
320:
321: -- update the debrief line
322: csf_debrief_pub.Update_debrief(
323: p_api_version_number => 1.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_FALSE,
326: p_debrief_rec => l_deb_rec,

Line 341: || ' ROOT ERROR: csf_debrief_pub.create_debrief'

337: (
338: p_api_error => TRUE
339: );
340: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
341: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
342: || ' for PK ' || r_deb_head.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: return;
345: end if;

Line 395: l_deb_rec csf_debrief_pub.debrief_rec_type;

391: ;
392:
393: r_debrief_header c_debrief_header%ROWTYPE;
394: l_profile_value varchar2(240);
395: l_deb_rec csf_debrief_pub.debrief_rec_type;
396: l_date date := sysdate;
397: -- Declare OUT parameters
398: l_msg_count NUMBER;
399: l_msg_data VARCHAR2(240);

Line 471: csf_debrief_pub.Update_debrief(

467: l_deb_rec.TRAVEL_END_TIME := p_record.TRAVEL_END_TIME;
468: l_deb_rec.TRAVEL_DISTANCE_IN_KM := p_record.TRAVEL_DISTANCE_IN_KM;
469:
470: -- update the debrief line
471: csf_debrief_pub.Update_debrief(
472: p_api_version_number => 1.0,
473: p_init_msg_list => FND_API.G_TRUE,
474: p_commit => FND_API.G_FALSE,
475: p_debrief_rec => l_deb_rec,

Line 490: || ' ROOT ERROR: csf_debrief_pub.update_debrief'

486: (
487: p_api_error => TRUE
488: );
489: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
490: || ' ROOT ERROR: csf_debrief_pub.update_debrief'
491: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RETURN;
494: END IF;