APPS.CSP_SCH_INT_PVT dependencies on CSP_REQ_LINE_DETAILS_PKG

Line 1681: csp_req_line_details_pkg.insert_row(

1677: l_reservation_parts.revision := cap.supplied_item_rev;
1678: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1679: if x_return_status = FND_API.G_RET_STS_SUCCESS then
1680: l_req_line_details_id := null;
1681: csp_req_line_details_pkg.insert_row(
1682: l_req_line_details_id
1683: ,cap.requirement_line_id
1684: ,fnd_global.user_id
1685: ,sysdate

Line 1724: csp_req_line_details_pkg.insert_row(

1720: return;
1721: end if;
1722: for i in 1..l_parts_lines.count loop
1723: l_req_line_details_id := null;
1724: csp_req_line_details_pkg.insert_row(
1725: l_req_line_details_id
1726: ,l_parts_lines(i).requirement_line_id
1727: ,fnd_global.user_id
1728: ,sysdate

Line 1800: csp_req_line_details_pkg.insert_row(

1796: end if;
1797: for i in 1..l_parts_lines.count loop
1798: log('choose_option','Creating requirement line details');
1799: l_req_line_details_id := null;
1800: csp_req_line_details_pkg.insert_row(
1801: l_req_line_details_id
1802: ,l_parts_lines(i).requirement_line_id
1803: ,fnd_global.user_id
1804: ,sysdate

Line 2170: csp_req_line_details_pkg.insert_row(l_req_line_details_tbl(K).REQ_LINE_DETAIL_ID

2166: ROLLBACK TO choose_options;
2167: return;
2168: END IF;
2169: FOR K IN 1..l_req_line_details_tbl.count LOOP
2170: csp_req_line_details_pkg.insert_row(l_req_line_details_tbl(K).REQ_LINE_DETAIL_ID
2171: ,l_req_line_details_tbl(K).REQUIREMENT_LINE_ID
2172: ,fnd_global.user_id
2173: ,sysdate
2174: ,fnd_global.user_id

Line 2579: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);

2575: --x_return_status := FND_API.G_RET_STS_SUCCESS;
2576: rollback to CLEAN_MATERIAL_TRANSACTION;
2577: return;
2578: ELSE
2579: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);
2580: END IF;
2581: END LOOP;
2582: close get_reservations;
2583:

Line 2669: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);

2665: fnd_log.string(fnd_log.level_statement, l_module_name,
2666: 'deleting req_line_details for l_req_details_line_id = ' || l_req_details_line_id);
2667: end if;
2668:
2669: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);
2670: END LOOP;
2671: CLOSE get_line_details;
2672:
2673: END LOOP;

Line 8202: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id

8198: ,x_return_status
8199: ,x_msg_data );
8200: l_req_line_detali_id := NULL;
8201: IF l_reservation_id IS NOT NULL AND l_reservation_id >0 THEN
8202: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
8203: ,p_requirement_line_id => grd.requirement_line_id
8204: ,p_created_by => FND_GLOBAL.user_id
8205: ,p_creation_date => sysdate
8206: ,p_last_updated_by => FND_GLOBAL.user_id

Line 8213: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);

8209: ,p_source_type => 'RES'
8210: ,p_source_id => l_reservation_id );
8211:
8212: IF grd.quantity_shipped = grd.quantity_received THEN
8213: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);
8214: END IF;
8215: END IF;
8216: END LOOP;
8217: END CREATE_RES_FOR_RCV_TRANXS;

Line 8553: csp_req_line_details_pkg.delete_row(r_req_line_dtl_rec.req_line_detail_id);

8549:
8550: for r_req_line_dtl_rec in req_line_dtl_rows(old_res_record.requirement_line_id)
8551: loop
8552: log('move_parts_on_reassign', 'deleting req_line_detail_id=' || r_req_line_dtl_rec.req_line_detail_id);
8553: csp_req_line_details_pkg.delete_row(r_req_line_dtl_rec.req_line_detail_id);
8554: end loop;
8555:
8556: log('move_parts_on_reassign', 'before inserting a new req_line_detail...');
8557: l_req_line_detail_id := null;

Line 8558: csp_req_line_details_pkg.Insert_Row(

8554: end loop;
8555:
8556: log('move_parts_on_reassign', 'before inserting a new req_line_detail...');
8557: l_req_line_detail_id := null;
8558: csp_req_line_details_pkg.Insert_Row(
8559: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
8560: p_REQUIREMENT_LINE_ID => old_res_record.requirement_line_id,
8561: p_CREATED_BY => FND_GLOBAL.user_id,
8562: p_CREATION_DATE => sysdate,