APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_REQ_LINE_DETAILS_PKG

Line 697: csp_req_line_Details_pkg.Insert_Row(

693: SELECT csp_req_line_Details_s1.nextval
694: INTO l_req_line_Dtl_id
695: FROM dual;
696:
697: csp_req_line_Details_pkg.Insert_Row(
698: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
699: p_REQUIREMENT_LINE_ID => x_rqmt_line_tbl(I).requirement_line_id,
700: p_CREATED_BY => nvl(l_user_id, 1),
701: p_CREATION_DATE => sysdate,

Line 1314: csp_req_line_Details_pkg.Insert_Row(

1310: SELECT csp_req_line_Details_s1.nextval
1311: INTO l_req_line_Dtl_id
1312: FROM dual;
1313:
1314: csp_req_line_Details_pkg.Insert_Row(
1315: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1316: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1317: p_CREATED_BY => nvl(l_user_id, 1),
1318: p_CREATION_DATE => sysdate,

Line 1360: csp_req_line_Details_pkg.Insert_Row(

1356: SELECT csp_req_line_Details_s1.nextval
1357: INTO l_req_line_Dtl_id
1358: FROM dual;
1359:
1360: csp_req_line_Details_pkg.Insert_Row(
1361: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1362: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1363: p_CREATED_BY => nvl(l_user_id, 1),
1364: p_CREATION_DATE => sysdate,

Line 1398: csp_req_line_Details_pkg.Insert_Row(

1394: SELECT csp_req_line_Details_s1.nextval
1395: INTO l_req_line_Dtl_id
1396: FROM dual;
1397:
1398: csp_req_line_Details_pkg.Insert_Row(
1399: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1400: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
1401: p_CREATED_BY => nvl(l_user_id, 1),
1402: p_CREATION_DATE => sysdate,

Line 2631: csp_req_line_Details_pkg.Insert_Row(

2627: SELECT csp_req_line_Details_s1.nextval
2628: INTO l_req_line_Dtl_id
2629: FROM dual;
2630:
2631: csp_req_line_Details_pkg.Insert_Row(
2632: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2633: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2634: p_CREATED_BY => nvl(l_user_id, 1),
2635: p_CREATION_DATE => sysdate,

Line 2683: csp_req_line_Details_pkg.Insert_Row(

2679: SELECT csp_req_line_Details_s1.nextval
2680: INTO l_req_line_Dtl_id
2681: FROM dual;
2682:
2683: csp_req_line_Details_pkg.Insert_Row(
2684: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2685: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,
2686: p_CREATED_BY => nvl(l_user_id, 1),
2687: p_CREATION_DATE => sysdate,

Line 3063: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);

3059: FROM oe_order_lines_all
3060: WHERE line_id = l_source_id);
3061:
3062: else
3063: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);
3064: end if; -- if l_is_cancelled = 'N' then -- entered status
3065:
3066:
3067: elsif l_source_type = 'RES' then

Line 3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);

3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;
3086: raise EXCP_USER_DEFINED;
3087: else
3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);
3089: end if;
3090:
3091: -- we need to source the part for the new tech
3092: l_sch_option.resource_id := l_resource_id;