120: l_login_id := fnd_global.login_id;
121: IF l_login_id = -1 THEN
122: l_login_id := fnd_global.conc_login_id;
123: END IF;
124: l_ship_complete := fnd_profile.value(name => 'CSP_SHIP_COMPLETE');
125: IF l_ship_complete ='Y' THEN
126: l_ship_set := TO_CHAR(1);
127: END IF;
128: OPEN product_task_id(p_task_id);
143: l_requirement_header_rec.LAST_UPDATE_DATE := SYSDATE;
144: l_requirement_header_rec.LAST_UPDATE_LOGIN:= l_login_id;
145: l_requirement_header_rec.OPEN_REQUIREMENT := 'Yes';
146: l_requirement_header_rec.TASK_ID := p_task_id;
147: l_requirement_header_rec.order_type_id := fnd_profile.value(name => 'CSP_ORDER_TYPE');
148: l_requirement_header_rec.address_type := 'R';
149: CSP_Requirement_headers_PVT.Create_requirement_headers(
150: P_Api_Version_Number => l_api_version_number
151: ,P_Init_Msg_List => FND_API.G_FALSE
166: END IF;
167: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
168: If l_manual_quantity is null then
169: IF l_rollup_quantity is not null THEN
170: IF l_times_used >= FND_PROFILE.value(name => 'CSP_PROD_TASK_HIST_RULE') Then
171: count1 := count1 + 1;
172: l_requirement_line_tbl(count1).CREATED_BY := l_user_id;
173: l_requirement_line_tbl(count1).CREATION_DATE := SYSDATE;
174: l_requirement_line_tbl(count1).LAST_UPDATED_BY := l_user_id;