APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_PUB

Line 94: l_deb_rec csf_debrief_pub.debrief_rec_type;

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

Line 95: l_line_rec csf_debrief_pub.debrief_line_rec_type;

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

Line 96: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;

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

Line 166: csf_debrief_pub.create_debrief

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

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

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

Line 319: csf_debrief_pub.Update_debrief(

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

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

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

Line 392: l_deb_rec csf_debrief_pub.debrief_rec_type;

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

Line 466: csf_debrief_pub.Update_debrief(

462: l_deb_rec.TRAVEL_END_TIME := p_record.TRAVEL_END_TIME;
463: l_deb_rec.TRAVEL_DISTANCE_IN_KM := p_record.TRAVEL_DISTANCE_IN_KM;
464:
465: -- update the debrief line
466: csf_debrief_pub.Update_debrief(
467: p_api_version_number => 1.0,
468: p_init_msg_list => FND_API.G_TRUE,
469: p_commit => FND_API.G_FALSE,
470: p_debrief_rec => l_deb_rec,

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

481: (
482: p_api_error => TRUE
483: );
484: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
485: || ' ROOT ERROR: csf_debrief_pub.update_debrief'
486: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: RETURN;
489: END IF;