2817:
2818: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2819: FND_LOG.LEVEL_PROCEDURE );
2820:
2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2822: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2823:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2818: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_INS',
2819: FND_LOG.LEVEL_PROCEDURE );
2820:
2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2822: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2823:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:
2820:
2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2822: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2823:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:
2827: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'I');
2828:
2821: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2822: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2823:
2824: -- l_src:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_type; --remains NULL thru iUhk
2825: -- l_src_id:=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.source_id;
2826:
2827: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'I');
2828:
2829: --Notify User of new Order placed
2858:
2859: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2860: FND_LOG.LEVEL_PROCEDURE );
2861:
2862: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2863: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2864:
2865: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'U');
2866:
2859: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2860: FND_LOG.LEVEL_PROCEDURE );
2861:
2862: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2863: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2864:
2865: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'U');
2866:
2867: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_POST_UPD',
2893:
2894: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2895: FND_LOG.LEVEL_PROCEDURE );
2896:
2897: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2898: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2899:
2900: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'D');
2901:
2894: CSM_UTIL_PKG.LOG('Entering CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',
2895: FND_LOG.LEVEL_PROCEDURE );
2896:
2897: l_req_line_id :=CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID; --CSF tech portal seems to pass this wrongly
2898: l_req_line_detail_id := CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.req_line_detail_id; --only this is passed correctly from all src
2899:
2900: csm_csp_req_lines_event_pkg.REQ_LINE_DTL_IUD(l_req_line_detail_id,'D');
2901:
2902: CSM_UTIL_PKG.LOG('Leaving CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL', 'CSM_WF_PKG.CSP_REQ_LINE_DETAILS_PRE_DEL',