[Home] [Help]
108: l_progress := '050';
109:
110: -- delete the orig info template values
111: FORALL idx IN 1..l_line_ids.COUNT
112: DELETE FROM por_template_info
113: WHERE requisition_line_id = l_line_ids(idx);
114:
115: l_progress := '060';
116:
1292: l_progress := '090';
1293:
1294: -- flip the orig info template values
1295: FORALL idx IN 1..p_tempLineIds.COUNT
1296: UPDATE por_template_info
1297: SET requisition_line_id = p_origLineIds(idx)
1298: WHERE requisition_line_id = p_tempLineIds(idx);
1299:
1300: l_progress := '100';
3294: -- API Name : create_info_template
3295: -- Type : Public
3296: -- Pre-reqs : None
3297: -- Function : Copies the information template data from the old_req_line to the record
3298: -- corresponding new_req_line in the table POR_TEMPLATE_INFO while
3299: -- creating a new req line. This will be called by Core Purchasing
3300: -- Parameters : p_old_reqline_id IN NUMBER : Corresponds to the existing requisition line id
3301: -- p_new_reqline_id IN NUMBER : Corresponds to the new requisition line id
3302: -- p_item_id IN NUMBER : Corresponds to the item id of the line
3351: l_info_templ_count NUMBER;
3352:
3353: --Get the template from the existing line
3354: CURSOR c_parent_info_template IS
3355: SELECT * FROM POR_TEMPLATE_INFO WHERE REQUISITION_LINE_ID = p_old_reqline_id;
3356:
3357: BEGIN
3358:
3359: l_progress := '010';
3454:
3455: CLOSE c_parent_info_template;
3456:
3457: l_progress := '050';
3458: --Inserting into POR_TEMPLATE_INFO
3459:
3460: FOR i IN 1..l_requisition_line_id.COUNT LOOP
3461:
3462:
3484: AND ASSOC.ITEM_OR_CATEGORY_ID = p_category_id)) ;
3485: --Insert a template record to the new line only if the template is still valid.
3486: IF(l_info_templ_count > 0) THEN
3487:
3488: INSERT INTO POR_TEMPLATE_INFO
3489: (
3490: REQUISITION_LINE_ID,
3491: ATTRIBUTE_CODE,
3492: ATTRIBUTE_LABEL_LONG,