APPS.CSL_DEBRIEF_PKG dependencies on CSF_DEBRIEF_PUB

Line 79: l_deb_rec csf_debrief_pub.debrief_rec_type;

75: WHERE debrief_header_id = b_debrief_header_id;
76:
77: r_csf_debrief_headers c_csf_debrief_headers%ROWTYPE;
78:
79: l_deb_rec csf_debrief_pub.debrief_rec_type;
80: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
81:
82: l_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE;
83:

Line 80: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;

76:
77: r_csf_debrief_headers c_csf_debrief_headers%ROWTYPE;
78:
79: l_deb_rec csf_debrief_pub.debrief_rec_type;
80: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
81:
82: l_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE;
83:
84: l_date DATE;

Line 132: csf_debrief_pub.create_debrief

128: l_deb_rec.attribute14 := r_csf_debrief_headers.attribute14;
129: l_deb_rec.attribute15 := r_csf_debrief_headers.attribute15;
130: l_deb_rec.attribute_category := r_csf_debrief_headers.attribute_category;
131:
132: csf_debrief_pub.create_debrief
133: ( p_api_version_number => 1.0
134: , p_init_msg_list => FND_API.G_TRUE
135: , p_commit => FND_API.G_FALSE
136: , p_debrief_rec => l_deb_rec

Line 624: l_line_rec csf_debrief_pub.debrief_line_rec_type;

620: l_transaction_id NUMBER;
621: l_transaction_header_id NUMBER;
622:
623: -- l_line_rec and l_line_tbl are record/table types from the debrief API
624: l_line_rec csf_debrief_pub.debrief_line_rec_type;
625: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
626:
627: BEGIN
628:

Line 625: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;

621: l_transaction_header_id NUMBER;
622:
623: -- l_line_rec and l_line_tbl are record/table types from the debrief API
624: l_line_rec csf_debrief_pub.debrief_line_rec_type;
625: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
626:
627: BEGIN
628:
629: l_date := SYSDATE;

Line 816: csf_debrief_pub.create_debrief_lines

812: );
813: FETCH c_task_obj_code INTO r_task_obj_code;
814: CLOSE c_task_obj_code;
815:
816: csf_debrief_pub.create_debrief_lines
817: ( p_api_version_number => 1.0
818: , p_init_msg_list => FND_API.G_TRUE
819: , p_commit => FND_API.G_FALSE
820: , x_return_status => x_return_status

Line 920: l_deb_rec csf_debrief_pub.debrief_rec_type;

916: SELECT * FROM CSL_CSF_DEBRIEF_HEADERS_INQ
917: WHERE debrief_header_id = b_debrief_header_id;
918: r_csf_debrief_headers c_csf_debrief_headers%ROWTYPE;
919:
920: l_deb_rec csf_debrief_pub.debrief_rec_type;
921: l_date DATE;
922:
923: l_return_status VARCHAR2(1);
924: l_msg_count NUMBER;

Line 1009: csf_debrief_pub.update_debrief

1005: l_deb_rec.attribute14 := r_csf_debrief_headers.attribute14;
1006: l_deb_rec.attribute15 := r_csf_debrief_headers.attribute15;
1007: l_deb_rec.attribute_category := r_csf_debrief_headers.attribute_category;
1008:
1009: csf_debrief_pub.update_debrief
1010: ( p_api_version_number => 1.0
1011: , p_init_msg_list => FND_API.G_TRUE
1012: , p_commit => FND_API.G_FALSE
1013: , p_debrief_rec => l_deb_rec